Shortcut 3: Trace Dependents In addition to tracing precedents, you may also want to trace dependents. If the selected range contains more than one column, then the result is based on the first column of the selected range, although the corresponding rows in the other columns are also selected. PC: Alt + T + R Mac: Control + Option + Right Bracket () This will remove the arrows from your worksheet, making it easier to read and work with your data. If the selected range contains only one column, then the result is based on the last cell in the selected range. Observation: The Ctrl-Shft-↓ shortcut can also be used when more than one cell is selected. Remove contents of all cells in the highlighted rangeĬancel a cell entry this is especially useful when you have inadvertently tried to modify a part of a range containing an array formula Move one cell up, down, right or left in a worksheet
If the current cell is not empty then extend the range down to the last non-blank cell, while if the current cell is empty then extend the range down to the first non-empty cellĬycle through absolute and relative addressing in a cell rangeĬalculate the value of a formula and then replace the formula by its value Remove any borders in and around the highlighted range Remove contents of highlighted range (Cut)Ĭopy contents of the topmost cell (or row) in the highlighted range into the cells below (Fill Down)Ĭopy contents of the leftmost cell (or column) in the highlighted range into the cells on the right (Fill Right)ĭisplay the arguments in a worksheet function after typing the function’s nameĭraw a border around the highlighted range Paste previously copied range into the highlighted location (Paste) The following are some Excel keyboard shortcuts that are especially useful: Shortcut Jump to Category Insert current date, Ctrl, Insert current time, CtrlShift: Fill down from cell above, CtrlD D Fill right from cell left, CtrlR.
0 kommentar(er)
