How to Copy in Excel While Skipping Blank Cells Safely

How-to basics · Updated November 20, 2026

To copy cells in Excel without replacing existing destination values with blanks, copy the source range, select the destination’s top-left cell, and choose Home > Paste > Paste Special. Turn on Skip blanks, then select OK. If you mean skipping hidden or filtered rows, select the range and use Go To Special > Visible cells only before copying. The right method depends on which cells you want Excel to skip.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the source and destination ranges in a workbook you can edit.
  • A clear idea of what should be skipped: blank source cells, hidden or filtered cells, or gaps between pasted values. These are different tasks and use different steps.
  • If the data matters, a saved copy of the workbook or an undo-ready working copy. Pasting can replace values, formulas, and formatting, depending on the paste options you choose.

Step-by-Step

  1. Choose the skip method that matches your goal. Use Paste Special with Skip blanks when blank cells in the copied range should leave existing destination cells unchanged. Use Visible cells only when you want to copy a range while excluding rows or columns hidden manually or by a filter. To create empty gaps between copied values, arrange blank cells in the source pattern and use Skip blanks. Excel does not have one general copy command that automatically skips every kind of cell.

  2. Copy data while leaving destination cells unchanged where the source is blank. Select the full source range, including its blank cells, and press Ctrl+C. Click the destination cell at the top-left of the area where the copied range should begin. On the ribbon, choose Home > Paste > Paste Special. In the Paste Special dialog, check Skip blanks and click OK. Nonblank source cells are pasted into their matching positions; blank source cells do not clear the corresponding destination cells.

    For example, suppose the source has a value in A1, a blank in A2, and a value in A3. If you copy A1:A3 to a destination starting at D1 with Skip blanks on, the values go to D1 and D3. Whatever was already in D2 remains there. This is useful for updating only the filled parts of a template, but it does not compact values upward or close gaps.

  3. Select paste options to protect formatting when needed. The Paste Special dialog may paste more than values. If the destination has formatting you want to keep, choose Values in the dialog’s Paste options, keep Skip blanks checked, and select OK. This pastes the source contents as values rather than bringing across the source formatting or formulas. If you need formulas, choose Formulas instead. Check the dialog before confirming because choosing All can transfer formatting as well as cell contents.

  4. Copy only visible cells from a filtered or hidden range. Select the range you want to copy, including the rows that are currently hidden or filtered out. On Windows, press Alt+; (Alt plus semicolon) to restrict the selection to visible cells only. Alternatively, use Home > Find & Select > Go To Special, choose Visible cells only, and select OK. Then press Ctrl+C, click the destination’s top-left cell, and press Ctrl+V.

    This is particularly useful with a filtered table: it prevents excluded rows from being included in the copied selection. Check the pasted result before relying on it, especially if the destination is also filtered or contains hidden rows. Copying visible cells does not necessarily create the same layout as copying an uninterrupted rectangle; separated visible areas can affect how the paste is arranged.

  5. Use the ribbon route on a Mac or when a shortcut is unavailable. In Excel for Mac, select the range, then use Home > Find & Select > Go To Special and choose Visible cells only if that command is available in your Excel build. Keyboard shortcuts can differ by keyboard layout and version, so use the dialog rather than assuming the Windows Alt+; shortcut applies. On Excel for the web, some desktop selection tools and Paste Special options may be unavailable or behave differently; open the workbook in the desktop app for the full set of steps.

  6. Make deliberate gaps in a destination. If you want values to appear with blank rows or columns between them, first make a source range with the same layout. For instance, place the first value in the first source row, leave the next row empty, and place the second value in the third row. Copy the entire range and paste it over the destination with Skip blanks checked. The blank positions will not overwrite destination cells, so this works best when those destination positions are already empty. If they contain old data, clear those cells first if the intended result is truly blank.

  7. Confirm the result before continuing. Compare the source and destination, including a few cells that should have been skipped. Check whether formulas, values, number formats, and hidden rows behaved as intended. If the result is wrong, press Ctrl+Z on Windows or Command+Z on Mac right away, then repeat the paste with the correct selection and options. Avoid making additional edits before undoing, because that can make it harder to return to the prior state.

