Top MS Excel Shortcut Keys for Beginners
(Part-1)
|
By using shortcuts keys we will reduce our work-time and make it easier to work in any application. We can do all the tasks with mouse also, but it reduces our productivity and also it takes more time to complete the work. So, here we will discuss about shortcut keys of MS Excel. If you are a beginner of MS Excel, these shortcut keys are definitely helpful for you. These MS Excel shortcut keys works with all the versions MS Excel 2003, MS Excel 2007, MS Excel 2010 and MS Excel 2013.
In this blog, we will see some basic MS Excel shortcut keys and their uses.
MS Excel Shortcut Keys :
Click here : Top MS Excel Shortcut Keys (Part-2)
| MS Excel Keyboard Shortcut | Work of this shortcut |
|---|---|
Ctrl+A
|
To select all contents of a worksheet.
|
Ctrl+B
|
It will bold all cells in the highlighted section.
|
Ctrl+D
|
i.e.(Ctrl+Down)
It fills content of the selected cell on top to bottom. |
Ctrl+F
|
To search current sheet.
|
Ctrl+G
|
Go to a certain area.
|
Ctrl+H
|
Find and then Replace.
|
Ctrl+I
|
It puts italic on all the selected cells.
|
Ctrl+K
|
To insert a hyperlink.
|
Ctrl+P
|
It will print the current sheet.
|
Ctrl+R
|
It fills the current selected cell with previous cell content.
|
Ctrl+S
|
It saves the open worksheet.
|
Ctrl+U
|
It will underlines all selected cells.
|
Ctrl+V
|
Paste everything copied onto the clipboard.
|
Ctrl+W
|
It closes the current workbook.
|
Ctrl+X
|
Cuts the all selected cells.
|
Ctrl+Y
|
Redo the last action.
|
Ctrl+Z
|
Undo the last action.
|
Ctrl+1
|
Change the format of the selected cell.
|
Ctrl+2
|
It bolds all the selected cells.
|
Ctrl+3
|
It italics all the selected cells.
|
Ctrl+4
|
It underlines all the selected cells.
|
Ctrl+5
|
Put a strikethrough all the selected cells.
|
Ctrl+6
|
To Show or Hides objects.
|
Ctrl+7
|
To Show or Hides toolbars.
|
Ctrl+8
|
Toggles the outline symbols.
|
Ctrl+9
|
It hides Rows.
|
Ctrl+0
|
It hides columns.
|
Ctrl+Shift+:
|
Enters the current time.
|
Ctrl+;
|
Enters the current date.
|
Ctrl+`
|
It changes between displaying cell value or formulas in the worksheet.
|
Ctrl+'
|
Copies the formula from the above cell.
|
Ctrl+Shift+"
|
Copies value from above cell.
|
Ctrl+ -
|
Deletes the selected column or row.
|
Ctrl+Shift+=
|
To insert a new column or row.
|
Ctrl+Shift+~
|
It will switch between showing Excel formula or their values in the cell.
|
Ctrl+Shift+@
|
Applies time formatting.
|
Ctrl+Shift+!
|
Applies comma formatting.
|
Ctrl+Shift+$
|
Applies currency formatting.
|
Ctrl+Shift+#
|
Applies date formatting.
|
Ctrl+Shift+%
|
Applies %age formatting.
|
Ctrl+Shift+^
|
Applies exponential formatting.
|
Ctrl+Shift+*
|
Selects the current region around the active cell.
|
Ctrl+Shift+&
|
It places border around selected cells.
|
Ctrl+Shift+_
|
It removes a border.
|
Ctrl++
|
Insert.
|
Ctrl+-
|
Delete.
|
Ctrl+Shift+(
|
Unhide rows.
|
Ctrl+Shift+)
|
Unhide columns.
|
Ctrl+/
|
To select the array containing the active cells.
|
Ctrl+\
|
To select the cells that have a static value or don't match formula in the active cell.
|
Ctrl+[
|
It selects all the cells which are referenced by current selected section formulas.
|
Ctrl+]
|
Select cells that contain formulas that referenced to the active cells.
|
Ctrl+Shift+{
|
It selects all the cells which are directly or indirectly referenced by current selected section formulas.
|
Ctrl+Shift+}
|
Selects cells which contains formulas that directly or indirectly referenced the active cell.
|
Ctrl+Shift+|
|
Selects the cell within a column that don't match the formulas or static values in the active cell.
|
Ctrl+Enter
|
It fill the selected cells with the current entry.
|
Ctrl+Spacebar
|
It selects the entire column.
|
Ctrl+Shift+Spacebar
|
It selects the entire worksheet.
|
Ctrl+Home
|
Move to cell A1.
|
Ctrl+End
|
Move to last cell on worksheet.
|
Click here : Top MS Excel Shortcut Keys (Part-2)
Go to my YouTube channel and watch more interesting Technical Tips & Tricks Videos
Click Here : My YouTube Channel
No comments:
Post a Comment