Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
hiding columns in Excell error message | Excel Discussion (Misc queries) | |||
Hiding error message | Excel Worksheet Functions | |||
hiding #DIV/0! message | Excel Discussion (Misc queries) | |||
hiding error message | Excel Worksheet Functions |