Microsoft Excel is a part of the Microsoft office which is used widely in all the places. Mainly it's deals with the table making data contents. If you know all the shortcuts for the microsoft excel then it will really easy to handle without any difficulty. So here I am bringing some of the most used keyboard shortcuts that will help you to operate excel easily.
Keyboard Shortcuts for Microsoft Excel
Cell selection Keyboard Shortcuts
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
Movement Selection Keyboard Shortcuts
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
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
Formulas Keyboard Shortcuts
ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time
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.
These shortcuts for microsoft excel are very easy to remember even for beginners. Remember these shortcuts and Microsoft Excel will be a hell lot easier than anytime.
Keyboard Shortcuts for Microsoft Excel
Cell selection Keyboard Shortcuts
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
Movement Selection Keyboard Shortcuts
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
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
Formulas Keyboard Shortcuts
ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time
General Keyboard Shortcuts
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
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.
These shortcuts for microsoft excel are very easy to remember even for beginners. Remember these shortcuts and Microsoft Excel will be a hell lot easier than anytime.
Comments
Post a Comment