Answer for:

Excel: How can you restrain text from flowing into adjacent blank cells?

Message 2 of 2

View entire thread
0 Votes
Darryl~ Moderator

--> right click the desired cell/row/column
--> select format cells
--> select the alignment tab
--> select the fill option in the dropdown list for horizontal

I don't have 2010 to try it on it but I suspect it works on it as well.

Edited to add.....
Granted this will fill the cell with whatever is entered in it (if you have 34 entered in the cell, it will fill the cell with 343434.... until the cell is filled) but the actual value of the cell remains what was entered in it (34) so it will work in formulas etc.

To just ceck for empty cells visually, just select the entire sheet....change the formatting....find the cells....then turn off the formatting.