To copy highlighted data that has hidden rows and/or columns in it, press this keystroke shortcut to select Visible Cells Only.
Question
To copy highlighted data that has hidden rows and/or columns in it, press this keystroke shortcut to select Visible Cells Only.
Solution
To copy highlighted data while excluding any hidden rows or columns, you can use the following keystroke shortcut to select "Visible Cells Only":
- Select the Range: Click and drag to select the range of cells that includes hidden rows or columns.
- Keystroke Shortcut: Press
Alt + ;(hold down the Alt key and then press the semicolon key). This will select only the visible cells in your selected range. - Copy the Data: After that, you can copy the selected visible cells using
Ctrl + C. - Paste the Data: Move to the desired location and use
Ctrl + Vto paste the copied data.
This method ensures that only the cells that are visible are included in your selection, effectively ignoring any hidden rows or columns.
Similar Questions
If you hide columns and/or rows in a list and then copy/paste that list to another location, what happens?
If the active cell is in a Table, how do you quickly highlight the entire table?
Which key do you hold down when selecting cells that are in different areas of a worksheet?
In MS Excel, a __________ is a grid with labeled columns and rows.Dialog boxWorksheetClipboardToolbar
What is a good practice to follow if you use Find & Select command (on the Home tab) to highlight all formula cells in a worksheet?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.