WPS Spreadsheets: Copy and Paste Data Between Sheets with Hidden Rows
Question details
The user needs to copy data between WPS Spreadsheets worksheets while understanding whether hidden rows are included and how to copy visible cells only.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A source or destination worksheet contains hidden rows, and the user wants to transfer either the complete selected range or only the rows currently visible.
- Observed behavior
- Copying a selected range can include hidden rows when they fall within that range. Using the visible-cells-only option limits the copied content to visible cells.
Check whether the source range contains hidden rows and decide whether those rows should be included. Open both worksheets and identify the destination cell before copying.
Copy the complete range, including hidden rows
Use this method when hidden rows are part of the data you want to transfer between worksheets.
In WPS Spreadsheets, open the source worksheet and drag across the cells you want to copy, including any hidden rows within the range.
Press Ctrl+C, or open the Home tab and select Copy.
Open the destination worksheet and click the top-left cell where the copied range should begin.
Press Ctrl+V, or select Paste on the Home tab. Hidden rows included in the selected range can also be pasted into the destination range.
Copy only visible cells from a range with hidden rows
Use this method when filtered or manually hidden rows must be excluded from the copied data.
Copy visible or complete worksheet data in WPS Spreadsheets
WPS Spreadsheets lets you transfer ranges between worksheets with standard copy-and-paste commands and use Go To Special to copy only visible cells when hidden rows should be excluded.
- 1. Select the source range: Open WPS Spreadsheets and select the cells you want to move between worksheets.
- 2. Choose the required cell selection: Use Home > Find & Select > Go To Special > Visible cells only when hidden rows should be excluded.
- 3. Copy the data: Press Ctrl+C or select Copy from the Home tab.
- 4. Paste into the other sheet: Open the destination worksheet, click the starting cell, and press Ctrl+V.
Frequently Asked Questions
Will WPS Spreadsheets copy hidden rows when I copy a selected range?
Yes. If hidden rows fall within the selected range, standard Ctrl+C and Ctrl+V can include their data in the copied range.
How can I copy only the rows that are visible?
Select the source range, open Home > Find & Select > Go To Special, choose Visible cells only, and click OK before copying and pasting.
Can I paste copied data into another worksheet?
Yes. After copying the source range, open the destination worksheet, select the top-left destination cell, and press Ctrl+V.
Does Visible cells only work with filtered rows?
Yes. It can exclude rows hidden by filters as well as rows hidden manually, provided you apply the option before copying.
What should I do if hidden rows must be included but are difficult to inspect?
Select the rows surrounding the hidden area, right-click the selection, and choose Unhide to display the rows before reviewing or copying the complete range.
