Unused Collumns

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"

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

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.