Now we will see that how we can use undo and redo function in MS Excel.
Undo is the most used functionality in MS Excel, when we are entering any data in our excel sheet we sometimes make small mistakes, so to clear that one step mistake we use Undo.
Shortcut for using undo is 'Ctrl+Z'. Undo is located in quick access toolbar.
In quick access toolbar we will see undo icon, beside which there will be a small down arrow, when we hover on that it will show us that which particular action we want to undo.
Similarly redo icon is there in right of undo which is used to undo the action done by undo.
One thing which should be kept in mind while using undo and redo option is that we can only use this functionality while we're doing data entry. If we have done any mistake in sheet tab than it can't be undo or redo.
In Excel, the undo button returns your worksheet to the state it was in right before you took the most recent action. Redo has the reverse effect of undoing what you've just undone, such as deleting something by accident.
The undo function can be used to undo a mistake, such as erasing the incorrect word from a phrase. Any actions that were previously undone using the undo function are restored using the redo function. This capability is sometimes referred to as a reverse undo.
Excel will transition back to the income statement and undo the previous modification there if you hit Ctrl+Z to utilise Undo.
Press Ctrl+Y or F4 to redo something you've undone. (If pressing F4 doesn't seem to work, try pressing F-Lock or Fn, then F4). Click Redo on the Quick Access toolbar if you want to use the mouse.
There is no way to undo an undo. If you have accidentally undone something and want to get back to it, you will have to undo your latest action.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR