Repeats the last thing you did, such as inserting a row, applying a fill color or deleting a column, on the cells you have selected now. It works only while you are not editing a cell, because in edit mode F4 toggles absolute references instead.
Questions
Why does F4 do nothing on my laptop?
On many laptops the F keys control volume or brightness. Hold Fn and press F4.
More Edit shortcuts
- Add or edit a noteShift+F2
- Cancel the entryEsc
- Clear the cell contentsDelete
- Open the right-click menuShift+F10
- CopyCtrl+C
- CutCtrl+X
- Delete the selected rows or cellsCtrl+-
- Edit the active cellF2
- Fill downCtrl+D
- Fill rightCtrl+R
- Enter the same value in every selected cellCtrl+Enter
- Insert a chart on the sheetAlt+F1
- Start a new line in a cellAlt+Enter
- Open a dropdown listAlt+Down
- PasteCtrl+V
- Paste SpecialCtrl+Alt+V
- RedoCtrl+Y
- Check spellingF7
- Turn filters on or offCtrl+Shift+L
- UndoCtrl+Z