Excel Question

Copper Contributor

How can I COPY from a spreadsheet and PASTE to a spreadsheet with hidden rows?


1 Reply



In Excel 365, you can copy from a spreadsheet and paste to a spreadsheet with hidden rows by following these steps:

  1. Select the cells you want to copy in the source spreadsheet.
  2. Press Ctrl + C (or Cmd + C on Mac) to copy the selected cells.
  3. Go to the destination spreadsheet where you want to paste the data, including hidden rows.
  4. In the destination spreadsheet, select the cell where you want to start pasting the data. You can select any cell in the target range or column.
  5. Press Ctrl + V (or Cmd + V on Mac) to paste the copied data.

The copied data will be pasted into the selected cell, and it should automatically fill in any hidden rows if they are part of the target range. Excel's paste operation typically respects the formatting and structure of the destination cells, including hidden rows, so you should see the data in the rows, whether they are hidden or not.

However, be aware that if you're copying and pasting large amounts of data, it might not fit within the visible area of the destination spreadsheet if there are many hidden rows. You may need to adjust your view or unhide rows to see the entire dataset.

To unhide rows in Excel, follow these steps:

  1. Select the rows above and below the hidden rows that you want to unhide.
  2. Right-click the selected rows.
  3. Choose "Unhide" from the context menu.

This will make the hidden rows visible and allow you to work with the pasted data more effectively.

The text and the steps was created with the help of AI.


My answers are voluntary and without guarantee!


Hope this will help you.


Was the answer useful? Mark as best response and like it!

This will help all forum participants.