I'm using excel 2011 on a Mac Air running Yosemite
I would like to have a column of numbers in no particular order with various blank cells in the column. Blanks may be 1 space or 5 spaces etc. I want to highlight the entire column and fill in all the missing numbers in between the numbers already in place (without changing those numbers). It is like using the FILL tool but highlight the entire column. On a windows computer running excel i used an addin called Kutools which did exactly that but i can't find Kutools for Mac. Not sure if it's a formula or VBA that i need. Any Help is Appreciated, Thanks,Jim
Bookmarks