Shortcuts

For easy navigation or to find a specific shortcut quickly, either use the search bar or “CTRL + F”.

Comments:

  • Insert / edit a comment to a cell ⇒ SHIFT + F2
  • Show / hide all comments ⇒ ALT + V + C

 

 

Delete:

  • All formatting ⇒ ALT + E + A + A
  • Column ⇒ highlight column + CTRL + ‘-‘
  • Row⇒ highlight row + CTRL + ‘-‘

Insert:

  • Current date ⇒ CTRL + ;
  • Current time ⇒ CTRL + SHIFT + ;
  • Insert ‘$’ to cell reference (locked cell) ⇒ F4
  • Insert / edit a comment to a cell ⇒ SHIFT + F2
  • Row ⇒ highlight a row, CTRL + ‘+’
  • More than one row ⇒ highlight rows, CTRL + ‘+’

Miscellaneous:

  • Access “Format Cells” dialog box ⇒ CTRL + 1
  • Edit a cell ⇒ F2
  • Go to the top / bottom of data ⇒ CTRL + ‘up arrow / down arrow’
  • Highlight entire row ⇒ SHIFT + L
  • Merge and centre ⇒ highlight cell(s), ALT + H + M + C (same to unmerge)
  • Undo ⇒ CTRL + Z
  • Re-do undo ⇒ CTRL + Y
  • Turn filter on/off ⇒ CTRL + SHIFT + L
  • Wrap text ⇒ highlight cell(s), ALT + H + W (same to unwrap)

Move:

  • Between excel spreadsheets ⇒ CTRL + TAB
  • To another sheet ⇒ CTRL + ‘pg up’ / ‘pg dn’

Table:

  • Convert data into a table ⇒ click on a cell that contains the data, CTRL + T
  • Turn filter on/off ⇒ CTRL + SHIFT + L

 

 

 

Featured image is sourced from Google Images.

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s