When you select a cell and hit F4 , your last action will be repeated. That includes formatting, inserting or deleting rows, and making changes to shapes.

When you select a cell and hit F4 , your last action will be repeated. That includes formatting, inserting or deleting rows, and making changes to shapes.