Excel for Mac: Does Not Copy Hidden Columns When Filtering
Question details
When copying data from a range with active row filters, Excel for Mac omits any hidden or empty columns during the paste operation.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Copying and pasting a range of data that contains both filtered rows and manually hidden columns.
- Observed behavior
- Excel automatically copies only the visible cells, leaving out the hidden columns entirely in the pasted result.
Please note that this is the expected and default behavior of Excel; it is designed to prioritize only visible data when row filters are actively applied.
Clear Filters or Unhide Columns Before Copying
Since Excel restricts copying to visible cells when rows are filtered, the most direct workaround is to modify your view by clearing filters or unhiding columns before copying the data.
Excel is programmed to only copy visible cells if a filter is currently applied to the rows in your selection. Consequently, any hidden columns within that area are completely ignored by the clipboard. To retain your hidden columns during a copy-paste action, you must adjust the active view first.
Navigate to the 'Data' tab on the Excel ribbon and click the 'Filter' button to toggle it off, or click 'Clear' to remove the active filter criteria.
If you wish to keep the row filters but need the hidden columns, select the visible columns on both sides of the hidden ones, right-click the column headers, and choose 'Unhide'.
Highlight your complete data range, press Cmd + C on your Mac keyboard to copy, navigate to your destination sheet, and press Cmd + V to paste the data intact.

Try WPS Office for Seamless Spreadsheet Management on Mac
If you are frustrated by strict behavioral limitations in Microsoft Excel for macOS, consider switching to WPS Office. It provides a lightweight, free, and highly compatible spreadsheet tool tailored for a smooth workflow.
- 1. Download WPS Office: Visit the official WPS Office website to download the free Mac version of the software suite.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks without losing any formatting.
- 3. Manage Data Easily: Enjoy smooth filtering, copying, and pasting experiences for your complex data handling needs.

Frequently Asked Questions
Why does Excel only copy visible cells when filtered?
When a filter is applied to rows, Excel assumes you only want to work with the data that meets your filter criteria. Therefore, it defaults to a 'visible cells only' copy mode to prevent accidentally copying filtered-out rows, which inadvertently also forces hidden columns to be skipped.
Can I force Excel for Mac to copy hidden columns while a row filter is active?
No, Excel does not provide a built-in toggle to bypass this when copying a filtered range. You must either unhide the columns before copying or clear the row filters to copy the entire dataset.
How do I ensure empty columns are copied when pasting?
If empty columns are manually hidden while a filter is active, they will be skipped during the copy command. Ensure the empty columns are unhidden and fully visible before you highlight the range and press Cmd+C.




