Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These shortcuts will expedite the Excel tasks you perform every day.
Here is the solution which improve your accuracy and make your life easier.
Spend few minutes to save your valuable time ….
| Select the whole column | CTRL + SPACE |
| Select the whole row | SHIFT + SPACE |
| Select table | SHIFT + CTRL + SPACE bar |
| Save | CTRL + s |
| Select visible cells only | ALT + ; |
| Select entire region | CTRL + A |
| Select range from start cell to far left | SHIFT + Home |
| Select range from start cell to end in direction of arrow | SHIFT + End + arrow |
| Select a continuous range of data (e.g. pivot), no matter where your cursor is. | CTRL + * |
| Select blank cells | F5 + ALT + S + K + ENTER |
| Select all cells with comments | CTRL + SHIFT + O |
| Select all cells that are directly or indirectly referred to by formulas in the selection | CTRL + SHIFT + { |
| Select all cells with formulas that refer directly or indirectly to the active cell | CTRL + SHIFT + } |
| Selects all the way to a1 from cursor position | CTRL + SHIFT + HOME |
| Select cells in the direction of arrow | CTRL + SHIFT + Arrow |
| Previous sheet | CTRL + Page Up |
| Next sheet | CTRL + Page Down |
| Launch GO TO Dialog (from here you can select special or jump to a cell or range) | F5 |
| Go to top left (will go to top left of freezed pane if set) | CTRL + Home |
| Go to last non-blank cell | CTRL + end |
| Go to previous sheet | CTRL + PgUp |
| Go to next sheet | CTRL + PgDn |
| | CTRL + p |
| Toggle between workbooks in a given session of excel. | CTRL + TAB |
| Change the type of cell reference from relative to absolute or semi-absolute | F4 |
| Repeat whatever you did last | F4 |
| Debug portions of a formula (select and press) | F9 |
| Sum range | ALT + = |
| Enter array formula | CTRL + SHIFT + Enter |
| Select array formula range | CTRL + / |
| Display range names (can be used when typing formulas) | F3 |
| Copy a formula from above cell and edit | CTRL + ' |
| Display the formula palette after you type a valid function name in a formula | CTRL + A (while writing a formula) |
| Alternate between displaying cell values and displaying cell formulas | CTRL + ` (Single Left Quotation Mark) |
| Calculate formulas | F9 |
| Select all precedent cells | CTRL + [ |
| Select all dependent cells | CTRL + ] |
| Format Selection (cells, objects, charts) | CTRL + 1 |
| Bold a cell’s content | CTRL + B |
| Format Painter – Paste formats from selection | ALT + EST |
| Format as number with 2 dp | CTRL + SHIFT + 1 |
| Format as local currency | CTRL + SHIFT + 4 |
| Format as percentage with 0 dp | CTRL + SHIFT + 5 |
| Hide row | CTRL + 9 |
| Hide column | CTRL + 0 |
| Unhide row | CTRL + SHIFT + 9 |
| Unhide column | CTRL + SHIFT + 0 |
| Display the style command format menu | ALT + ' |
| Sets/removes strikeout in current cell | CTRL + 5 |
| Show/hide the top bar when you have a group | Crtl + 8 |
| Single border around selected cells | CTRL + SHIFT + 7 |
| Sort | ALT + DS |
| Insert hyperlink | CTRL + K |
| Freeze panes | ALT + WFF |
| To wrap lines | ALT + HW (2007+) |
| Save as | F12 |
| Collapse the ribbon (press again to expand) | CTRL + F1 |
| Opens print preview | CTRL + F2 |
| Maximize the current window | ALT + SPACE X |
| Activate next window | ALT + TAB |
| Activate previous window | ALT + SHIFT + TAB |
| Close an excel workbook | crtl + F4 |
| Split screens | ALT + W + S |
| Create a pivot table in new sheet (of course after selecting the range) | ALT + DPF |
| Create a pivot table in the same sheet. | ALT + DPN |
| Show visual basic editor | ALT + F11 |
| Macro dialog | ALT + F8 |
| Apply/remove filter | ALT + DFF |
| Keep filter on columns, but show all rows | ALT + DFS |
| Insert pivot table | ALT + NVT |
| Turn filter on or off | CTRL + SHIFT + L |
| Paste values only | ALT + ESV |
| Edit a cell, place cursor at the end | F2 |
| Show in-cell drop down with previously entered values | ALT + Down arrow |
| Fills down value from cell above | CTRL + D |
| Add a comment or Edit comment | SHIFT + F2 |
| Insert new sheet | SHIFT + F11 |
| Insert row | CTRL + + |
| Delete row | CTRL + - |
| Copy | CTRL + C |
| Paste | CTRL + V |
| Cut | CTRL + X |
| Undo | CTRL + Z |
| Get a line break inside the cell | ALT + Enter (while editing the cell) |
| Clear all contents | ALT + EAA |
| Copy | CTRL + insert |
| Paste | SHIFT + Insert |
| Make chart/pivot chart | F11 |
| Edit a cell in Apple Macs | CTRL + U |
| Copy the value from the cell above the active cell into the cell or the formula bar | CTRL + SHIFT + " |
| Copies whatever is in the cell to the left of it. | CTRL + R |
| Delete box (cell, row, column) | ALT + ED |
| Insert box (cell, row, column) | ALT + IE |
| Enter current date | CTRL + ; |
| Enter current time | CTRL + : |
Post a Comment