Top 50 MS Excel Shortcut Keys - Gaintoearn

    very useful excel shortcut tips for corporate people as well as for students those who are searching job in in the competitive world. These shortcuts will be useful for all those who are doing work in excel. Learn shortcuts and work smart.

S.NO	Frequently used Shortcuts
1	Close a spreadsheet	Ctrl + W
2	Open a Spreadsheet	Ctrl + O
3	Save a Spreadsheet	Ctrl + S
4	Copy	Ctrl + C
5	Paste	Ctrl + V
6	Undo	Ctrl + Z
7	Cut	Ctrl + X
8	Redo	Ctrl + Y
9	Delete a column	Alt + H,D then C
10	Formula Tab	Alt + M
11	Home Tab	Alt + H

S.No	Navigation Shortcut Keys
1	Move one cell to the right in a worksheet , or in a protected worksheet, move between unlocked cells	Tab
2	Move one cell to the left in a worksheet or previous option in a dialog box	Shift + Tab
3	Move to the last cell on a worksheet ,to the lowest used row of the  rightmost used column	Ctrl + End
4	Move to the beginning of the worksheet	Ctrl + Home
5	Move to the next sheet in a worksheet	Ctrl + Page Down (PgDn)
6	Move to the previous sheet in a workbook	Ctrl + Page Up(PgUp)
7	Move to the edge of the current data region in a worksheet	Ctrl + Arrow Key
8	Move one screen up in worksheet	Page Up

S.No	Format Cells Shortcut Keys
1	Format a cell by opening the format cells dialog box	Ctrl + 1
2	Add or edit a cell comment	Shift + F2
3	Display the create table dialog box	Ctrl + L  (or)  Ctrl + T
4	Enter the current time	Ctrl + Shift + Colon (:)
5	Enter the current date	Ctrl + Semicolon  (;)
6	Use the fill down command to copy the contents and format of the topmost cell of a selected range into the cells below	Ctrl + D
7	Use the fill right command to copy the contents and format of the left most cells of a selected range into the cells to the right	Ctrl + R
8	Apply the number format with two decimal places, thousands Separator and minus sign (-) for a negative values	Ctrl + Shift + Exclamation sign(!)
9	Apply the time format with the hour and minute , and AM or PM	Ctrl + Shift + At sign (@)
10	Apply the date format within the day, month and year	Ctrl + Shift + Number sign (#)
11	Apply the accounting number format with two decimal places, thousands separator and minus sign (-) for negative values	Ctrl + Shift + Dollar sign ($)
12	Apply the percentage format with no decimal places	Ctrl + Shift + Percentage (%)
13	Apply the scientific number format with two decimal places	Ctrl + Shift + Caret (^)

S.No	Selection Shortcut Keys
1	Select the entire worksheet	Ctrl + A or Ctrl + Shift + Spacebar
2	Extend the selection of cells by one cell	Shift + Arrow Key
3	Select many cells	Ctrl + Shift + Arrow Key
4	Start a new line in the same cell	Alt + Enter
5	Fill the selected cell range with the current entry	Ctrl + Enter
6	Select an entire column in a worksheet	Ctrl + Spacebar
7	Select an entire row in a worksheet	Shift + Spacebar
8	Combine with shift to copy items	Ctrl + Shift + End / Ctrl + Shift + Home

Is this useful? comment below. Do you want more like this? then comments are inviting from you to do more...........