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.Ģ.
#Excel shortcut keys for accounting 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.
0 kommentar(er)
