I am not sure that anyone used to call out the "Go To" dialog box and take advantage to operate job(s) in the Excel Spreadsheet or not. Because this function box is very good for some particular task such as to find all blank cells in the sheet or just seek the blank cells in the range selected.
However, Today I am here to tell you all about how to explore out the embedded "Go To" dialog box of Excel program. In Excel office program, if you have created a name of cells in worksheets for whatever propose.
Whenever you reach the cell name lists. Just simply do it by pressing shortcut below.
Method of shortcut key:
- Press "Ctrl" button and keep holding it.
- Press "G" button.
- Release both buttons.
Function
|
Result
|
---|---|
Ctrl + G
| To pop up the 'Go To' dialog box and display cell name lists. |
This task can be used "F5" alternatively too. It will produce the same result.
Hi, friends, before you leave this page. I only want to tell you to open your Excel program and try to press the shortcut buttons as I have shared to as above, "Ctrl" and "G". I believe that you will discover more how excellence Excel is!
Thanks for reading.
Bye,
Posted by: Michael Leng
I've known, then I've grown.
See more articles:
Comments
Post a Comment