Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

 

 

 

 

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 Click 

Lock 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.

Get All the Excel News

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

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

 

Last updated: May 31, 2016 7:20 PM