You can press Ctrl-A again to select the entire worksheet. The list of Excel shortcuts tricks which are more than 225 can itself be overwhelming to learn and use effectively, but once mastered, the result would be a highly effective and efficient output in shorter time period. It’s smart to do this often to avoid losing valuable work-and time-if your computer freezes.Ĭontrol-A: Select the current region, which is defined by the contiguous block of cells that surround the cell you are currently working in. Fortunately for Excel users, every menu and operation in the application can be controlled from the keyboard with proper excel shortcuts. This command is best when you want to keep the data you have in place, but also repeat it elsewhere.Ĭontrol-V: Paste the data from the clipboard into a new area of the spreadsheet.Ĭontrol-S: Save the workbook you are currently working in. This command is most useful when you want to move the data completely to a different area of the spreadsheet.Ĭontrol-C: Copy selected blocks to the clipboard. Here are 15 keyboard shortcuts that can help you save time and work smarter.į2: Edits the active cell and positions the insertion point at the end of the cell contents.į4: When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references.Ĭontrol-X: Cut selected blocks of data.
Virtually everyone who works in finance-whether as an accountant, analyst, government contractor, or bookkeeper-spends a lot of time on Microsoft Excel.
0 kommentar(er)
