Search Contextures Sites
More Excel Videos
Excel Quick Tips Videos 01
If you want to keep the top rows of an Excel worksheet in view at all times, so you can see the column headings, you can lock the top rows in place.
To lock the top rows in place, you'll use the Freeze Panes feature in Excel 2007. This Excel Quick Tips Video shows you the steps for selecting the specific section that you want to freeze, and then locking the rows.
For more details on this technique, see the Excel FAQs for the steps to Freeze Title Rows in Excel 2003.
When you print an Excel worksheet, you can also print all the comments that have been added to the sheet. This Excel Quick Tips video shows how to display the worksheet comments, and then print the worksheet with all the comments showing.
If you're using an older version of Excel, there is more information on Printing Comments in Excel 2003.
You can quickly create a series of numbers on an Excel worksheet, such as a series of even numbers, 2, 4, 6, 8. To do this, you can type the first two numbers in the series, and then drag the Fill Handle to continue the series on the worksheet. This Excel Quick Tips video shows you how to fill the series.
There are many more Excel Data Entry tips that will help you work efficiently in Excel.
Use Excel's built in AutoSum feature to instantly create grand totals for all the rows and columns in a table, with one click. For detailed instructions on this technique, see Grand Total a Range of Cells.
For regular Excel news, tips, videos, and special offers, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
More Excel Tutorial Videos
Contextures Inc., Copyright ©2016
All rights reserved.
Last updated: May 31, 2016 7:20 PM