| Excel Some Useful Shortcuts | ||
| Shortcut key | Action | Menu equivalent comments |
| Alt or F10 | Menu | Go to Menu bar |
| Alt+’ | Format Style dialog box | Format the Style |
| Alt+= | AutoSum | Sum Formaula Showing in Cell |
| Alt+Down arrow | Display AutoComplete list | Displaying Auto Complete Data List |
| Alt+F1 | Insert Chart | Insert the Chart |
| Alt+F11 | Visual Basic Editor | Tools, Macro, Visual Basic Editor |
| Alt+F2 | Save As | Save File to Save As |
| Alt+F4 | Exit | File Exit |
| Alt+F8 | Macro dialog box | Macro dialog box Tools |
| Alt+Shift+F1 | New worksheet | Insert New Worksheet |
| Alt+Shift+F2 | Save | Save the File |
| Ctrl + Shift + L | Filter | Filter the Row |
| Ctrl W | Close | Close the Open File |
| Ctrl+- | Delete | Delete the Rows, Columns and Cells Right or Down Depends on selection |
| Ctrl+! | Format cells dialog box | Font Tab Open in Format Cell Tool |
| Ctrl+# | Italic | Cell Font Style Change to Italic toggle |
| Ctrl+$ | Underline | Cell Font Style Change to Underline toggle |
| Ctrl+% | Strikethrough | Cell Font Style Change to Strikethough |
| Ctrl+( | Hide rows | Hide the Row |
| Ctrl+) | Hide columns | Hide the Coloumns |
| Ctrl+; | Insert Current Date | Add the Current Date |
| Ctrl+@ | Bold | Cell Font Style Change to Blod toggle |
| CTRL+[ | Select all cells directly referenced by formulas in the selection. | Referene Contains Cell Easily Find |
| CTRL+] | Select cells that contain formulas that directly reference the active cell. | Referene Formula Cell Easily Find |
| Ctrl+` | Column Widht | Coloumn Width Increase Double Size |
| Ctrl++ | Insert | Insert the Rows, Columns and Cells Right or Down Depends on selection |
| Ctrl+A | Select All | Selecting Entire Sheet |
| Ctrl+Alt+V | Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. | Purpose Paste and Paste Special |
| Ctrl+Alt+V, Press A | Displays the Paste Special dialog box, Selecting All | Purpose Paste and Paste Special |
| Ctrl+Alt+V, Press V | Displays the Paste Special dialog box, Selecting Values | Purpose Paste and Paste Special |
| Ctrl+B | Bold | Cell Font Style Change to Bold toggle |
| Ctrl+C | Copy | As Your Wish to Copy Selected Cells |
| Ctrl+D | Fill Down | Copy to Down Cell |
| Ctrl+F | Find | Find What you Find |
| Ctrl+F1 | Hide the Menubar | Hiding the Menubar |
| Ctrl+F10 | Maximize or restore Down window | Maximize and restore Down the window |
| Ctrl+F11 | Macro sheet | Inster the Macro Worksheet |
| Ctrl+F12 | File Open | Open the File |
| Ctrl+F2 | Format Shape & Print | 1st Side to Open Format Shape Tool, Next Immediately Open Print Option |
| Ctrl+F3 | Name Manager | New Name add to Refer Cell (Any Cell You Want add New Name) |
| Ctrl+F4 | Close | Close the Open File |
| Ctrl+F5 | Restore Down | Window Size Change |
| Ctrl+F6 | Next workbook | Next Workbook Window Change |
| Ctrl+F7 | Move window | 1st Change the Window Size Pressing Ctrl+F5, After Window Move to Any Area |
| Ctrl+F8 | Add to selection | Multiple Different Cell Add to Selection |
| Ctrl+F9 | Minimize workbook | Minimize the Worksheet |
| Ctrl+G | Go to | Type the Reference Cell Numver Want to Go |
| Ctrl+H | Replace | Find What you Find to Replace With Another Word |
| Ctrl+I | Italic | Cell Font Style Change to Italic toggle |
| Ctrl+K | Insert Hyperlink | Hyperlink Insret |
| Ctrl+N | New Workbook | New File |
| Ctrl+O | Open | Open File |
| Ctrl+P | Print File | |
| Ctrl+R | Fill Right | Copy to Right Cell |
| Ctrl+S | Save | Save the Workbook File |
| Ctrl+Shift+& | outline border around selected cells | Place outline border around selected cells |
| Ctrl+Shift+( | Unhide rows | Unhide the Hided Rows |
| Ctrl+Shift+) | Unhide columns | Unhide the Hided Coloumns |
| Ctrl+Shift+: | Insert Current Time | Add the Current Time |
| Ctrl+Shift+_ | Remove outline border | Remove outline border around selected cells |
| Ctrl+Shift+A | Insert argument names into formula | 1 st Type the Formula Name in Cell Next Press the Shortcut |
| Ctrl+Shift+F1 | Full Mode | Hide the QuickAccess, Menu and Status bar |
| Ctrl+Shift+F12 | Print File | |
| Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert, Name, Create |
| Ctrl+Shift+F6 | Workbook Switch | Last Workbook Switch Between Multiple Sheets |
| CTRL+SHIFT+SPACEBAR | Selects the entire worksheet. | Selecting he entire worksheet. |
| Ctrl+Spacebar | Select the entire column | Selecting the entire column |
| Ctrl+Tab | In the toolbar next toolbar | Go to Next Option in Toolbar |
| Ctrl+Tab | In a workbook: next workbook | Switch Next Workbook |
| Ctrl+U | Underline | Cell Font Style Change to Underline toggle |
| Ctrl+V | Paste | 1st Copy the Selected Area, And Next Paste to Anywhere in Workbook |
| Ctrl+X | Cut | As Your Wish to Cut Selected Cells |
| Ctrl+Y | Repeat | 1st Using Undo After You can use the Repeat |
| Ctrl+Z | Undo | Sack to Steps Previous |
| Enter | Move to Down Cell | Move to Down Cell |
| F1 | Help | Excel Help |
| F10 | Menu | Go to Menu bar |
| F11 | New Chart | Insert Chart |
| F12 | Save As | File Save to Save As |
| F2 | Edit | You Can Edit the Word |
| F4 | While typing a formula, switch between absolute/relative refs | Change the Formula While you Formula Adding (For Example =Vlookup(a2 Now Press F4) |
| F5 | Go to | Type the Reference Cell Numver Want to Go |
| F6 | Menu & Status Bar | 1 time Press Go to Status Bar, 2 times Press to Menu Bar |
| F7 | Spell check | Spelling Modified |
| F8 | Extend mode | Extend Selection |
| SHIFT+BACKSPACE | Cells Selected | select only the active cell, With multiple cells selected With Hold Shift+Down Arrow |
| Shift+Ctrl+F | Font Tab Format Cell | Font Tab Open in Format Cell Tool |
| Shift+Ctrl+F6 | Previous workbook window | Previous Workbook Window Change |
| Shift+Ctrl+P | Font Tab Format Cell | Font Tab Open in Format Cell Tool |
| Shift+Ctrl+Tab | In the toolbar: previous toolbar | Go to Previous Option in Toolbar |
| Shift+Ctrl+Tab | In a workbook: previous workbook | Switch Previous Workbook |
| Shift+F10 | Display Options | If you Don't Want Use the Mouse Right, Then Use the Shortcut (And Also Shortcut Available Keyboad) |
| Shift+F11 | New worksheet | Insert the New Worksheet |
| Shift+F12 | Save | File Save |
| Shift+F2 | Edit cell comment | Insert and Edit Comments |
| Shift+F3 | Select a Formula Function | Insert a Furmula Function |
| Shift+F4 | Repeat last action | Repeat the Last Actions Works while not in Edit mode. (1st Using Find What : What You Find, After You Can Use Previuosly What You Find) |
| Shift+F5 | Find | Find What you Find |
| Shift+F6 | Menu & Status Bar | 1 time Press Go to Status Bar, 2 times Press to Menu Bar |
| Shift+F7 | Thesaurus | Type the words in groups of synonyms and related concepts |
| Shift+F8 | Add to selection | Multiple Different Cell Add to Selection, How to Use Press 2 Times, After Add to Selection |
| Shift+Spacebar | Select the entire row | Selecting the entire row |
| Shift+Spacebar and Ctrl+ - | Delete | Delete the Selected Area Row |
| Shift+Spacebar and Ctrl+ + | Insert | Insert the Selected Area Row |
| Shift+Tab | Move to Previous Left Cell | Move to Previous Left Cell |
| Tab | Move to Right Cell | Move to Right Cell |
| Esc | Escape | Stop the Selected Cells Copy |
| PgUp | Page Up | Go to Next WorkSheet |
| PgDn | Page Down | Go to Previous WorkSheet |
Discount Formula in Excel To Discount Formula an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula Here the Below Example for Discount Formulas : - 5% Discount formula is =A2*0.95 10% Discount formula is =A2*0.90 15% Discount formula is =A2*0.85 20% Discount formula is =A2*0.80 25% Discount formula is =A2*0.75 30% Discount formula is =A2*0.70 40% Discount formula is =A2*0.60 50% Discount formula is =A2*0.50 Another Way to Calculate Discount Formula in Excel How to Find Discounted Amount in Excel Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount Discounted Amount Formula is =A2*5% After Discount Amount Formula is =A2-C2 Another Easiest Way to Calculate Discount F ormula Col umn A is Product Pr ice, Col umn B is Discount Percentage % and C is After Discount
Comments
Post a Comment