Excel 2007: How to freeze first row/column and scroll the others | Get Digital Help - Microsoft Excel resource

Popular categories

Conditional formatting

Drop down lists

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Excel 2007: How to freeze first row/column and scroll the others

← Previous post -

Excel 2007: How to freeze first row/column and scroll the others

Filed in Excel on Nov.09, 2007. Email This article to a Friend

Problem: How to scroll everything except top row

Example:

Solution:

Go to tab "View"
Click "Freeze panes"
Click "Freeze top row"

Now you can scroll the sheet with mouse wheel and still see the top row.

Related posts:

Excel:Print headers on every page

Excel 2007: Color cells that meet criteria using conditional formatting

Filter and highlight duplicate column records in excel 2007

Excel 2007: Find names and their references in a sheet

Excel:Rotate text to save space

Recommended categories

Excel

Leave a Comment

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Subscribe
Blog updates by email:
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
Don´t forget to add my RSS feed and subscribe to new blog articles by email.
Recent Comments
- Oscar on How to use excel SUMPRODUCT function
- Arturo on How to use excel SUMPRODUCT function
- G. Cooley on Highlight events in a calendar
- Oscar on Populate a list box with visible unique values from an excel table (vba)
- Oscar on Sum values in a range where adjacent cell value equals a criterion in excel
- aMareis on Highlight unique distinct values in two ranges combined using conditional formatting in excel
- G. Cooley on Highlight events in a calendar
- Alaa Abdullnabi on Merge two columns with possible blank cells in excel (formula)
- Oscar on Merge two columns with possible blank cells in excel (formula)
- Oscar on Calculate your stock portfolio performance in excel
Recent Posts