Sometimes in Excel you'll end up with data like this possibly exported from another system where you've got headings but blank cells below those headings so here we can see region and it's only listed once and then blank to the end of the region and the employees in each region so you might have one or multiple employees but again blank below those employee names this is fine for reading the list but if you want to work with the data perhaps filter it or sort things then you need to fill in these blanks cells and here's a quick way to do that first we'll select columns a and B where there are blanks then on the ribbons Home tab go to find and select go to special in the go to special window click blanks and then click OK all the blank cells are selected now and we're going to put in a very simple formula that just says get the value from the cell above so type an equal sign and then press the up arrow on your keyboard and you can see the formula here now has changed to a2 to fill that formula into all the selected cells press the control key and then tap enter so that puts that same formula into all the selected cells now we want to change these formulas to values so that we can move things around without having the values change so I'm going to select columns a and B where we filled the blanks and then point to the border of what is selected and you'll see a four-headed arrow there press the right button on the mouse and drag slightly to the right and then drag right back to where you started let go the...
Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 8854 Preceding
