| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Align cell contents on left side of sheet?
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Align cell contents on left side of sheet?
Nothing to do with formatting.
If there is no value in a cell, that cell will be blank. You could select all then F5SpecialBlanksOK EditDeleteShift cells left. But that could mess things up so do it on a copy of the original sheet. Gord Dibben MS Excel MVP On Mon, 6 Aug 2007 10:16:02 -0700, wannabe68 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add "left align across selection" cell formatting | Excel Worksheet Functions | |||
| rows are on the left side of the sheet, I need to move them to th. | Excel Discussion (Misc queries) | |||
| ADDING WORDS TO THE LEFT SIDE OF AN EXCEL SHEET | Excel Discussion (Misc queries) | |||
| tiny gray squares on left side of sheet on start up printing | Excel Discussion (Misc queries) | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
