You can also fill, after you select the entire area, with ctrl+g, special, blanks, in first cell selected write = and click on cell above then CTRL+ENTER.
@123456789mumbai4 ай бұрын
This could have been done by pressing F5 or GoTo option (CTRL + G) select blank and fill the blank with above cell value
@kelvinalmarez549511 ай бұрын
Highlight the column then click merge cell
@exarkunn69 Жыл бұрын
More power query please!
@mohammadmoein962111 ай бұрын
How make a fair routine schedule for personal
@Politicallyhomeless18 Жыл бұрын
Could also enter a column to the left or right and do an "if is blank statement" and select the cell above it.
@PianoKwanMan11 ай бұрын
Can you do this, then revert back to the format of what it was? There's a macro running on a spreadsheet I fill in multiple times a day. It merges 'sheet 2' of every spreasheet in a folder into one. There's about 1000 spreadsheets in that folder and counting
@xN3K21 Жыл бұрын
love the office reference.
@spamjones308110 ай бұрын
How about if there’s an opposite scenario?
@timmayer8041 Жыл бұрын
= the cell above, Filter Blank, copy & paste the formulas, unfilter, copy & paste value
@icantdothisagain Жыл бұрын
That's the long way. Highlight, F5, select blank, ok, ....