How to Keep an Excel Linked Picture Visible When Source Columns Are Hidden in WPS Office
Question details
The user needs to keep a linked picture in an Excel worksheet visible after hiding the source columns that the picture references.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a linked picture that displays cells from a worksheet column and wants to hide the source column for a cleaner layout without making the picture disappear.
- Observed behavior
- The linked picture disappears because hidden source columns are not rendered in the linked picture.
Open the workbook in WPS Office and identify the linked picture plus the source column it references. Confirm whether the picture must remain dynamically linked or can be replaced with a static copy.
Narrow the Source Column Instead of Hiding It
Use this method when you need to keep the linked picture fully dynamic and the source column visually hidden.
Linked pictures do not render cells from hidden columns, but a column with a very small width remains technically visible. This keeps the link active while making the column almost invisible.
Click the column header of the source column to select the entire column in the WPS Office spreadsheet.
Right-click the selected column header and choose Column Width from the context menu.
Enter a small value such as 0.1 or 0.2 in the Column width box and click OK.
Confirm that the source column is now visually narrow and the linked picture still displays and updates normally.
Move Source Data to a Separate Worksheet and Hide That Sheet
Use this method if you do not want to leave a nearly invisible column in the visible sheet and need the source data out of sight.
Create a Static Picture of the Source Range
Use this method when the source range no longer needs to update automatically and you only need a stable picture.
Keep Excel Linked Pictures Visible in WPS Office Spreadsheets
WPS Office Spreadsheets lets you open Excel workbooks and adjust source columns with a tiny width so your linked picture remains live while the source column is effectively hidden. You can keep the same .xlsx formatting and linked-picture behavior without subscription barriers.
- 1. Open your workbook: Open your Excel workbook in WPS Office Spreadsheets.
- 2. Select the source column: Select the source column header and right-click the column.
- 3. Choose Column Width: Choose Column Width from the context menu.
- 4. Set a small width: Set a small column width, such as 0.1, and click OK.
- 5. Verify the linked picture: Check that the linked picture remains visible and updates after data changes.
Frequently Asked Questions
Why does an Excel linked picture disappear when I hide the column it references?
A linked picture displays the source cells as they appear in the worksheet. Since hidden columns are not rendered, the picture loses the visible source content. Narrowing the column or moving the data to a hidden sheet are common workarounds.
Can I hide the source cells by grouping instead of hiding the column?
Grouping can collapse a column, but collapsed grouped columns are treated as hidden in many spreadsheet versions, so the linked picture may still disappear. A very narrow column is more reliable for keeping the picture visible.
Does a linked picture update when I change the source cells in WPS Office?
Yes, a true linked picture updates when the visible source cells change. If you paste a static picture instead, it will not update.
Will moving the source data to another worksheet break the linked picture?
It can break the reference if the picture still points to the old location. After moving the data, select the picture, update its reference to the new worksheet range, and press Enter to restore the link.
