How to Display Selected Columns from One Sheet on Another in WPS Spreadsheets
Question details
The user needs to automatically show columns A:C and F:H from Sheet1 in a six-column layout on Sheet2 in WPS Spreadsheets, with Sheet2 updating whenever Sheet1 changes.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The source data is located in Sheet1, and the user wants a clean six-column view on Sheet2 without manually copying and updating the data.
- Observed behavior
- A six-column layout on Sheet2 must stay synchronized with edits made to columns A:C and F:H in Sheet1.
Open the workbook in WPS Office Spreadsheets and confirm that Sheet1 contains the source columns A through H and that Sheet2 is available as the destination sheet for the linked view.
Link Specific Cells from Sheet1 to Sheet2 with Formulas
Use this method when you need a simple row-by-row link that updates automatically and works in any WPS Spreadsheets version.
This creates direct cell references, so each Sheet2 cell points to a specific Sheet1 cell and refreshes whenever the source value changes.
Open the workbook in WPS Office Spreadsheets, click the Sheet2 tab, and select cell A1.
Type =Sheet1!A1 and press Enter. This displays the value from Sheet1 cell A1.
In Sheet2 cells B1, C1, D1, E1, and F1, enter =Sheet1!B1, =Sheet1!C1, =Sheet1!F1, =Sheet1!G1, and =Sheet1!H1 respectively.
Select A1:F1, drag the fill handle downward for the required number of rows, or copy the formulas to a range that matches your source data height.
Use CHOOSECOLS to Build a Dynamic Linked Range
Use this formula in modern WPS Spreadsheets or Microsoft Excel to return the chosen columns in a single dynamic array without filling formulas row by row.
Display Selected Columns from Another Sheet in WPS Spreadsheets
Link columns A:C and F:H from Sheet1 to Sheet2 with WPS Spreadsheets formulas. The referenced ranges update automatically, preserve workbook formatting, and keep your six-column layout in sync without manual copying.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the Excel workbook that contains Sheet1 and Sheet2.
- 2. Select the destination cell: Click the Sheet2 tab and select cell A1, or the first cell in the destination range.
- 3. Enter the linking formulas: Type =Sheet1!A1 in A1, =Sheet1!B1 in B1, =Sheet1!C1 in C1, =Sheet1!F1 in D1, =Sheet1!G1 in E1, and =Sheet1!H1 in F1; or use =CHOOSECOLS(Sheet1!A:H,1,2,3,6,7,8) if supported.
- 4. Fill down or confirm the spill range: Drag the fill handle down for the required rows, or confirm that the dynamic formula has spilled across the destination range.
- 5. Save the workbook: Press Ctrl+S to save the workbook so the linked layout and formulas are retained.
Frequently Asked Questions
How do I automatically update the second sheet when the first sheet changes?
Use direct formulas such as =Sheet1!A1 or the dynamic formula =CHOOSECOLS(Sheet1!A:H,1,2,3,6,7,8). WPS Spreadsheets recalculates these formulas when Sheet1 values are edited.
Why is CHOOSECOLS not working in my version of WPS Spreadsheets?
CHOOSECOLS requires a dynamic-array-capable version such as WPS Office 2021/365 or Microsoft 365. If your version does not support it, use individual cell references and fill them down.
How do I show non-adjacent columns in the same order as another sheet?
Use =CHOOSECOLS(Sheet1!A:H,1,2,3,6,7,8) to select columns A, B, C, F, G, and H. The returned order matches the column numbers listed in the formula.
Will the formulas still update after I close and reopen the workbook?
Yes, the cell links are saved as formulas, so WPS Spreadsheets recalculates them when the file is opened or when source data changes.
