Hiding columns

[Peter Fossey]

Hi there all,

I've got a tiny table in excel, I've hidden all the rows
below the used ones to make it look nicer.
Why can't I hide all the columns I don't want to use?

Cheers,
Pete

 

[Anon]

Hi there all,

I've got a tiny table in excel, I've hidden all the rows
below the used ones to make it look nicer.
Why can't I hide all the columns I don't want to use?

Cheers,
Pete

You should be able to do this. What happens when you try?

 

[Mike]

Pete, you can hide all unused columns. You may be doing
it incorrectly. Click on the first column header after
your data to highlight the whole column, hold Ctrl+Shift
then press the right cursor key which will select ALL
columns to the right, then right-click and select Hide.

 

[Peter Fossey]

That's what I thought.. But I got this message instead:
"Cannot shift objects off sheet"

Any ideas?

 

[Lynn Schauer]

you should be able to,
select the first column to hide, then holding down shift, press END, RIGHT
ARROW to select all columns to the right of that one, then format..
columns.. hide.

If that doesnt work, what does happen?
Lynn S

 

[Peter Fossey]

It's always worked before, just not today.. I can see why,
I've copied the data to a new workbook but to no avail.

It just pops up with an error message..

 

[Peter Fossey]

I tried highlighting the area I want to hide then
choosing 'clear all' but I still get the same message.