Hiding Rows

[Shannan]

Hi,
I have a spreadsheet where the column titles are only in row nine. Above
that is our department name, the year, our clinic's location and a picture of
our company logo. I want all this to be there so that it'll be on the print
out, but i want to be able to hide all of this for when people are actually
working on the spreadsheet and don't need to see it. When i try to hide the
rows, the picture doesn't get hidden, it just ends up showing up overtop of
the column titles. How do i fix this?

 

[JP]

You could put the image in the header instead.

Depending on your Excel version (this is for 2003):

Go to File > Page Setup > Header/Footer tab, click "Custom Header",
click the Image button (second from the right) and locate your company
logo image.

It will appear in the header, but not on the worksheet while you're
working on it.

--JP

 

[cm]

you can put your data and picture in the page setup custom header and remove
it from your data lines. You'll have to adjust the picture to get it right
sized.

 

[Gord Dibben]

Right-click on the Logo........I assume it is an object.

Set properties to "move and size with cells"

It will now hide when rows 1 to 8 are hidden.


Gord Dibben MS Excel MVP