Solved excel 2010 how to repeat titles on top of spreadsheet

March 25, 2015 at 07:58:46
Specs: Windows 2010
I am doing a worksheet and need the column headers to repeat as I scroll down. I am reconciling and using the sheet with columns going down, when the page is full the headers at the top disappear so I don't know which column to use without having to keep going up to see the names of the columns.

See More: excel 2010 how to repeat titles on top of spreadsheet

Report •


#1
March 25, 2015 at 08:48:10
✔ Best Answer
Your looking to Freeze Panes
It should be under the View Tab

To Freeze row 1,
Select cell A2,
Select the View Tab
Select Freeze Panes
Select Freeze Pane or Select Freeze Top Row


See here for more info:

https://support.office.com/en-nz/ar...

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question