LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 185
Default Why do I get an error message hiding excel columns

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 EditDelete. (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
DTHIS
web:
www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"George" wrote in message
...
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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding columns, error message says cannot shift objects off sheet JORGE ORTIZ Excel Discussion (Misc queries) 11 August 19th 08 10:34 AM
hiding columns in Excell error message jude Excel Discussion (Misc queries) 2 October 12th 06 07:32 PM
Hiding error message Mark Flynn Excel Worksheet Functions 3 September 21st 06 10:08 PM
hiding #DIV/0! message GJR3599 Excel Discussion (Misc queries) 3 March 9th 05 08:13 PM
hiding error message Shooter Excel Worksheet Functions 3 January 27th 05 04:06 AM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"