MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unused Collumns


Posted by Jeff on June 01, 2001 10:43 AM

Hi all!

Is it possible to get rid of all of the unused collumns? I have a database where only A-T are being used... I don't want the option to scroll past T. How do I set it so only collumns A-T are visible?

Thanks again for all of your help!


Posted by Eric on June 01, 2001 11:14 AM

go to column (U), shift+end+rt arrow, format column hide

you can hide all the columns past (T) by going to column (U), then holding down the shift key while hitting "end" and then "right arrow". That will select all the columns after (T). Then go "Format"-->"Columns"-->"Hide"

Posted by Jeff on June 01, 2001 11:55 AM

Re: go to column (U), shift+end+rt arrow, format column hide

Great! IT worked! But, on one of my sheets, when doing this, I got a warning stating: "Cannot shift objects off sheet".

I have nothing in the cells Im trying to hide!?!

JB

Posted by Eric on June 01, 2001 1:33 PM

Re: go to column (U), shift+end+rt arrow, format column hide

When that happens to me, I use the same selection procedure to pick all of the columns after (T)- as before, and instead of hiding them, i delete them.

While all of the columns are selected, use
"Edit"-->"Delete"-->click on "entire column" <enter>

then go back and try the column hide routine again and it should work- its usually because you have some data entered towards the end of the spreadsheet and the column delete clears it out.

If it doesn't work, then try copying all of columns (A) through (T) to a new worksheet, delete the old one, and try the column hiding routine on the new worksheet.