default comment format: text alignment

**Nardar** · 12-27-2012, 01:15 PM

Hi,

Can I change the default comment text alignment to horizontal & vertical center alignment and keep the automatic size box checked? If so, how? If it needs a macro, please help because I don't know how to do them in Excel.

I'm using Excel 2010 on a Win7Pro x64 machine.

Thanks.

**Nardar** · 12-28-2012, 03:58 PM

Is this the right forum for this question, or should I re-post in a different one?

**Kevin UK** · 12-29-2012, 05:32 AM

Hi Nardar

Try alignment on the Home Tab.

**Nardar** · 12-29-2012, 11:42 AM

Will this make it a default setting in all comments? I don't want to have to change it every time.

**Kevin UK** · 12-29-2012, 11:45 AM

Thats the best i can come up with!

Maybe code, post in the vba forum, http://www.excelforum.com/excel-programming-vba-macros/

default comment format: text alignment

LinkBack

Thread Tools

Rate This Thread

Display

default comment format: text alignment

Re: default comment format: text alignment

Re: default comment format: text alignment

Re: default comment format: text alignment

Re: default comment format: text alignment

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions