Search Contextures Sites
Custom Search

 

 

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

 

 

 

 

 

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.

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:22 PM