This guide is part of the Microsoft Excel 2010 series
1.
Add a print button to the tool bar in excel 2010
2. Create a bar graph in Excel 2010
3. How to add a background image to excel 2010
4. How to add a column to a spreadsheet in excel 2010
5. How to add a URL to Excel 2010
6. How to adjust the print layout in Excel 2010
7. How to auto fit column width in excel 2010
8. How to convert a column into a row in Excel 2010
9. How to convert excel 2010 to PDF
10. How to create a dashboard in Excel 2010
2. Create a bar graph in Excel 2010
3. How to add a background image to excel 2010
4. How to add a column to a spreadsheet in excel 2010
5. How to add a URL to Excel 2010
6. How to adjust the print layout in Excel 2010
7. How to auto fit column width in excel 2010
8. How to convert a column into a row in Excel 2010
9. How to convert excel 2010 to PDF
10. How to create a dashboard in Excel 2010
Make: Microsoft
Model / Product: Excel
Version: 2010
Objective / Info: Learn to freeze the top header row so that it remains visible when scrolling down the sheet.
Model / Product: Excel
Version: 2010
Objective / Info: Learn to freeze the top header row so that it remains visible when scrolling down the sheet.
1
Open Excel by double left clicking the icon on the desktop or start menu or open the document that you want to work on.
2
Click the row containing the column header that you want to freeze.
3
Click the "View" tab.
4
Click the "Freeze Panes" button.
5
Click the "Freeze top Row" button.
6
The top row should not move as you scroll down the spreadsheet.
7
This task should be complete. Review the steps if you had any issues and try again.Submit questions or request for more guides in the questions section below.
comments powered by Disqus
Ask a question or provide an answer