Microsoft Excel Shortcuts

It is sometimes inconvenient to have to use the mouse, especially when doing a lot of keyboard work. It is at these times that the keyboard short cuts are very useful. It seems that many quite advanced users are unaware of some of these. Here is a brief reminder of a few of our favourite shortcuts for Microsoft Excel. If any of these are a bit cryptic, try them and all should become clear.

If you are a wordprocessor user you may find an equivalent list in the Shortcuts for Word.

 

+	Saves the current document.
+	Brings up the print dialogue box.
+	Will select the entire width of any rows currently in a highlighted area.
+	Will select the entire width of any columns currently in a highlighted area.
+ +	Will select the entire worksheet.
+ or	Changes the current sheet in the workbook to the next one above or below the current one.
+
+ or	Selects the next cell(s) in the appropriate direction.
+ or
+ or
+
+ or	Moves you to the next blank (or non-blank) cell in the appropriate direction. Combine this with the shift key and you can select the block of cells at the same time.
+ or
+ or
+
+	Will bring up the Find dialogue box.
+	Brings up the Replace dialogue box.
+ or	Undoes the last action.
+
+	Toggles Bold face on the current selection.
+	Toggles Italic face on the current selection.
+	Toggles Underline face on the current selection.
+	Copies the contents of the cell above the current one into it.
+	Will let you force a new line when entering text into a cell. (In Excel 5 this only works when editing in the body of the worksheet, and not in the edit line of the formula bar.)