Common Mistakes

  • Confusing blanks with hidden cells. Skip blanks only affects blank cells in the copied range. It does not filter out hidden rows. Use Visible cells only for hidden or filtered cells.
  • Expecting Skip blanks to erase gaps. The option means blank source cells leave matching destination cells alone. It does not remove rows, shift later values upward, or make a destination cell blank.
  • Choosing the wrong Paste Special setting. All can bring source formatting and other cell properties along. If you only need the displayed values, select Values; for formulas, use Formulas.
  • Copying just the filled cells when spacing matters. If you select only nonblank cells, Excel may not preserve the original gaps. Select the full rectangular range when the position of blank cells is part of the intended layout.
  • Overlooking merged cells or mismatched range sizes. A destination with merged cells, or a paste area that does not fit the copied layout, can block or distort a paste. Unmerge or resize the destination where appropriate before copying.
  • Assuming nonadjacent selections paste like one rectangle. Ctrl-clicking separate areas can be useful for selecting cells, but Excel may not paste multiple separate selections into a single continuous destination as expected. Use a helper range with the intended layout instead.

Tips

  • Test a few cells in a spare area first if the workbook contains important formulas or formatting. This makes it easier to confirm what Skip blanks and the chosen Paste option will do.
  • Use a destination range of the same dimensions as the source when possible. The matching positions make it easier to predict which destination cells will be changed and which will remain untouched.
  • For filtered lists, verify that the filter is set correctly before selecting visible cells. The visible-only selection follows the current view, so an unintended filter can omit records you meant to copy.
  • When copying values into a formatted report, choose Values in Paste Special rather than relying on a normal paste. This helps retain the destination’s existing number formats, borders, and colors.
  • If a copied selection is outlined with moving dashed lines, it is still in copy mode. Press Esc when finished to clear the outline; doing so does not undo the paste.
  • Keep the source range intact until you have checked the output. If a mistake happens, undo promptly rather than trying to repair many individual cells.

Troubleshooting

Blank source cells still cleared destination cells: Undo the paste, copy the source range again, and reopen Home > Paste > Paste Special. Confirm Skip blanks is checked before clicking OK. If you used a normal Ctrl+V paste, the blank cells may have replaced destination contents.

Hidden rows appeared in the copied data: Undo, select the original range again, and apply Visible cells only before copying. On Windows, Alt+; is the shortcut; the Go To Special dialog is another route. Make sure you select the whole intended range before applying the command.

The paste is shifted or values landed in unexpected places: Check the top-left destination cell, source dimensions, merged cells, and active filters. Undo and try the operation in an unfiltered, unmerged test area. When copying separated visible areas, inspect the layout carefully rather than assuming Excel will pack or preserve the cells in a particular way.

Paste Special or Visible cells only is missing: Confirm that you are using the desktop version of Excel for Microsoft 365 and that the copied range is still on the clipboard. Excel for the web and some Mac builds have different menus or limitations. Use the available Go To Special dialog or open the workbook in Excel for Windows if the exact option is not offered.

Formulas or formatting changed unexpectedly: Undo, then repeat Paste Special and choose Values, Formulas, or the needed option explicitly. Skip blanks controls whether blank source cells overwrite destination cells; it does not by itself limit the type of content pasted.

Frequently Asked Questions

Does Skip blanks ignore blank cells in the copied range?
Yes. It leaves the corresponding destination cells unchanged. It does not remove empty rows or shift the nonblank cells together.

Can I copy only visible cells in Excel?
Yes. Select the range and choose Home > Find & Select > Go To Special > Visible cells only, or use Alt+; on Windows. Then copy and paste.

How do I paste values without overwriting the destination format?
Copy the source, open Paste Special, choose Values, and confirm. Add Skip blanks if blank source cells should also leave destination cells unchanged.

Can I skip every other row while copying?
Arrange the source values and blank rows in the pattern you want, then paste with Skip blanks into a destination where the gap cells are empty. Blank source cells will not clear any old destination content.

Can I copy nonadjacent cells into one continuous column?
Excel may not paste separate selections into a continuous range in the way you expect. Put the desired cells into a helper range in the right order, then copy that continuous range.

Will these steps work in Excel for the web?
Some copy and paste actions work, but desktop-only selection tools and dialog options may differ. For visible-only selection or the full Paste Special controls, use Excel for Microsoft 365 on Windows when available.

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.