How to find and go to a specific row number in Excel?

2
Please wait...

If you are working on a big worksheet you know the pain of navigating between large number of columns and rows. For example finding row 21454 and then moving back to 452 can take some time.

Let me show you how to easily navigate between rows in big spreadsheets by getting to know how to find and go to specific row or cell in Excel.

Excel offers two ways of doing so:

Name box

Name box is located on the Home tab on the left side of the formula input box.
  1. Click the Name box

    Excel Name Box
  2. Type in the cell address

    Excel Name Box
  3. Press Enter. Excel will navigate to the cell.

    Excel Name Box

“Go To” window

  1. To open Go To window use Ctrl + G (G like GoTo) or F5.

    You can also access it from ribbon from Home tab -> Find & Select group

    Opening "Go To" window in Excel

    or

    Opening "Go To" window in Excel
  2. In the Go To window type in the cell address like A3423 and click OK

    Opening "Go To" window in Excel
2 Comments
  1. Kanhaiyalal Newasakar says

    KANHAIYALAL NEWASKAR December 5, 2017. This is very useful information. Thank you very much.

  2. Jayasree says

    Thanks for article great info

Leave A Reply

Your email address will not be published.