UNDO / REDO AND GOTO Learn Hindi.
After learning UNDO AND REDO OPTION you can go back one STEP or one STEP forward from the work you have done.
After learning GOTO OPTION you can go to any cell very quickly and after learning GOTO SPECIAL you can do your work with very SPEED.
So let’s learn about UNDO and REDO and GOTO option well.
Using UNDO OPTION we can move one STEP backwards from our LAST STEP. Going back means that if we accidentally get a DATA DELETE of a CELL from us and we want to retrieve that data, then we can easily fetch our DELETE DATA by doing this UNDO by going back a STEP.
So let us see how to do USE of UNDO.
To USE UNDO, we can CLICK on the UNDO option given in QUICK ACCESS TOOLBAR and USE it.
We can also USE UNDO by CLICK on the option of UNDO given in QUICK ACCESS TOOLBAR. And for this SHORT CUT KEY is CTRL + Z. By Pressing this, we can also USE UNDO OPTION.
By using REDO OPTION we can come one STEP from our UNDO done STEP. Going forward means that if by mistake we get PRESS of UNDO more often and our DATA is removed, then we can bring that DATA back using REDO.
So let us see how to do USE of REDO.
To USE REDO, we can CLICK on the REDO option given in QUICK ACCESS TOOLBAR and USE it.
We can also USE REDO by CLICK on the option of REDO given in QUICK ACCESS TOOLBAR. And for this SHORT CUT KEY is CTRL + Y. By PRESSing this, we can also USE the REDO OPTION.
Now we will go to EXCEL
01 – GOTO OPTION.
02 – GOTO SPECIAL.
01 – GOTO OPTION :-
In EXCEL we use GOTO OPTION to navigate to any CELL in EXCEL sheet. By USE of GOTO OPTION, we can easily go to any CELL in EXCEL with just one CLICK. There is only 3 STEPS for this.
STEP -1 # First of all we will CLICK on FIND & SELECT in EDITING BLOCK of HOME TAB.
STEP -2 # After that GOTO will CLICK on OPTION. (Or PRESS CTRL + G of SHORT CUT)
STEP -3 # After that GOTO OPTION comes in front of us, in this we will write the CELL in REFERENCE where we have to go.
For EXAMPLE we write H5 and CLICK on OK.
Our H5 CELL becomes SELECT as soon as CLICK on OK.
So in this way one can easily go to any CELL very quickly.
-: GOTO SPECIAL :-
By USE of GOTO SPECIAL, we can find out where in our EXCEL SHEET we have used FORMULA or FUNCTION. So let’s learn.
STEP -1 # First of all we will go to GOTO. Then click on the SPECIAL written below it.
STEP -2 # After that we will SELECT FORMULAS. And CLICK on OK.
STEP -3 # As soon as CLICK on OK, wherever FORMULA or FUNCTION is written in our SHEET, it becomes CELL SELECT or highlighted.
In this way, we can find out the USE of GOTO SPECIAL written as FORMULAS and FUNCTION.
-: GOTO SPECIAL :-
We see another USE of GOTO SPECIAL which will be very useful for you and after USE it, we can also save a lot of our time.
For EXAMPLE we have prepared a DATA and we have to do YES and NO FILL in that DATA and we have FILL YES in that DATA according to our own and now all we have to do is NO FILL.
One way is that we all go to BLANK CELL and do NO FILL, in which a lot of our time is spent. Second way we can fill the NO in that DATA by using USE of GOTO SPECIAL. Let’s see how.
STEP -1 # First of all we will SELECT all the CELLS in which we have to FILL NO.
STEP -2 # After that we will go to GOTO. Then click on the SPECIAL written below it.
STEP -3 # After that we will SELECT BLANKS. And CLICK on OK.
STEP -4 # After that we will do NO FILL OR CTRL + ENTER PRESS.
AUTOMATICALLY NO FILL becomes in all our BLANK CELLS as soon as ENTER PRESS. So in this way we do USE of GOTO SPECIAL.