 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Align 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 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 >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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.