#EXCEL KEYBOARD SHORTCUTS 2013 EDITING HOW TO#

You can unhide a worksheet by right-clicking on a visible sheet tab and choosing the Unhide option. ItвЂ™s possible for worksheet tabs to be hidden completely in Microsoft Excel. If there is data on the worksheet then you will be prompted to confirm its deletion. You can remove a worksheet from your Excel workbook by right-clicking on the tab at the bottom of the window, then choosing the Delete option. Much as you can create new worksheets in Excel 2013, you are also able to delete them.

#EXCEL KEYBOARD SHORTCUTS 2013 EDITING HOW TO#

More Information on How to Insert a New Worksheet in Excel 2013 The new sheet will be added to the left of the tab that you just selected. You can control where you add these new sheet tabs by selecting one of your existing worksheets, then pressing the Shift + F11 key combination. You can use the Shift + F11 keyboard shortcut to add a new worksheet in Excel 2013. But there are shortcuts for a lot of other things too, including an insert worksheet tab shortcut, that donвЂ™t use the Ctrl key. Some common shortcuts are Ctrl + C to copy, Ctrl + V to paste, Ctrl + Z to undo, etc. Typically these shortcuts involve a combination of the Ctrl key and something else.

If you perform certain functions a lot in Microsoft Excel then you may be accustomed to using keyboard shortcuts to perform those functions. Is There a Keyboard Shortcut to Add New Sheet Tabs in Excel 2013? Learn how to unhide worksheet tabs in Excel 2013 to make it easier to switch between worksheets. Just right click on the button and Add it to Quick Access Toolbar.If you are unable to see the worksheet tabs at the bottom of Excel, then they may be hidden. You can do the same thing to any other command or action you need to use on both PowerPoint and Excel (this also works for Word). YouвЂ™ll see a number corresponding to the shortcut, in this case itвЂ™s the number 4 that activates the AutoSum command. To activate this shortcut, all you have to do is hit the Alt key on your keyboard. ItвЂ™ll be added to the top left corner of Excel, in the same row as the вЂSaveвЂ™ and вЂUndoвЂ™ icons. To add a keyboard shortcut to AutoSum, right-click on it and select вЂAdd to Quick Access ToolbaвЂ™r. ItвЂ™s handy to have a keyboard shortcut assigned to that if you are doing your bookkeeping, for instance. When you need the values of certain fields added up together, you use the AutoSum function. LetвЂ™s use the example of the AutoSum button. However, adding keyboard shortcuts is simpler for both PowerPoint and Excel. There are some limitations creating shortcuts on PowerPoint and Excel as you donвЂ™t get as much flexibility compared to Word. Custom Keyboard Shortcuts For PowerPoint & Excel Again, this is not just limited to Strikethrough but any command you set with a keyboard shortcut combination. Now whenever you highlight text with your mouse, you can press Alt + S to Strikethrough it. If it is empty that means you have yet to assign a shortcut to the command. You can see all the assigned shortcuts you have for each command in the вЂCurrent keysвЂ™ box. This is important as you do not want to double assign a combination. You can see that the combination Alt + S is not taken because itвЂ™s unassigned. YouвЂ™ll notice there is no shortcut key for Strikethrough - the вЂCurrent keysвЂ™ box is empty.Д¬lick on the вЂ Press new shortcut keyвЂ box and personalize a keyboard combination shortcut. WeвЂ™ll now demonstrate how to add a keyboard shortcut to the Strikethrough command on Word. This arrangement means youвЂ™ll easily find the command you want to customize as a keyboard shortcut.

These commands are in Categories based on the tabs in Word, e.g. LetвЂ™s first explain the things you see on this new window that pops up.Д¬ommands are the actions you normally do on Word, for example Bold and Italics.

Then navigate to Customize Ribbon and youвЂ™ll find вЂKeyboard shortcutsвЂ™ click on the Customize button next to it. Start Word 2013 and navigate to the Options section by clicking on File > Options. Keys that we suggest to use would be a combination of Ctrl, Shift and Alt followed by a letter. Out of the 3 Office products weвЂ™ll be featuring here, only Word has the option to use custom keyboard combinations to trigger an action. Read more Custom Keyboard Shortcuts For MS Word Keyboard shortcuts can boost your productivity if your daily job relies heavily on using Windows. 200 Keyboard Shortcuts (Windows) to Boost Your Productivity

Excel keyboard shortcuts 2013 editing