Hiding Rows
 

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?

Hiding Rows
 

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

On Oct 7, 11:53*am, Shannan wrote:
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?

Hiding Rows
 

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.

--
hope to help,
cm


"Shannan" wrote:

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?

Hiding Rows
 

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

On Wed, 7 Oct 2009 08:53:01 -0700, Shannan
wrote:

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?