![]() ![]() You can copy the macro code from that page, or download the sample file that has test data, and all four of the Fill Blank Cells macros. There are slight differences among the macros, so read the notes to see which one might work best for you. There are four macros on the Fill Blank Cells page, on my Contextures site. If you frequently have to fill blank cells, you might like to use a macro, instead of doing all the steps manually. Right-click on the selected column, and click the Paste Values command.Next, select the entire column, and copy it.The formula has a relative reference, so it adjusts in each cell, to refer to the cell directly above it. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |