How to Move First Row?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chiefbrutalis - 11 Jun 2006 17:55 GMT

Hi I’ve just created a spreadsheet in Excel which goes into around 2
different columns now in my first columns I have a list of names whic
I want to appear at the beginning of each page as I scroll across m
Spreadsheet I was wondering if this is possible and if so How man
Thank

Reply to this Message

Gord Dibben - 11 Jun 2006 18:28 GMT

Check out Window>Freeze Panes feature for locking rows or columns in view as you
scroll.

Any area above and to the left of your original selected cell will remain frozen
in view.

i.e. select c3 and Window>Freeze Panes.

Columns A and B and rows 1 and 2 will be frozen.

Gord Dibben MS Excel MVP

>Hi Ive just created a spreadsheet in Excel which goes into around 20
>different columns now in my first columns I have a list of names which
>I want to appear at the beginning of each page as I scroll across my
>Spreadsheet I was wondering if this is possible and if so How many
>Thanks

Reply to this Message

MartinW - 11 Jun 2006 18:54 GMT

Hi Chief,

As well as Gord's tip you may also want to take a look at
File>page setup>Sheet tab.
Here you can set how many rows or columns to repeat on each page, so
for printing purposes if your sheet is say five pages, your column or row
headers will print on each page.

HTH
Martin

Reply to this Message