Include hidden rows/columns in my copying and paste to Google Sheets?

[Ian Y]

When I select a range of rows/columns, copy, and paste to Google Sheets, the hidden rows/columns are not pasted. How to make that happen?

 

[6StringJazzer]

Is there any reason you cannot simply unhide them?

 

[Ian Y]

Is there any reason you cannot simply unhide them?

There are more than one hidden rows/columns, and the number of them can increase in the future. It's too inefficient to find each one of them to unhide/rehide every time I need to perform the same task.

That said, this issue is not urgent anymore because the problem I encountered has been solved through other means. We can set aside this issue for now.

 

[6StringJazzer]

Just FYI you don't have to find them. You click the upper-left box or CTRL+a to select the entire sheet, then Unhide rows and unhide columns. Copy, Paste to Google, then CTRL+z CTRL+z to rehide them. It could be automated in VBA to make it even faster.

 

[Ian Y]

Just FYI you don't have to find them. You click the upper-left box or CTRL+a to select the entire sheet, then Unhide rows and unhide columns. Copy, Paste to Google, then CTRL+z CTRL+z to rehide them. It could be automated in VBA to make it even faster.

That's convenient. Thanks for letting me know that. I'll definitely give it a try when I need the feature.