Thread: Hiding Rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?