In this example, we've highlighted cells A1 to A8. The following example demonstrates how to copy and paste only nonblank cells.įirst, highlight all of the cells (including both blank and nonblank cells) that you wish to paste. Question: In Microsoft Excel 2011 for Mac, 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.Īnswer: Unfortunately, there isn't a simple solution to this question.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |