How do I keep the header at the top of each column while a scroll down?
How do I keep the header at the top of each column while a scroll down?
Yes Freeze-Panes
in Excel 2010 shortkey is Alt W+F+F
To freeze row:The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top.
- Select the row below the row(s) you want to freeze.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
To freeze columns:
- Select the column to the right of the column(s) you want to freeze. In our example, we want to freeze column A, so we'll select column B.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
The column will be frozen in place.
To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.
If you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu.
Hope it helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks