Search Contextures Sites

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.   Debra Dalgleish	Search Contextures Sites

Last updated: January 27, 2010 11:01 AM