Why do I get an error message hiding excel columns

[Guest]

MY error message says it will not hide a column as it
cant "shift objects of the page". I just want to hide the column!!
Help?

 

[Nick Hodge]

George

At some point you have had data at the periphery of the sheet (Column 256,
row 65536). This can be caused by lots of cell inserting, formatting whole
columns/rows, etc. Even though you can't see it, excel thinks it is still
there. To explicitly remove it. In you case for columns go to column IV and
select the entire column by clicking on the column label. Now go to the
first column after the last one with data and while holding the shift key
down, select this columns label. Now go to Edit>Delete. (Nothing appears to
happen). Now *save the workbook*. (If this is 2000 or before close excel and
restart after the save).

All should now be well (This is known as resetting excel's UsedRange)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

 

[Guest]

George,

Have a look here

http://support.microsoft.com/default.aspx?kbid=211769


Mike