Excel 2007 Fast Locating Super long row data tips

What if a excel2007/2003 worksheet has 10000 rows and if the data in column 1th No. 8936 is to be modified? It takes a long time to drag the scroll bar with the mouse or the page key on the keyboard.

Reposition data in a cell in Excel 2007

Method 1: Press F5 to eject the "Locate" dialog box, as shown in Figure 1, enter the address in "reference location" and then do the following:

Figure 1 Excel Positioning dialog box

(1) To navigate to a cell, enter "C5883" (c for the column) at the reference location.

(2) to navigate to a row or rows, enter "5,883:5,883" or "5,883:5,888" at the reference location.

(3) to navigate to a rectangular area, you can enter "c5883:h5888" at "Reference location".

(4) To locate multiple cells that are not contiguous, enter "c5883,f5891,h6078" at the reference location.

Method 2: Enter the address in the Name box in the formula bar, and enter the same method as above.

Method 3: Hold down the SHIFT key, and then drag the scroll bar with the mouse to quickly navigate to the line where you want to modify the data

Classification:

• Excel Tutorials