Align cell contents on left side of sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to align all cells to the left side of the sheet. Example, some rows
have entries in the middle of the speedsheet with no enteries in the
beginning. I am sure it has to due with the formating, just don't know how
to do it. Any help would be greatly appreciated.
Thanks
 
Nothing to do with formatting.

If there is no value in a cell, that cell will be blank.

You could select all then F5>Special>Blanks>OK

Edit>Delete>Shift cells left.

But that could mess things up so do it on a copy of the original sheet.


Gord Dibben MS Excel MVP
 
Back
Top