How to Jump to a Specific Column on the Same Row in WPS Office Spreadsheets
Question details
The user wants to move directly from one cell to another cell in the same row, such as from A66 to EB66, using the Go To command instead of scrolling.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Navigating a wide worksheet where the target cell is far to the right on the same row.
- Observed behavior
- The user needs to jump from A66 to EB66 while staying on row 66 without manually scrolling across columns.
Open the worksheet you want to navigate and confirm the exact target cell reference, such as EB66, so you do not land on the wrong cell.
Use the Go To Command to Jump to EB66
Best when you know the exact cell reference and want to move there quickly with a keyboard shortcut.
The Go To dialog selects the target cell and brings it into the visible area, so you do not have to scroll column by column on wide worksheets.
In WPS Office Spreadsheets, press F5 or Ctrl+G on your keyboard.
Click in the Reference box, type EB66, and make sure the row number remains 66.
Press Enter or click OK to jump to EB66 on the same row.
Jump to a Cell with the Name Box
Use this when you prefer working with the mouse and do not want to open a dialog box.
Jump to EB66 and Other Cells with WPS Office Spreadsheets
WPS Office Spreadsheets lets you use the Excel-compatible Go To shortcut, Name Box, or named ranges to quickly select a specific cell such as EB66 on the same row.
- 1. Open WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the target row.
- 2. Select the target worksheet: Click the worksheet tab where you want to jump to a specific column.
- 3. Open Go To: Press F5 or Ctrl+G to open the Go To dialog.
- 4. Enter the target cell: Type EB66 in the Reference box and press Enter.
- 5. Continue working on row 66: The active cell is now EB66, and you can edit, format, or review data in that column.
Frequently Asked Questions
What is the shortcut to open Go To in WPS Office Spreadsheets?
Press F5 or Ctrl+G in an open worksheet. The Go To dialog appears, and you can type a cell reference such as EB66.
Can I jump to a cell on the same row without using a keyboard shortcut?
Yes. Click the Name Box to the left of the formula bar, type the reference such as EB66, and press Enter.
Does the Go To command work with a list of cells?
Yes. In the Go To dialog Reference box, enter a comma-separated list such as EB66,EB70,AB66 and press Enter to select all listed cells.
Will WPS Office Spreadsheets open Excel workbooks and keep the same navigation behavior?
Yes. WPS Office Spreadsheets supports Excel shortcuts and .xlsx files, so you can use Go To, the Name Box, and named ranges in migrated workbooks.
