How to Select an Excel Range by Typing Cell Addresses with Go To in WPS Office Spreadsheets
Question details
The user wants to select a specific spreadsheet range, such as A1:F8, by entering its reference in the Go To dialog instead of selecting the cells manually.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Working in a spreadsheet workbook, the user needs to highlight a known range quickly and accurately for formatting, copying, or data entry.
- Observed behavior
- Manually dragging to select a large or specific range can be slow and error-prone; entering A1:F8 in the Go To dialog selects the exact range immediately.
Open the workbook in WPS Office Spreadsheets and identify the exact range reference you want to select, such as A1:F8. Make sure the worksheet is active before opening the Go To dialog.
Select a Range by Typing Cell Addresses in the Go To Dialog
Use this method when you know the exact range reference and want to select it quickly without dragging or scrolling.
Go To works in WPS Office Spreadsheets and follows the familiar Excel desktop workflow. Ctrl+G is the most reliable shortcut; F5 may also work on Windows and Mac desktop apps but is not guaranteed in web-based editors.
Click any cell in the worksheet, then press Ctrl+G on your keyboard. The Go To dialog box opens with a Reference field.
In the Reference box, type the target range, for example A1:F8. You can type the reference in uppercase or lowercase.
Press Enter or click OK. WPS Spreadsheets immediately selects all cells from A1 through F8.
Select a Range with the Name Box
Use this alternative when you prefer to enter the range reference from the worksheet toolbar instead of opening a dialog.
Select Ranges Faster with WPS Office Spreadsheets
Use WPS Spreadsheets to open Excel-compatible workbooks and select any range by typing a reference such as A1:F8 in the Go To dialog—free, familiar, and ready to use.
- 1. Download and install WPS Office: Go to the WPS Office site, download the free installer for your operating system, and complete the installation.
- 2. Open your Excel-compatible workbook: Launch WPS Office Spreadsheets and open the .xlsx, .xls, or .et workbook you want to edit.
- 3. Use Go To to select a range: Click any cell in the worksheet, press Ctrl+G, type the range such as A1:F8 in the Reference box, and press Enter.
- 4. Work with the selected range: The range is selected and ready for formatting, copying, filling, or editing in WPS Spreadsheets.
Frequently Asked Questions
Does WPS Office Spreadsheets have the same Go To dialog as Excel?
Yes. Open your workbook, click any cell, and press Ctrl+G. Enter the range reference in the Reference box and press Enter; WPS Spreadsheets selects the specified cells just like Excel desktop.
Can I use F5 instead of Ctrl+G in WPS Office Spreadsheets?
F5 may open Go To on Windows and Mac desktop apps, but it is not reliable in every version or in web-based editors. For consistency, use Ctrl+G when you need to select a range by typing cell addresses.
What range formats can I type in the Go To dialog?
You can type a rectangular range such as A1:F8, a single cell like C3, or defined names that exist in the workbook. Enter the reference in the Reference box and press Enter.
Why should I use Go To instead of dragging to select a large range?
Go To selects the exact range instantly, which avoids scrolling errors and accidental selections when you need to highlight hundreds or thousands of cells such as A1:F8.
