Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |