I have the latest version of Excel 2011 and I was wondering how to make it so the text doesn't spill over into the next empty cell.
I searched the question and some people recommend going to Format -> Cells -> Alignment and choosing "Fill," but if I type a single character in a cell, that formatting option fills the entire cell with that character repeatedly.
Is there a way to achieve this without having to manipulate the next cell with a whitespace?
I searched the question and some people recommend going to Format -> Cells -> Alignment and choosing "Fill," but if I type a single character in a cell, that formatting option fills the entire cell with that character repeatedly.
Is there a way to achieve this without having to manipulate the next cell with a whitespace?