How do I Remove a Split from my Comments in Excel 2003?

G

Guest

I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.

I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.

How do turn this off.
 
G

Gord Dibben

Instead of Window>Split try selecting B3 then Window>Freeze Panes to hold top
2 rows and left column in view when scrolling.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel my comments are being cut off at the right margin 1
MSWord 2003 I want to remove 'split' 3
Excel comments moving and changing sizes 2
How do I freeze 2 top rows in Excel 2007 3
How do I change the defult settings for my comments in Excell? 5
How do I use freeze pane and split in the same excel spreadsheet 2
How do I display spreadsheet comments in a chart? 1
comments box gets chopped off by freeze panes! 2

Top