A complete list of all Excel keyboard shortcuts. Whether you want to remove the border from selected cells or apply a date format, you will find the shortcut keys here.
Why use this guide?
Save time using the Excel toolbar with these keyboard shortcut keys.
Answer questions such as:
How to format cells in Excel.
Which Excel shotcut to add a border?
How to add current time to Excel spreadsheet?
How to unhide Excel rows?
Examples of some of the Excel shortcuts included:
CTRL+SHIFT+( Unhides any hidden rows within the selection.
CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT+# Applies the Date format with the day, month, and year.
CTRL+SHIFT+: Enters the current time.
CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.
CTRL+1 Displays the Format Cells dialog box.
CTRL+9 Hides the selected rows.
CTRL+0 Hides the selected columns.
CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+W Closes the selected workbook window.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
F9 Calculates all worksheets in all open workbooks.
F11 Creates a chart of the data in the current range in a separate Chart sheet.
HOME Moves to the beginning of a row in a worksheet
Note: This is an online resource from Microsoft.
Type: freewareCategory: Internet (Misc)OS Support:
Office 2010 ExcelKeywords: