 |
 | 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 / Worksheet Functions / September 2008sloping top rows in Excel
How do I get the top row of cells to slope 45 degrees? Sat, 8 Mar 2008 03:16:00 -0800 from <=?Utf-8?B?cHJpbnRzIHBoaWw=?= <prints phil@discussions.microsoft.com>>: > How do I get the top row of cells to slope 45 degrees? Format | Cells | Alignment  SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... Just to add to Stans post, the gridlines will not slope when the text is set to45 deg but Borders will. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Sat, 8 Mar 2008 03:16:00 -0800 from <=?Utf-8?B?cHJpbnRzIHBoaWw=?= > <prints phil@discussions.microsoft.com>>: >> How do I get the top row of cells to slope 45 degrees? > > Format | Cells | Alignment To add to Stan's and Sandy's posts. Also helps visually if the cells are highlighted with a background color. Gord Dibben MS Excel MVP >Just to add to Stans post, the gridlines will not slope when the text is set >to45 deg but Borders will. I have tried to add borders just to text in 2007, but cannot ssem to do it. Can you please give more detail? > Just to add to Stans post, the gridlines will not slope when the text is set > to45 deg but Borders will. [quoted text clipped - 4 lines] > > > > Format | Cells | Alignment You cannot physically slant cells, but you can format them to look slanted. First, place a border around the cell and color it a nice color. Then Format>Cell>Alignment. Use the protractor to orient the text at 45 degrees or to your choice. Experiment with row height and column width.until you get the effect you want. Gord Dibben MS Excel MVP >I have tried to add borders just to text in 2007, but cannot ssem to do it. >Can you please give more detail? [quoted text clipped - 7 lines] >> > >> > Format | Cells | Alignment |
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.