How to Move First Row?

C

chiefbrutalis

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
 
G

Gord Dibben

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
 
M

MartinW

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
 
Top