Search Contextures Sites

Excel Data Entry Tips

Excel Data Entry Keyboard Shortcuts
Excel Data Entry Mouse Shortcuts
Enter Excel Data in a List

Excel Data Entry Keyboard Shortcuts

Use Shortcut Keys

  • Enter the current Date:  Ctrl + ;
  • Enter the current Time:  Ctrl + Shift + ;
  • Copy Value from cell above:  Ctrl + Shift + '
  • Copy Formula (exact) from cell above:  Ctrl + '
  • Copy Formula (relational reference) from cell above:  Ctrl + D

Number keypad
with Excel shortcuts:


Enter Data in Multiple Cells -- Ctrl + Enter

 

 

  1. Select all the cells in which you want to enter the same value or formula
  2. Type the value or formula in the active cell
  3. Hold the Ctrl key and press Enter

Copy Data to Adjacent Cells

 
  1. Select the range, starting with the cell that contains the data to be copied
  2. Use a shortcut key to fill right or down:
    • Fill Right -- Ctrl + R
    • Fill Down -- Ctrl + D

Excel Data Entry Mouse Shortcuts

 

Copy Data to Adjacent Cells

 

  1. Select the cell that contains the data to be copied
  2. Point to the Fill Handle -- the black square at the lower right of the selection
  3. When the pointer changes to a black plus sign, press the Left mouse button, and drag left, right, up or down, across one or more cells.
  4. When finished, release the mouse button.

Copy to Adjacent Cells -- with options

  1. Select the cell that contains the data to be copied
  2. Point to the Fill Handle -- the black square at the lower right of the selection
  3. When the pointer changes to a black plus sign, press the Right mouse button, and drag left, right, up or down, across one or more cells.
  4. When finished, release the mouse button.
  5. Select one of the options from the shortcut menu

Watch the Excel Quick Tips Video for creating a list of dates

 


Enter Excel Data in a List

Use Excel's built-in Data Form to make it easier to enter data in a list. It will display a maximum of 32 fields.

  1. Select a cell in the list.
  2. Choose Data|Form
  3. Click the New button, and enter the new record

Note: Fields which contain a formula, such as Total in the Data form shown here, will not have a text box. The formula will be entered and calculated automatically.

For a data form with additional features, you can try John  Walkenbach's Enhanced Data Form. It's free, and allows unlimited fields.

 


1. Excel Data Entry Tips
2. Excel Data Entry -- Fill Blank Cells
3. Excel Data Entry -- Convert Text to Numbers
4. Excel Data Entry -- Increase Numbers With Paste Special
   

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

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

 

Last updated: December 30, 2009 3:58 PM