Others

How to Select and Copy a Specific Range in Excel

WPS Content Manager Oct 1, 2026 869 views

Question details

The user needs to quickly select an exact, large range of cells (such as A1:O1919) in order to copy it, without manually selecting or dragging across the entire worksheet.

How to Select and Copy a Specific Range in Excel

Product: Excel
Device & OS: not provided
Scenario: Extracting or copying a specific block of data from a large spreadsheet that extends beyond the needed columns or rows.
Observed behavior: The user is looking for an efficient keyboard or dialog-based method to input exact cell references to highlight and copy a targeted dataset.

Before you start

Identify the exact starting and ending cell references (for example, A1 and O1919) for the data range you need to copy.

Solution 1Recommended

Use the Go To Dialog for Precise Selection

The quickest and most accurate way to select a large, specific range in Excel is by using the built-in Go To shortcut.

This method is highly recommended for large datasets where manual dragging is slow, error-prone, or tedious.

Open the Go To dialog

Press Ctrl+G (or F5) on your keyboard to instantly open the Go To dialog box.

Input your cell range

In the 'Reference' field at the bottom of the dialog box, type your exact cell range. For example, enter A1:O1919.

Confirm selection

Click the OK button. Excel will immediately highlight the exact block of cells you specified.

Copy and Paste

Press Ctrl+C to copy the selected range. Navigate to your desired destination (another sheet or workbook) and press Ctrl+V to paste the data.

Alternative Method: You can also type the exact range (e.g., A1:O1919) directly into the Name Box located to the left of the formula bar, and press Enter to select it.

Efficient Spreadsheet Management

Select and Copy Specific Ranges Seamlessly with WPS Office

WPS Office provides a highly intuitive and fully compatible spreadsheet tool that makes navigating massive datasets effortless. You can use the exact same shortcuts to handle your data efficiently.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your large dataset.
2. Access the Go To feature: Press Ctrl+G to bring up the Go To dialog window.
3. Input the range: Type your desired range (e.g., A1:O1919) into the Reference box and hit OK.
4. Copy the selection: Press Ctrl+C to copy your perfectly selected data block, ready to be pasted elsewhere.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Supports standard keyboard shortcuts like Ctrl+G for instant range selection.Lightweight application that handles millions of rows without lagging.Free and intuitive interface for seamless data management.

microsoft office alternative - wps office

Frequently Asked Questions

Can I select multiple non-adjacent specific ranges at once?

Yes. Open the Go To dialog (Ctrl+G) and type the ranges separated by a comma (for example, A1:B10, D1:E10) in the Reference box, then click OK.

Why is my Go To range selection not working?

Ensure you are using a valid range format with a colon separating the start and end cells (e.g., A1:C100). Also, check if your worksheet is protected, as cell selection may be restricted by the document owner.

How do I select from a specific cell to the very last row of data quickly?

Click on the starting cell, then hold down Ctrl + Shift and press the Down Arrow key. This shortcut selects everything from your active cell down to the last non-empty cell in that column.

Office Quick Solutions