If you have a lot of data in an Excel spreadsheet, you may want to only copy the visible cells. This can be done with a simple shortcut. Here's how:
- First, select the cells that you want to copy. You can do this by clicking and dragging your mouse over the cells, or by using the arrow keys on your keyboard.
- Next, press Ctrl+Shift+* on your keyboard. This will select all of the cells in your selection, including hidden cells.
- Now, press Ctrl+C on your keyboard to copy the cells. You can then paste them into another spreadsheet or document.
That's all there is to it! This shortcut is a quick and easy way to copy only the visible cells in an Excel spreadsheet.