Excel shortcuts

How to Copy Only Visible Cells in Excel Shortcut

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:

  1. 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.
  2. Next, press Ctrl+Shift+* on your keyboard. This will select all of the cells in your selection, including hidden cells.
  3. 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.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.