 |
 | 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 / General Excel Questions / May 2008autoshapes
Does the Flowchart "rectangle" function permit to vertically center align? If yes, how? Hi Rodster Yes it does? Select all the rectangles you want to align vertically, click on Draw|Align or Distribute|Align Center. To centre horizontally (who would ever want to do that) Click on Draw|Align or Distribute|Align Middle > Does the Flowchart "rectangle" function permit to vertically center align? > If yes, how? Thank you Kassie for your instructions. Howerver, I failed to specify in my original question that what I am unable to to do is vertically center text within the flowchart object and not the object themselves. I would be most apreciative if you or anybody can provide instructions to achieve this. > Hi Rodster > [quoted text clipped - 8 lines] > > Does the Flowchart "rectangle" function permit to vertically center align? > > If yes, how? Hi Rodster Draw the rectangle the size you want. With the rectangle still selected, click on the text box icon, click inside the rectangle and enter your text. Right click on the selection frame of the rectangle, click on Format autoshape, select the Alignment Tab, and set vertical alignment to center. You can also set horizontal alignment the same way, or do it while you are still in this window. > Thank you Kassie for your instructions. Howerver, I failed to specify in my > original question that what I am unable to to do is vertically center text [quoted text clipped - 15 lines] > > > Does the Flowchart "rectangle" function permit to vertically center align? > > > If yes, how? Hi, I'm having the same problem, but coding in VBA, and have done evething stated here to get text to center in the textframe of the shape. And, it works until I make the shape too small at which time the character's top are the only part visisble as the character disappers as the shape gets smaller. On another computer, at home, with Excell 2007 I don't get this problem, so I know it's not the size of the shape causing the character to disapper out the bottom (on one occasion it disappears out the top as it gets too small). My work computer has excell 2003 and seems to cause this problem. Any help would be appreciated. > Hi Rodster > [quoted text clipped - 24 lines] > > > > Does the Flowchart "rectangle" function permit to vertically center align? > > > > If yes, how? |
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.