Copy and Unhide Cells in Excel: Step-by-Step Guide

How-to basics · Updated November 20, 2026

To unhide and copy data in Excel for Microsoft 365 on Windows, select the rows or columns around the hidden area, choose Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns, then select and copy the cells you need. Excel hides entire rows or columns, not individual cells. If you want to copy only what is visible and leave hidden data out, select the range and use Home > Find & Select > Go To Special > Visible cells only before copying.

What You’ll Need

  • An Excel workbook with the data you want to reveal or copy. If you plan to make changes, save a copy first.
  • Permission to edit the worksheet. A protected sheet may prevent you from unhiding rows or columns.
  • A clear idea of whether you want all data in a selected range or only its visible cells. The two choices can produce different results.

Step-by-Step

  1. Identify what is hidden. Look at the row numbers and column letters around the area. If the labels jump—for example, row 8 is followed by row 12—rows 9 to 11 are likely hidden. A pair of small arrows or a plus/minus control may instead indicate grouped rows or columns. If row labels are present but some records are missing, a filter may be hiding them rather than a manual hide setting. Excel does not have a standard hide-cell command: hiding a row or column conceals every cell in it.
  2. Select the hidden rows or columns by selecting their neighbors. To reveal hidden rows, select the row headers immediately above and below the hidden section. For example, if rows 9 to 11 are hidden, select row headers 8 and 12 by dragging over them. To reveal hidden columns, select the column headers on both sides; if columns C and D are hidden, select B and E. You can drag across the header labels to include the full span. If hidden rows or columns are at the start or end of the sheet, select the whole worksheet using the Select All triangle at the top-left corner, where the row and column headings meet.
  3. Unhide the selected rows or columns. On the Home tab, select Format in the Cells group, point to Hide & Unhide, then choose Unhide Rows or Unhide Columns. The selected rows or columns should reappear. On Windows, Ctrl+Shift+9 unhides selected rows; Ctrl+Shift+0 unhides selected columns, although the column shortcut may be blocked by Windows settings. On Mac, shortcut behavior can vary with the keyboard and macOS settings, so the Home > Format menu is a dependable alternative. In Excel for the web, use the Home tab’s Format menu if available, or right-click the adjacent row or column headers and choose Unhide.
  4. Check for filters or grouping if the data is still missing. If a filter is active, select Data > Clear to remove filter criteria, or open the filter arrow on the relevant column and choose the values to display. Clearing filters changes which records are displayed; it does not remove the data. For grouped rows or columns, select the plus sign beside the outline to expand the group. A minus sign collapses it again. These controls are different from the Unhide command.
  5. Decide whether your copy should include hidden data. If you want the entire selected range, including manually hidden rows or columns, select the range normally by dragging across its cells or typing a range into the Name Box, such as A1:D20. Press Ctrl+C on Windows or Command+C on Mac. In general, a normal selection can include hidden cells within its boundaries. This is useful when you need a complete copy of a table, but it can also bring along records you cannot currently see.
  6. Choose visible cells only when hidden data must be excluded. Select the range you intend to copy. On Windows, press Ctrl+G, choose Special, select Visible cells only, and click OK. You can also use Home > Find & Select > Go To Special > Visible cells only. Press Ctrl+C, select the top-left cell of the destination, and press Ctrl+V. On Mac, use the Go To Special command if it is available in your Excel version; menu placement and shortcuts can differ, so use the menus rather than assuming a Windows shortcut works. For a filtered list, selecting visible cells only helps avoid copying filtered-out records.
  7. Paste into the right place and verify the result. Click the destination’s top-left cell, check that there is enough empty space, and paste. If you are copying a complete range, make sure the destination does not contain information you want to keep: a paste can overwrite it. Compare the first and last records and check the row count. If you copied visible cells from a selection with gaps, inspect the pasted layout carefully; noncontiguous selections may behave differently from a solid rectangular range. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the paste is not what you intended.

When your goal is both to reveal data and to make a clean copy, unhide first, review the full range, then copy. That sequence makes it easier to see exactly what will be included. If the original sheet needs to keep its hidden rows or columns, do not unhide them just to copy: instead, use Visible cells only when you want an output containing only what is currently displayed.

