Excel Tips, Tricks, and Shortcuts

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 th...