Select/copy/cut/paste/delete/etc cells inluding or excluding hidden?

[excelos]

Hello

When I select/copy/cut/paste/delete etc a cell range, I want to be able to choose to include or exclude hidden cells/rows/columns etc.

Is there any easy way for that? I.e. a switch key while doing the action or a different hotkey combo?

I know there is a specific button to include hidden cells but would be looking a more readily access not to have to add the button to the command bar?

Thanks!

 

[Alex Blakenburg]

To paste all cells in the selected range
• Ctrl+C
• Ctrl+V

To paste only visible cells in the selected range
• Alt+; (semi-colon) > selects only the visible cells in the selected range
• Ctrl+C
• Ctrl+V