Common Mistakes

  • Selecting only the visible rows. Unhide works when the selection includes the hidden span and its adjacent row headers. If you select only row 8, Excel has no selected boundary on the other side of hidden rows 9 to 11. Select both surrounding headers, or select the whole sheet.
  • Assuming hidden means deleted. Hidden data remains in the workbook and may be included in a normal copy. If you are sharing a file or sending a pasted extract, check whether concealed records contain information that should not be shared. Hiding rows is not a security measure.
  • Confusing a filter with a manual hide. Unhide Rows will not restore records excluded by a filter. Clear or adjust the filter instead. Similarly, expand an outline group with its plus control rather than repeatedly trying to unhide its rows.
  • Copying a large selection without checking the destination. A pasted block may overwrite cells, formulas, or formatting. Choose a blank destination or paste into a new worksheet. If you only need values, use the Paste Special options rather than a standard paste, and confirm the result before saving.
  • Using the column-unhide shortcut when Windows intercepts it. Ctrl+Shift+0 may not work on some Windows setups because the operating system or keyboard configuration reserves the combination. Use Home > Format > Hide & Unhide > Unhide Columns instead.

Tips

  • Use the Name Box for a known range. The Name Box sits to the left of the formula bar. Type a range such as A1:D20 and press Enter to select it quickly. This can be more precise than dragging, especially in a long worksheet. Remember that selecting a range normally does not automatically restrict the selection to visible cells.
  • Inspect the full sheet before making a copy for someone else. Unhide rows and columns, clear filters if appropriate, and check for grouped sections. This helps you understand what the source contains. If the recipient should see only a subset, make a separate extract rather than relying on hidden data to stay out of view.
  • Use a new worksheet for a clean extract. Click the plus button beside the sheet tabs to add a sheet, then paste the copied data there. A new sheet makes it easier to compare the extract with its source and reduces the risk of overwriting existing cells.
  • Consider whether formatting should come across. A standard copy and paste can carry formulas, formatting, and other cell properties. If you need only the displayed results, use Paste Special > Values after copying. If you want the original appearance as well, use a standard paste and inspect the destination.
  • Keep a source copy before changing layout. Unhiding changes what is displayed, not the cell values, but clearing filters or rearranging data can affect your view. Saving a separate copy gives you a straightforward way to return to the original state.

Troubleshooting

  • The Unhide command does nothing. Confirm that you selected the row or column headers around the hidden area, not just cells elsewhere in the sheet. If the hidden area is at the top or left edge, select the entire sheet and try the command again. Also check for a filter, outline grouping, or worksheet protection. If the sheet is protected, ask the workbook owner for permission or the password; do not try to bypass protection.
  • The row or column is extremely narrow instead of hidden. Select the affected row or column header and choose Home > Format > Row Height or Column Width. Enter a suitable positive size. You can also use Home > Format > AutoFit Row Height or AutoFit Column Width. A tiny dimension can make data look hidden even though the row or column technically remains displayed.
  • Some records are missing after you unhide. Check the filter arrows in the header row and use Data > Clear, or inspect the relevant filter menu. Then look for outline controls along the sheet edge. If the rows are still absent, check whether the displayed data is in a table or whether another filter is active.
  • The paste includes records you did not expect. You probably copied a range normally, which can include manually hidden rows or columns. Undo the paste, select the source range again, choose Go To Special > Visible cells only, and copy once more. Before repeating the paste, verify the destination and the selection boundaries.
  • Visible cells only is unavailable or the paste is awkward. Menu availability can differ by platform and version. In desktop Excel, use Go To Special from the Home tab or the Go To dialog. If copying a disjoint selection creates an unexpected layout, try copying a single continuous visible block at a time, or paste into a blank worksheet and compare the result. Merged cells and complex filtered layouts can also make copying less predictable.

Frequently Asked Questions

Can I unhide one cell in Excel?
Not with the standard hide and unhide commands. Excel hides entire rows or columns. If a single value seems missing, check its row and column, font color, number format, conditional formatting, or whether the cell is blank.

Does copying a range include hidden rows?
A normal selection can include manually hidden rows or columns that fall within the selected range. Use Go To Special > Visible cells only first if you want to leave hidden cells out. Check the pasted result, especially when the source is filtered or has a complex layout.

How do I unhide every row or column?
Click the Select All triangle at the top-left of the worksheet, then choose Home > Format > Hide & Unhide > Unhide Rows. Repeat and choose Unhide Columns. This can reveal content you did not intend to display, so review the sheet before sharing it.

Why are some rows still missing after I choose Unhide Rows?
They may be filtered out or collapsed in an outline group rather than manually hidden. Clear the filter from the Data tab or expand the group with its plus sign. Also check whether the row height is set very small.

Can I copy hidden data without revealing it in the original sheet?
Yes. Select the intended range and copy it normally if the hidden cells should be included. To copy displayed cells only, use Visible cells only. You do not have to unhide the source to copy, but verify the paste so you know which records came across.

Do these steps work in Excel for Mac and Excel for the web?
The basic idea is the same, but shortcuts and some menu locations differ. On Mac, use the ribbon or menus if a Windows shortcut does not work. Excel for the web supports common row and column unhide actions, though some Go To Special options may vary; use desktop Excel if you cannot select visible cells only in the web app.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.