Excel Keyboard Shortcuts – Values

Some keyboard shortcuts can quickly enter things like today’s date or copy the value from the cell above.

Keyboard Shortcuts

  1. Copy Cell Above into current cell.
  2. Copy Down – copies the top cell down a selection
  3. Insert Today’s Date into current cell
  4. Copy ‘n’ Paste Values – Copies and pastes the result of a formula withouth copying the formula itself, just the result
  5. Other Excel Keyboard Shortcuts 

Key

or * = Hold this key down while tapping the white keys in sequence indicated.

= Tap this key(s) in sequence indicated (if there is more than one) whilst holding down the grey key.

Copy the cell above

Into your current cell

CTRL* + ‘


Holding down CTRL button for spreadsheet navigation Excel Keyboard Shortcut Value Above

Starting Position
After CTRL* + ‘

Copy Down

Copy the top value down all the cells in your selection

CTRL* + D


Holding down CTRL button for spreadsheet navigation Excel Keyboard Shortcut Delete

Starting Position
After CTRL* + D

Insert today’s date

CTRL* + ;


Holding down CTRL button for spreadsheet navigation

Starting Position
After CTRL* + ;

Copy’n’Paste Values

CTRL* + C


Holding down CTRL button for spreadsheet navigation Excel Keyboard Shortcut Column

then move cell

ALT* + E + S + V

Using ALT Keyboard shortcuts Excel Keyboard Shortcut Cell Excel Keyboard Shortcut Insert Symbol Excel Keyboard Shortcut Paste

Starting Position
After CTRL* + ;

Other Excel Keyboard Shorcuts

  1. Navigation
  2. Selecting
  3. Inserting
  4. Deletion
  5. Standard Office Shortcuts

Other Excel Spreadsheet Help

Follow our blog with Excel Tips and Business Data Advice.

Our Business Spreadsheets page offers some complementary downloads which demonstrate how to perform everyday business office tasks in Microsoft Excel

Comments are closed.