|
|
Search
Contextures Sites
|
||
|
|
|
|||
More Excel Tutorial Videos |
||
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites
Search Contextures Sites
Excel Quick Tips Videos 01
Lock the Title Rows in Excel 2007
Print Comments in Excel 2007
Quickly Create a Series of Numbers
Create Grand Totals With One ClickLock the Title Rows in Excel 2007
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.
Print Comments in Excel 2007
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.
Quickly Create a Series of Numbers
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.
Create Grand Totals With One Click
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.
More Excel Tutorial Videos
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites
Last updated: April 6, 2010 1:12 AM
