Ms Ofiice

Ms excel shortkeys

ms excel short keys

We can always use a few shortcuts to save our important time. Here are total useful keyboard shortcuts to speed up your work in microsoft Excel. Excel shortcut keys can greatly improve your speed when conducting analysis. But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel.
Here are shortcut keys of Microsoft excel, So you can improve your knowledge with tuetotechni.
Follow following short keys to save your time.
Happy excelling!!

ms excel short keys from tuetotechni
“90” /> tuetotechni #msexcel short keys

Ctrl+ASelect all
contents of a worksheet.
Ctrl+BBold all cells in the highlighted section.
Ctrl+DFill Content of the selected cell
on top to bottom. CTRL + D (i.e. Ctrl+ Down)
Ctrl+FSearch current sheet.
Ctrl+GGo to a certain area.
Ctrl+HFind and Replace
Ctrl+IPuts italics on all cells in the
highlighted section.
Ctrl+KInserts a hyperlink.
Ctrl+PPrint the current sheet.
Ctrl+RFill Right.
Ctrl+SSaves the open worksheet.
Ctrl+UUnderlines all cells in the highlighted section.
Ctrl+VPastes everything copied onto
the clipboard.
Ctrl+WCloses the current workbook.
Ctrl+XCuts all cells within the
highlighted section.
Ctrl+YRepeats the last entry.
Ctrl+ZUndo the last action.
Ctrl+1Changes the format of the selected cells.
Ctrl+2Bolds all cells in the
highlighted section.
Ctrl+3Puts italics all cells in the highlighted section.
Ctrl+4Underlines all cells in
highlighted section.
Ctrl+5Puts a strikethrough all
cells in the highlighted section.
Ctrl+6Shows or hides objects.
Ctrl+7Shows or hides the toolbar.
Ctrl+8Toggles the outline symbols.
Ctrl+9Hides rows.
Ctrl+0Hides columns.
Ctrl+;Enters the current date.
Ctrl+`Changes between displaying cell values or formulas in
the worksheet.
Ctrl+’Copies a formula from the
cell above.
Ctrl+Shift+”Copies value from cell above.
Ctrl+-Deletes the selected column or
Ctrl+Shift+=Inserts a new column or row.
Ctrl+Shift+~Switches between showing Excel
formulas or their values in cells.
Ctrl+Shift+@Applies time formatting.
Ctrl+Shift+!Applies comma formatting.
Ctrl+Shift+$Applies currency formatting.
Ctrl+Shift+#Applies date formatting.
Ctrl+Shift+%Applies percentage formatting.
Ctrl+Shift+^Applies exponential formatting.
Ctrl+Shift+*Selects the current region around the active cell.
Ctrl+Shift+&Places border around selected
Ctrl+Shift+_Removes a border.
Ctrl+Shift+(Unhide rows.
Ctrl+Shift+)Unhide columns.
Ctrl+/Selects the array containing the
active cell.
Ctrl+Selects the cells that have a static value or don’t
match the formula in the active cell.
Ctrl+[Selects all cells referenced by
formulas in the highlighted section.
Ctrl+]Selects cells that contain formulas that reference the
active cell.
Ctrl+Shift+{Selects all cells directly or
indirectly referenced by formulas in the highlighted section.
Ctrl+Shift+}Selects cells which contain formulas that directly or
indirectly reference the active cell.
Selects the cells within a column
that don’t match the formula or static value in the active cell.
Ctrl+EnterFills the selected cells with the current entry.
Ctrl+SpacebarSelects the entire column.
Ctrl+Shift+SpacebarSelects the entire worksheet.
Ctrl+HomeMove to cell A1.
Ctrl+EndMove to last cell on worksheet.
Ctrl+TabMove between Two or more open
Excel files.
Ctrl+Shift+TabActivates the previous workbook.
Ctrl+Shift+AInserts argument names into a
Ctrl+Shift+FOpens the drop-down menu for fonts.
Ctrl+Shift+OSelects all of the cells that
contain comments.
Ctrl+Shift+POpens the drop-down
menu for point size.
Shift+InsertPastes what is stored on the
Shift+Page UpIn a single column, highlights all cells above that which are selected.
In a single column, highlights all cells
above that which are selected.
Shift+HomeHighlights all text to the left of the cursor.
Shift+EndHighlights all text to the right
of the cursor.
Shift+Up ArrowExtends the highlighted area up one cell.
Extends the highlighted area down
one cell.
Shift+Left ArrowExtends the highlighted area left one character.
Shift +Right
Extends the highlighted area
right one character.
Alt+TabCycles through applications.
Alt+SpacebarOpens the system menu.
Alt+EnterWhile typing text in a cell,
pressing Alt+Enter will move to the next line, allowing for multiple lines of
text in one cell.
Alt+=Creates a formula to sum all of the above cells.
Alt+’Allows formatting on a dialog
F1Opens the Help menu.
F2Edits the selected cell.
F3After a name has been created, F3
will paste names.
F4Repeats last action. For example, if you changed the color of text in another cell, pressing
F4 will change the text in 
cell to the same color.
F5Goes to a specific cell. For example, C6.
F6Move to the next pane.
F7Spell check selected text or document.
F8Enters Extend Mode.
F9Recalculates every workbook.
F10Activates the menu bar.
F11Creates a chart from selected data.
F12Save as.
Shift+F1Opens the “What’s This?” window.
Shift+F2Allows the user to edit a cell
Shift+F3Opens the Excel formula window.
Shift+F5Brings up a search box.
Shift+F6Move to previous pane.
Shift+F8Add to selection.
Shift+F9Performs calculate function on activesheet.
Ctrl+F3Open Excel Name Manager.
Ctrl+F4Closes current Window.
Ctrl+F5Restores window size.
Ctrl+F6Next workbook.
Ctrl+Shift+F6Previous workbook.
Ctrl+F7Moves the window.
Ctrl+F8Resizes the window.
Ctrl+F9Minimize current window.
Ctrl+F10Maximize currently selected
Ctrl+F11Inserts a macro sheet.
Ctrl+F12Opens a file.
Ctrl+Shift+F3Creates names by using those of either row or column
Ctrl+Shift+F6Moves to the previous worksheet
Ctrl+Shift+F12Prints the current worksheet.
Alt+F1Inserts a chart.
Alt+F2Save as.
Alt+F4Exits Excel.
Alt+F8Opens the macro dialog box.
Alt+F11Opens the Visual Basic editor.
Alt+Shift+F1Creates a new worksheet.
Alt+Shift+F2Saves the
current worksheet.


ms excel short keys

2 thoughts on “Ms excel shortkeys

  1. Hello there, I found your website by way of Google even as looking for a comparable subject, your site
    came up, it appears to be like great. I’ve bookmarked it in my google bookmarks.

    Hello there, simply changed into alert to your blog through Google, and located that it is truly informative.
    I am gonna watch out for brussels. I will be grateful in the event
    you continue this in future. Lots of other folks shall be
    benefited out of your writing. Cheers!

Leave a Reply

Your email address will not be published. Required fields are marked *