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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering left & right aligned, & centred text, into one merged cel 2
Numbers left-aligned in a cell 4
Determining How An Existing Cell Is Formatted ? 4
Left Aligned page #s on Table of Contents 5
Cell Won't Accept Numerical Data 4
AORUS 15 – High Quality Design and Material of Thin Bezel Gaming Laptop Review 3
is there any option to my question 1
Right-hand alignment of numbers in table of contents? 3

Back
Top