Editing and filling practice exercises
Edit a cell without retyping it, fill a formula down a column, add a total in one keystroke and undo your way out of mistakes.
- 1Edit a cell without retyping itOpen a cell for editing, back out of it, and move on with Enter and Tab.
- 2Fill a formula down and rightCopy a formula to the rows below and the column next to it without retyping it.
- 3AutoSum, undo and redoAdd a total with one shortcut, then undo and redo it.
- 4Lock a reference with F4Fix a formula so it can be filled down, without retyping it.
- 5Fill every selected cell with Ctrl+EnterPut one formula into a whole selection at once.