Forum Discussion
fill in the missing cells
Hello, is there a way to auto convert from Table1 to Table2 below? Table1 contain a sheet created for a tree map but I need to fill in the missing cells to produce the following CSV text format: ...
Sure.
- Select all cells (press control+home, followed by control+shift+End)
- Press F5, click Special
- Select "Blanks", click OK
- Press the = sign on your keyboard, press the arrow-up key just once
- hit control+Enter
- Select all cells again
- control+C
- press Control+alt+V (paste special), choose Values.
- Select all cells (press control+home, followed by control+shift+End)
- Press F5, click Special
- Select "Blanks", click OK
- Press the = sign on your keyboard, press the arrow-up key just once
- hit control+Enter
- Select all cells again
- control+C
- press Control+alt+V (paste special), choose Values.
Thanks Jan but it does not seem to work? I keep getting zeros "0" in the empty cells.
- Did you press the up arrow key immediately after pressing the equal sign, but before pressing control+enter?
Yes I did but still not working.
When I changed the cells format from General to Text, I get =B1 inside the empty cells.
