Hiding columns

  • Thread starter Thread starter Peter Fossey
  • Start date Start date
P

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
 
Peter Fossey said:
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
Click to expand...

You should be able to do this. What happens when you try?
 
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.
 
That's what I thought.. But I got this message instead:
"Cannot shift objects off sheet"

Any ideas?
 
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
 
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..
 
I tried highlighting the area I want to hide then
choosing 'clear all' but I still get the same message.
 
Back
Top