Shortcuts for excel on mac series#
This formula will look for a series of numbers directly above or directly to the left of the active cell and apply a =sum() formula to them. This includes numbers, text, formatting, and formulas.īoth these shortcuts are immensely useful when building a formula in one cell and trying to apply it across the entire row. When you have a block of cells selected, Fill Right takes whatever is contained in the left-most cell and spreads it across any cells to the right. This includes numbers, text, formatting, and formulas. Same as above, make sure the entire row is selected and active if you want to add a row 4. If an entire row is not selected, a dialog box will appear allowing you to delete that chunk of cells and shift the other cells to fill the gap instead. In order for this shortcut to work, the entire row (or rows) must be selected. You can use this same shortcut to select multiple rowsas well. This shortcut highlights the row where your cursor is. Quick Selection acts almost exactly like Quick Navigation except that it also selects the cells between where your cursor started and where you move.
Quick Selection: CMD + SHIFT + arrow keys.in an empty cell), then Excel will select the entire workbook.
It has one caveat though – if your cursor is outside of a block of data (i.e. This is a quick way to highlight a big section of data for copy-pasting or formatting. This shortcut selects the block of data surrounding your cursor. You need to jump across sheets within a single file? No problem, the above shortcut allows you to cycle past sheets without reaching for your mouse. if you press CMD + Left Arrow, then your cursor will jump to the left side of that block. Whenever you use CMD + arrow keys your cursor jumps to the last filled piece of the block of data you are currently in. If you are a power user of Excel on a Macbook then you will love these shortcuts as they will save you hours of time every month.
0 kommentar(er)
