50 MS Excel Shortcuts PDF

## 50 MS Shortcut Keys **Shortcut** | **Particulars** ------- | -------- CTRL+N | Create a new blank CTRL+O | Open an existing CTRL+W | Close a document CTRL+S | Save the active document F12 | Open the save as dialog box CTRL+Z | Undo the last action CTRL+Y | Redo the last action CTRL+A | Select a...

## 50 MS Shortcut Keys **Shortcut** | **Particulars** ------- | -------- CTRL+N | Create a new blank CTRL+O | Open an existing CTRL+W | Close a document CTRL+S | Save the active document F12 | Open the save as dialog box CTRL+Z | Undo the last action CTRL+Y | Redo the last action CTRL+A | Select all text and object CTRL+C | Copy selected text or object CTRL+X | Cut the selected text or object CTRL+SHIFT+C | Copy formatting of selected text CTRL+SHIFT+V | Apply copied formatting to selected text CTRL+P | Print the document CTRL+B | Apply or remove bold CTRL+I | Apply or remove italic CTRL+V | Apply or remove underline CTRL+R | Right align text CTRL+L | Left align text CTRL+E | Center align text CTRL+J | Justify text CTRL+1 | Apply single line spacing CTRL+2 | Apply double line text F7 | Open spell check SHIFT+F7 | Use the thesaurus CTRL+ENTER | Insert a line break CTRL+F1 | Display help window ESC | Close an open menu or task CTRL+SHIFT+< | Decrease the font size of selected text CTRL+SHIFT+> | Increase the font size of selected text CTRL+F OR H | Open find or find/replace F5 OR CTRL+G | Display go to dialog box HOME/END | Jump to start or end of a line CTRL+K | Insert a hyperlink INSERT | Turn on or off over type SHIFT+RT/LFT+ARROW | Select one character to the right or left CTRL+SHIFT+RT/LFT+ARROW | Select one word to the right or left CTRL+N | Create a new blank ## 50 MS Excel Shortcut Keys **Shortcut** | **Particulars** ------- | -------- CTRL+C | Copy CTRL+V | Paste CTRL+X | Cut CTRL+Z | Undo CTRL+F | Find CTRL+P | Print CTRL+B | Bold CTRL+I | Italic CTRL+U | Underline CTRL+A | Select all CTRL+RIGHT ARROW | Fill right CTRL+DOWN ARROW | Fill down CTRL+HOME | Go to the beginning of the worksheet CTRL+END | Go to the end of the worksheet CTRL+ARROW | Select cells CTRL+PAGE UP/DOWN | Move between worksheets CTRL+SHIFT+; | Move to the current data design CTRL+; | Enter the current date CTRL+SHIFT+: | Enter the current time CTRL+SHIFT+& | Enter the current date and time CTRL+1 | Format cell and dialog box CTRL+SHIFT+@ | Apply outline border CTRL+SHIFT+$ | Apply time format CTRL+SHIFT+% | Apply currency format CTRL+SHIFT+^ | Apply percentage format CTRL+SHIFT+# | Apply exponential format CTRL+SHIFT+! | Apply date format CTRL+5 | Apply number format CTRL+9 | Strike through CTRL+0 | Hide rows CTRL+SHIFT+9 | Hide columns CTRL+SHIFT+0 | Unhide rows CTRL+SHIFT+& | Unhide columns CTRL+SHIFT+~ | Protect cells CTRL+T | Create a table CTRL+SHIFT+T | Convert a range to a table CTRL+SHIFT+& | Merge and center cells CTRL+SHIFT+'+' | Copy from above cells CTRL+SHIFT+L | Select the entire column CTRL+SHIFT+O | Select the entire row CTRL+ALT+V | Paste special CTRL+SHIFT+4 | Apply dollar sign format CTRL+SHIFT+5 | Apply asterisk format CTRL+SHIFT+6 | Apply caret format CTRL+F3 | Define a name CTRL+SHIFT+F3 | Define names from selection CTRL+SHIFT+L | Apply autofill CTRL+SHIFT+O | Select all cells with comments ## Tally Shortcut Keys **Shortcut** | **Description** ------- | -------- F12 | Only press F12 ALT+F12 | Alt F12 CTRL+F12 | Ctrl F12 ALT+P | Alt P ALT+C | Alt C ALT+E | Alt E ALT+A | Alt A DD | Display -> Day book -> Select period DAL | Display -> Account -> Book ledger ### Shortcut while passing entry: **Shortcut** | **Description** ------- | -------- ALT+C | Alt C CTRL+ENTER | Ctrl Enter CTRL+A | Ctrl A CTRL+N | Ctrl N ALT+R | Alt R ALT+U | Alt U ### Her shortcut: - **To select a company:** Elect the accounts button and inventory button - **To change the menu period:** Select the company - **To select the conta voucher:** Select the payment voucher - **To select the receipt voucher:** Select the journal entry - **To select the sales voucher:** Select the sales voucher - **To select the credit voucher:** Select the debit note voucher - **To select the reversing note voucher:** Select the memorandum voucher - **To select the function and features screen:** Select the configure screen The document contains information about shortcut keys in different applications.