Hide Cells

Mar 12th, 2002, 04:25 PM

Anyone know how to get around this error message I keep
getting when I try to hide cells:

"Cannot shift objects off sheet"

Thank you.

Chris Davison · Mar 12th, 2002, 05:02 PM

http://www.mrexcel.com/board/viewtop...ic=914&forum=2

see if these help

Anne Troy · Mar 12th, 2002, 05:03 PM

Sure. Your file is either used a lot or has been used for a long time.

Go to the first completely blank column to the right of your data and select it by clicking on its column letter.

Now, hold Shift+Ctrl and hit the right arrow key once. Let go of the keys. From the menu, hit Edit-Clear-All.

Go to the first completely blank row at the bottom of your data and click on its row number.

Now, hold Shift+Ctrl and hit the down arrow key once. Let go of the keys. From the menu, hit Edit-Clear-All.

Save the file.
All done!

Mar 12th, 2002, 05:03 PM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Sure. Your file is either used a lot or has been used for a long time. Go to the first completely blank column to the right of your data and select it by clicking on its column letter. Now, hold Shift+Ctrl and hit the right arrow key once. Let go of the keys. From the menu, hit Edit-Clear-All. Go to the first completely blank row at the bottom of your data and click on its row number. Now, hold Shift+Ctrl and hit the down arrow key once. Let go of the keys. From the menu, hit Edit-Clear-All. Save the file. All done! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 04:25 PM	#1
Guest Posts: n/a	Anyone know how to get around this error message I keep getting when I try to hide cells: "Cannot shift objects off sheet" Thank you.

Mar 12th, 2002, 05:02 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	http://www.mrexcel.com/board/viewtop...ic=914&forum=2 see if these help