Can make my coloms hidden

  • Thread starter Thread starter bou
  • Start date Start date
B

bou

When I try to hide some colums (after already hided 35-40 colums) I
get the message : "Can't move objects from sheet" ("Kan geen objecten
van het blad afschuiven" - DUTCH VERSION)

I tried it also by making a group, to hide them at once. Even then i
get that *@#$ message.

Is there some maximum or restriction on hiding colums? PLEASE HELP...
 
Bou,

The cannot move objects off sheet error occurs because XL thinks you have
filled all of the columns. (I'm not sure why it is a problem when you are
hiding columns, but then I'm also not sure why XL thinks the sheet is full
either) The fix is to select all of the columns after your data and delete
them using Edit|Delete. While you're at it you should probably do the same
thing with the rows below your data.

PC
 
Don't think so. But, you must have something in columns.
Do ctrl+end
delete un-needed columns
 
Forgot to mention that you must SAVE workbook to take effect
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top