In this worksheet, we have a set of data without formatting.
To illustrate how undo and redo work, I’ll make some changes to the worksheet.
This will make it easier to see and understand the history of changes.
Finally, I’ll apply a light gray border to the entire table.
Now if we check the Undo command on the ribbon, we’ll see each change listed.
I can use this dropdown menu to undo all 4 changes.
Then I can use the dropdown under Redo to redo all 4 changes.
The shortcut for Undo is Control + Z on Windows, Command + Z on a Mac.
Each time I use the shortcut, Excel moves back one step.
The shortcut for Redo is Control + Y on Windows, Command + Y on the Mac.
Just like Undo, each time I use the shortcut, I step forward one step.
The Repeat command works a bit differently.
It allows you to perform the same command again with a simple shortcut.
The shortcut for repeat is f4 or Control + Y on Windows and Command + Y on a Mac.
And if I apply a fill to this header row, I can use repeat for that as well.
But, if I add a formula to summarize sales by color using the SUMIF function…
The Repeat command is not available.
