Hi,Hi,
You can also just Double left click on the cell handle (little square at bottom right corner of cell) of the Populated name (e.g. Mark), and it'll flash fill all the empty cells until there's another populated cell (e.g. John), as long as cells are filled on either side of the column. Repeat for John, etc.
The website use the same -->Home - Find & Select.......... I don't have "Find & Select" in my excelWelcome to the Board!
You can use the little trick described here to do that:
How to fill blank cells with value above / below / left / right in Excel?
ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.www.extendoffice.com
Try using the F5 shortcut.The website use the same -->Home - Find & Select.......... I don't have "Find & Select" in my excel