Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

hiding columns

ResolvedVersion 2003

Andrea has attended:
Excel Intermediate course

Hiding columns

How do you hide columns on a sheet if you get the following message on the screen "cannot shift objects off the page"?
Every column has data but it is not allowing me to hide the columns I want.

RE: hiding columns

Hi Andrea

This problem occurs when you have a hidden comment or shape on the worksheet.

Detailed steps for resolving this issue can be found in the support link from Microsoft below. The support article lists two methods to resolve this issue, follow method two which applies to your version of Excel.

http://support.microsoft.com/kb/211769

Any problems please don't hesitate to repost. Thanks

Newson

Wed 21 Jul 2010: Automatically marked as resolved.

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.