Posted  by  admin

Microsoft Excel Shortcut Keys Download

Microsoft Excel Shortcut keys - PDF Download

Microsoft Excel shortcut keys Some basic knowledge of Excel shortcut keys will take you a long way on your journey into the unknown. The first keyboard shortcut we learn is copy, the first word processor we use is Word. The first spreadsheet application we use it Excel. In fact, the first time we use it, we don’t even know what a spreadsheet is. Microsoft Excel having so many unbelievable capabilities that are not instantly perceived.Excel Shortcut keys are most useful and usable to save the time. Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. In this video, I will show you 10 simple ways to clean data in Excel.Data forms the backbone of any analysis that you do in Excel. And when it comes to data. REQUIREMENTS This version of Excel is built for phones and tablets (with a screen size of 10.1 inches or smaller).

Download some helpful MS Excel shortcut keys PDF to save your valuable time at work. You can find here all MS Excel shortcut keys for work, MS EXCEL

Everyone basically uses MS- Excel for analyzing, sharing, and managing information for accounting purposes performing mathematical calculations, budgeting, billing, etc. If you knew about all shortcut keys of Excel so you can do your work on the computer fast. If you don't know about Excel shortcut keys, in this post we will give you Excel all shortcut keys PDF.

Excel shortcut keys

Shortcut KeysFunctions
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+LOpens the Create Table dialog box.
Ctrl+RFill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+HomeMove to cell A1.
Ctrl+EndMove to last cell with text on the worksheet.
Ctrl+Shift+POpens the drop-down menu for point size.
Shift+InsertPastes what is stored on the clipboard.
Shift+Page UpIn a single column, highlights all cells above that are selected.
Shift+Page DownIn a single column, highlights all cells above that 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.
Shift+Down ArrowExtends the highlighted area down one cell.
Shift+Left ArrowExtends the highlighted area left one character.
Shift +Right ArrowExtends the highlighted area right one character.
Ctrl+SSaves the open worksheet.
Ctrl+ZUndo the last action.
Ctrl+1Changes the format of the selected cells.
Ctrl+2Bolds all cells in the highlighted section.
Ctrl+TOpen the Create Table dialog box.
Ctrl+WCloses the current workbook.
Ctrl+XCuts all cells in the highlighted section.
Ctrl+YRepeats the last entry.
Ctrl+UUnderlines all cells in the highlighted section.
Ctrl+VPastes everything copied onto the clipboard.
F1Opens the help menu.
F2Edits the selected cell.
F3After a name is 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 option.
Alt+Shift+F2Saves the current worksheet.
Ctrl+NCreates a new workbook.
Ctrl+OOpens a workbook.
Ctrl+PPrint the current sheet.
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+Shift+:Enters the current time.
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 row.
Ctrl+Shift+=Inserts a new column or row.
Ctrl+Shift+~Switches between showing Excel formulas or their values in cells.
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+; Enter the current Time
CTRL+; Enter the current date
Shift+F3 Open the insert Function window
Shift+F5 Opens Find and replace dialog box
CTRL+A Select all contents of the worksheets
CTRL+B Bold highlighted selection
CTRL+I Italic highlighted selection
CTRL+K Insert Link
CTRL+U Underline highlighted selection
CTRL+P Bring out the print dialog box to being prating
CTRL+Z Undo the last action
CTRL+F9 Minimize current workbook
CTRL+F10 Minimize current selected workbook
CTRL+F6 Switch between open workbooks/ Windows
CTRL+ Page Up Move the previous sheet between Excel worksheet in the same Excel
document
CTRL+P Being up print dialog box to being printing
CTRL+Z Undo the last action
CTRL+ Page Down Move the next sheet between Excel worksheet in the same Excel document
CTRL+ Tab Move between or more open Excel Files
ALT+= Create a formula to sum all of the above cell
Shift + home Go to the first cell in the current row
CTRL + shift+! Format number in comma format
CTRL + shift+$ Format number in currency format
CTRL + shift+# Format number in date format
CTRL + shift+% Format number in percentage format
CTRL + [email protected] Format number in time format
CTRL+ SPACE Select entire column
SHIFT+SPACE Select entire row

MS Excel Shortcut Keys PDF Sownload

Microsoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most useful and usable to save the time.

Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts as it’s kind of amazing how much time we can save by not using the mouse clicks. Keyboard shortcuts in Excel are commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key.

We really liked that windows gives us multiple ways to perform the task in Excel, let’s say we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”.

Below are the amazing Shortcuts for Excel category wise, in which you will find the Excel formula shortcuts, Excel copy paste shortcuts, Excel keyboard shortcuts to insert row, Excel keyboard shortcuts to select row, Keyboard shortcuts for VBA and Excel hot keys (add more alt shortcuts to Excel).

Keyboard shortcuts for Dialog Box:-

Entering Data shortcuts:-

File Commands:-

Keyboard shortcuts for Format:-

Formulas shortcuts:-

Microsoft Excel Shortcut Keys Download

General keyboard shortcuts:-

Microsoft Excel Shortcut Keys Pdf Download

Important Hot Keys:-

Shortcuts for Navigating:-

Keyboard shortcuts for selecting rows/column/cell:-

Window shortcut keys:-

Microsoft excel shortcut keys download freeMicrosoft Excel Shortcut Keys Download

Microsoft Excel 2007 Shortcut Keys List.pdf Download

Workbook shortcut keys:-

Microsoft Office Excel 2007 Shortcut Keys Pdf Free Download


Download – List of 250 Ms-Excel Keyboard Shortcuts