microsoft office excel 2013 keyboard shortcuts

MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS UPGRADE
MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS PRO
MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS SOFTWARE

A few of the keyboard shortcuts from the File menu still work, but others do not. In Excel, any Excel 2003 keyboard shortcuts you memorized between the Edit and Window menus continue to work. My favorites, for example, are Alt+E+S+V for Edit, Paste Special, Values, Alt+O+C+A for F ormat, Column, AutoFit Selection, and Alt+E+I+J for Edit, F ill, Justify. Many people who used the old Excel regularly memorized a few Alt keyboard shortcuts. Strategy: Your old keystrokes still work you just have to invoke them a bit more slowly than usual. Microsoft completely eliminated the Edit menu, so what shortcuts do I use now? For example, I often used Alt+E+I+J to invoke Edit, Fill, Justify. I used to use a lot of keyboard shortcuts.

MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS UPGRADE

Considering an upgrade to your Microsoft Office suite, or looking for other ways to make your technological life more productive and efficient? Contact CMIT Solutions today - we’re here to make technology work for your business.Problem: I can't find anything on the ribbon.

MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS PRO

Whether you’re a seasoned Excel pro scanning the horizon for fresh usability tricks, or a new user scrambling to make sense of it all, these shortcuts should beef up your program experience. Need to format numbers? Press Ctrl + Shift + $ to apply Currency format, Ctrl + Shift + ~ to apply General number format, Ctrl + Shift % to apply Percentage format, Ctrl + Shift + # to apply Date format, Ctrl + Shift + to apply Time format, Ctrl + Shift + ! to apply Number format with two decimal places and thousands separator, and Ctrl + Shift + ^ to apply Scientific Number format. Need to format data? Press Ctrl + 1 to open the Format Cells dialog, Ctrl + B to apply or remove bold formatting, Ctrl + I to apply or remove italic formatting, and Ctrl + U to apply or remove underline.ġ0. Want to hide or show elements? Press Ctrl + 9 to hide selected rows, Ctrl + Shift + 9 to unhide any hidden rows, Ctrl + 0 (zero) to hide selected columns, and Ctrl + Shift + 0 to unhide any hidden columns.ĩ. Need to set up or activate hyperlinks? Press Ctrl + K to insert a hyperlink and Enter in a cell with a link to activate it.Ĩ. Want to insert a table, row, column, comment, or chart? Press Ctrl + l to insert a table, Ctrl + Shift + + to insert a cell, row, or column, Ctrl + F2 to insert a comment, and Alt + F1 to insert a chart with data.ħ. Need to edit active or selected cells? Press Ctrl + D to fill complete cell down, Ctrl + R to fill complete cell to the right, Ctrl + “ (quote) to fill cell values down and edit, Ctrl + ‘ (apostrophe) to fill cell formulas down and edit, and Ctrl + – (minus) with entire row or column selected to delete row or column.Ħ.

Want to copy, paste, or cut, or undo? Press Ctrl + C to copy the contents of selected cells, Ctrl + X to cut the contents of selected cells, Ctrl + V to paste content into a selected cell, and Ctrl + Z to undo the last action.ĥ. Want to select a broad swath of data? Press Shift + Space to select the entire row, Ctrl + Space to select the entire column, Ctrl + Shift + * (asterisk) to select the current region around the active cell, and Ctrl + A to select the entire worksheet.Ĥ. Need to find or replace a specific piece of data? Press Ctrl + F to display the Find and Replace dialog box with Find selected press Ctrl + H to display it with Replace selected.ģ. Want to move to the beginning or end of a worksheet? Press Ctrl + Home or Ctrl + End rather than scrolling for what feels like forever.Ģ.

MICROSOFT OFFICE EXCEL 2013 KEYBOARD SHORTCUTS SOFTWARE

But for those who use Excel frequently, adopting a few of these shortcuts can save you lots of time - print them out and keep them handy if you live in Excel.Īt the end of the day, that’s what CMIT Solutions specializes in: helping you maximize the productivity and efficiency of the software and hardware you use while minimizing technology-related disruptions.ġ. These tips represent just one small portion of your day-to-day experience with the program. We thought we’d share a few more standard keyboard shortcuts that can make your Microsoft Excel use smarter, faster, and better. As it should: while firm market share figures specific to Excel are hard to come by, Microsoft Office, the productivity suite in which Excel comes packaged, still claims approximately 80% to 96% of worldwide user share. But the list of keyboard shortcuts and productivity boosters that can help supercharge this gold standard in spreadsheet software continues to increase. In early 2014, CMIT Solutions covered 10 tricks, tips, apps, and add-ins for Microsoft Excel.

Microsoft office excel 2013 keyboard shortcuts