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 that has hidden rows and/or columns in it and select Visible Cells Only, you can use the following keystroke shortcut:
- First, highlight the data you want to copy.
- Then, press the "Alt" key, followed by ";" (semicolon). This will select only the visible cells in the data you've highlighted.
- After that, press "Ctrl" + "C" to copy the selected visible cells.
Please note that this shortcut works in Microsoft Excel.
Similar Questions
You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou can’t do this. You have to format each of the new cells individually.Cells must be formatted before data is entered into them.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You must copy the cells over the new cells, then type the data back in.You can use the Format Painter to copy only the formats from the old cells to the new cells.
If you hide columns and/or rows in a list and then copy/paste that list to another location, what happens?
You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou must copy the cells over the new cells, then type the data back in.Cells must be formatted before data is entered into them.You can use the Format Painter to copy only the formats from the old cells to the new cells.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You can’t do this. You have to format each of the new cells individually.
What happens when you press Ctrl + X after selecting some cells in Excel?The cell content of selected cells disappear from cell and stored in clipboardThe cells selected are marked for cuttingThe selected cells are deleted and the cells are shifted leftThe selected cells are deleted and cells are shifted up
From the following list of choices, select the choice that BEST describes the purpose of using the Paste Special feature in Excel.*It allows you to paste special characters, such as the trademark symbol, into a worksheet.It allows you to copy cells and then paste only selected elements into a new locationIt allows you to copy data from a Microsoft Word table and paste it into Excel 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.