Excel Shortcut Keys 2012

Excel Shortcut Keys were never difficult to you before this column. So, lets start with What is Microsoft excel? Microsoft Excel is a digital worksheet program that can be used for saving, planning and adjusting information. It allows customers to arrange, structure, and determine data with treatments using a worksheet system broken up by columns and rows. So to speed up your lengthy tasks you must need shortcuts keys.

Here is a bundle of Excel Shortcut Keys:

01. Excel Shortcut Keys - General:

F1 Key Help

F2 Key Edit current Cell

F5 Key Goto

F7 Key Spell Check

F12 Key Save file as

CTRL and A Select entire worksheet.

CTRL and B Toggle Bold Text.

CTRL and C Copies the item or items selected to the Clipboard and can be pasted using CTRL and V.

CTRL and F Displays the Find dialog box.

CTRL and H Displays the Replace dialog box.

CTRL and I Toggles Italic Text.

CTRL and N New File.

CTRL and O Open File.

CTRL and P Print.

CTRL and S Save File.

CTRL and U Toggles Underlined Text.

CTRL and V Paste the contents of the clipboard.

CTRL and X Cut the selected item.

CTRL and Y Redo the last undone action

CTRL and Z Undoes the last action.

CTRL and 1 Displays Format Cells Dialogue Box

CTRL and 5 Toggles Strikethrough Text

02. Excel Shorcut Keys - Formulas:

ALT and = Auto sum

ALT and F8 Macros

CTRL and ; Insert Current Date

CTRL and : Insert Current Time

03. Excel Shortcut Keys - Movement:

Left Arrow One Cell Left (also SHIFT and TAB)

Right Arrow One Cell Right (also TAB)

Up Arrow One Cell Up

Down Arrow One Cell Down

Home Go to End of row

CTRL and left Arrow Go to End of Column

CTRL and Home Go to Top of Worksheet (A1)

CTRL and End Go to End of Worksheet

CTRL and PAGE-DOWN Go to Next Worksheet

04. Excel Shortcut Keys - Cell Selection:

CTRL and Spacebar Select the entire Column

SHIFT and Spacebar Select the entire Row

CTRL and A Select Entire Worksheet

SHIFT and Left Cursor Select all cells to the left of the active one

SHIFT and Right Cursor Select all cells to the right of the active one

You can definitely save your time by using the above "Excel Shortcut Keys" rather than using mouse and adopting conventional style. 

Posted in: Microsoft