Hi there,
Originally Posted by
Rudey
I can't find the window thing in Excel 2007 sorry
I see the Freeze Panes drop down menu, and I can freeze either the top row or first column, but I can't see that option
There are actually two ways of doing it on Excel 2007...
1. Split option: Using the Split functionality, which splits the spreadsheet in 4. You can then adjust the limits to the second line and click on the Freeze Panes option.
2. Copy and Paste option: Freeze Pane the top row. Add two rows before the frozen one: on the second row paste the one you would like to freeze, on the first paste the one automatically frozen. Then you just have to delete the originally two rows. Confused with this second option?
You have these initial 2 rows, and the Freeze Pane option was enabled:
row #1 - automatically frozen by the excel Freeze Pane option
row #2 - the one you actually wanted to Freeze.
row #n - content
Then you add two more rows, copying the content of the previously presented rows:
new row #1 - copy of the automatically frozen
new row #2 - copy of the one you actually wanted to Freeze.
row #1 - automatically frozen by the excel Freeze Pane option
row #2 - the one you actually wanted to Freeze.
row #n - content
You now have 4 rows with the same content.
So, we'll delete the spare ones:
new row #1 - copy of the automatically frozen
new row #2 - copy of the one you actually wanted to Freeze.
row #n - content
You now have the Freeze Pane located on the second row.
Best regards,
rfarinha
Bookmarks