Some useful Excel shortcuts

Some useful Excel shortcuts

Here’s some useful Excel shortcuts, which I’ll add to as I find more useful ones.

One of the main ones I’ve found is Insert a New Row – without a shortcut this is an extremely clunky operation of selecting the current row using the mouse and then selecting to Insert a new row in one of several ways (right-click menu or Ribbon Menu or shortcut key) There doesn’t seem to be a one-step shortcut for Inserting a New Row, but there is a two-step shortcut, see below.

Insert a New Row

1) Shift + Spacebar        Select current row
2) Ctrl + ‘+’                        Insert row
(On my Asus laptop I have to actually do Ctrl + Shift + =/+ key)

Other Useful Shortcuts

Ctrl + ;                       Insert current date
Ctrl + :                       Insert current time
Ctrl + ”                      Copy value from cell above
Ctrl + ‘                      Copy formula from cell above
Alt + Enter             Start a new line in same cell
Ctrl + Spacebar    Select entire column

 

Useful Excel Shortcut Links

http://www.ddmcomputing.com/excel/keys/xlsk05.htm
http://www.asap-utilities.com/excel-tips-shortcuts.php
http://excel-tips.blogspot.co.uk/2005/08/insert-new-row-or-column-excel.html

 

 

2017-01-10T21:26:20+00:00July 29th, 2013|Categories: Tips, Windows 8|Tags: , , |