Search Contextures Sites

Excel Quick Tips Videos 02 Select a Random Name in Excel  Change Excel Formulas to Values  Show a Message When Cell is Selected  Quickly Name Selected Cells in Excel  Select a Random Name in Excel To select a random name from a list of names, enter the RAND function in an adjacent column. Then, sort the column of random numbers. The name that appears at the top of the list is the winner. For more tips on sorting, see Sorting a List in Excel. Change Excel Formulas to Values After you create formulas in Excel, you might need to change the formulas to the calculated values, to lock them in. Use this mouse shortcut to copy and paste as values, in one quick step. There's also information on Excel Keyboard Shortcuts. Show a Message When Cell is Selected To help users enter data correctly, you can display a message when they click on a cell. Use the data validation settings to show data entry instructions. There are written instruction for Data Validation Messages. Quickly Name Selected Cells in Excel If adjacent cells have a text label, you can use this quick technique to name cells. There are more instructions for Naming Cells in Excel.

	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	Excel Quick Tips Videos 01 Excel Quick Tips Videos 02 Excel Quick Tips Videos 03 Excel Quick Tips Videos 04 Excel Quick Tips Videos 05

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact   Privacy Policy   Contextures Inc., Copyright ©2010 All rights reserved.   Debra Dalgleish	Search Contextures Sites

Last updated: January 6, 2010 10:25 PM