Tuesday, 13 January 2015

Common Keyboard Shortcuts in Microsoft Excel 2010


The following are useful keyboard shortcut tips that will help you save time in your worksheet:


CTRL+A
Selects the entire worksheet.
CTRL+B
Applies or removes bold formatting.
CTRL+C
Copies the selected cells.
CTRL+H
Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I
Applies or removes italic formatting.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+P
Displays the Print tab in Microsoft Office Backstage view.
CTRL+S
Saves the active file with its current file name, location, and file format.
CTRL+T
Displays the Create Table dialog box.
CTRL+U
Applies or removes underlining.
CTRL+V
Inserts the contents of the Clipboard at the insertion point and replaces any selection.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+;
Enters the current date.
CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.


Learn How To Work With Microsoft Excel Workshop, for more details:
http://e-presence.ca/website/event/learn-create-excel-templates/

source: http://office.microsoft.com/en-ca/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx