tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Copy and paste only nonblank cells (condensing paste range) in Excel 2003/XP/2000/97

See solution in other versions of Excel:

Question: In Microsoft Excel 2003/XP/2000/97, how do I copy the entries of a series of cells and paste only non-blank cells? Paste special then skip blank option doesn't seem to work.

Answer: Unfortunately, there isn't a simple solution to this question. The following example demonstrates how to copy and paste only nonblank cells.

First, highlight all of the cells (including both blank and nonblank cells) that you wish to paste. In this example, we've highlighted cells C1 to C8.

Microsoft Excel

Under the Data menu, select Filter > AutoFilter.

Microsoft Excel

A drop-down should appear in the first cell of your range. Select NonBlanks from the drop-down.

Microsoft Excel

Your spreadsheet should now only display nonblank cells.

Next, copy the data using Ctrl-C.

Microsoft Excel

Then paste the data using Ctrl-V. In this example, we've chosen to paste the nonblank cells into Sheet2.

Microsoft Excel