In this Microsoft Excel tutorial, I will explain how to copy and paste or cut and paste visible cells, excluding hidden rows and columns. Download the featured file here.
METHOD 1:
- Select all your data: select one cell in your data and use the shortcut key CTRL A
- Then use the shortcut key CTRL G to open the Go To dialog box
- Click the Special button
- In the Go To Special dialog box select the Visible cells only option
- Click OK to confirm
- Use the shortcut key CTRL C to copy
- Select a cell where you want to paste the data
- Use the ENTER key to paste
METHOD 2:
- Select all your data: select one cell in your data and use the shortcut key CTRL A
- Use the shortcut key ALT ; to select visible cells only
- Use the shortcut key CTRL C to copy
- Select a cell where you want to paste the data
- Use the ENTER key to paste