Search Contextures Sites

 

 

Learn how to create Excel dashboards.

 

Excel Tutorial Videos 01

Excel Data Entry in Specific Cells 
Add a Picture to a Comment 
Fill Blank Cells From Above
Move the Color and Borders Palettes 

Excel Data Entry in Specific Cells

When filling in an Excel worksheet form, the data entry cells might be scattered throughout the worksheet. For a quick and easy way to move through the cells, in a specific order, you can create a named range.

In the technique shown in this video, you’ll select the data entry cells, in the order you want to use them. Then, you'll name the selected cells. Later, you can select the named range, and use the Tab key to move though the cells, in the set order.

For written instructions for this Excel tutorial, see the Contextures Blog article: Jump to the Next Data Entry Cell in Excel

Add a Picture to a Comment

Add a popup picture that's attached to a worksheet cell, by inserting a picture in a cell comment. With this simple technique, the pictures will be hidden, until the user displays them by pointing to a cell that contains a comment.

For written instructions for this Excel tutorial see: Add a picture to a comment

Fill Blank Cells From Above

If a worksheet contains cells that have been left blank, you can fill in the blanks, by copying the value from the first filled cell above the blank. By filling in the blanks, you'll be able to sort or filter the list. The following technique makes it easy to fill in the blanks.

For written instructions for this Excel tutorial see: Fill Blank Cells From Above

Move the Color and Borders Palettes

While formatting an Excel file, you may need to colour some cells, change the font colour for the text, or add borders to a range of cells. For example, to add colour, you select a cell, click on the dropdown arrow at the right side of the colour button on the toolbar, and click on a colour.

If you have lots of formatting to do, you can detach the color, font color and border palettes from the toolbar, and move them onto the worksheet.

For written instructions for this Excel tutorial see the article: Move the Color and Borders Palettes

   

 

Excel Tutorial Videos 01
Excel Tutorial Videos 02
Excel Tutorial Videos 03
Excel Tutorial Videos 04
Excel Tutorial Videos 05
Excel Tutorial Videos 06
Excel Tutorial Videos 07
Excel Tutorial Videos 08 
Excel Tutorial Videos 09 
Excel Tutorial Videos 10  

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright © 2009.
All rights reserved.

 

Search Contextures Sites

Last updated: January 27, 2010 11:01 AM