Using Ctrl+Enter to place information into multiple cell simultaneously!

If you need to enter the same data into multiple cells, Excel offers a fabulous shortcut.

  1. Select all the cells that you need to change.
  2. Enter the value, text, or formula.
  3. Press Ctrl+Enter.
  4. The same information is inserted into each in the selection.

Using a form for data entry!

When you have a list of information in a table, the column names do more than describe what needs to be typed in that column but can be used in a form.  If the table has many columns, it may become an inconvenience to scroll back and forth. One way is to use Freeze Pane to keep the main column(s) and row(s) from not moving. I recommend using the Form command which will become a data entry where it will display the column headings as fields for input.

  1. Place in the Quick Access Bar, the Form command.
  2. Type out the column headings. For example: First Name, Last Name, Address, City, State, Zip Code, and Salary.
  3. Click on Insert Table and select the headings.
  4. Check in the dialogue box “My table has headings”
  5. A blank row appears in the table.
  6. Format each empty cell under each heading to accommodate the information. For example: place the Accounting format for the Salary column.
  7. Click on the Form icon from the Quick Access Bar
  8. A data entry form appears.
  9. Enter the information in each field and hit Enter to enter the information into the table.
  10. This is  will definitely expedite entering the information.

Entering the current date or time into a cell using the keyboard!

  • Current date:  Ctrl+;
  • Current time:  Ctrl+Shift+;

Formatting numbers using the keyboard!

  • Ctrl+Shift+~  —> General format.
  • Ctrl+Shift+$   —> Currency format with two decimal places.
  • Ctrl+Shift+%  —> Percentage format with no decimal places.
  • Ctrl+Shift+!   —> Two decimal places, thousands separator, and a hyphen for a negative values.

 Using the keyboard to enable the Cells dialogue box!

  • Ctrl+1

Using the keyboard to insert a blank or a new workbook!

  • New workbook:   Ctrl+N
  • New worksheet:  Shift+F11

Selecting cells without using the MOUSE!

  • To start the the highlighting process, simply hit F8 and the arrow keys. Hit F8 to turn it off.
    OR
  • Hold down the shift and use the arrow keys.

To change formats on multiple sheets at the same cells at the same time!

  1. Activate the first worksheet.
  2. Press down on the Ctrl and click on the second worksheet.
  3. Notice that the workbook window’s title bar displays [Group] to remind you that you have selected a group of sheets and that you are in Group mode.
  4. Apply the formats.
  5. The worksheets have now been formatted at the same time.
  6. Click on another sheet outside the group to ungroup the selected worksheets.

KEEP AN EYE OUT FOR PART 2!!!!!

Advertisements