Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel cell default vertical alignment

by Mach1.02 Feb 15, 2007 7:39AM PST

Create a new document with MS Excel and the default vertical alignment for each cell is "bottom".

To me this is illogical, and should be "top"; as soon as wrap is invoked I don't want leading white space above the shorter text elements, but because of bottom anchoring this is what happens.

Tools / Options / International tab has a left-right / right-left option presumably to cater for languages such as Arabic, but I can't find an option for what I want.

Does it exist please?
I'll even do a registry hack if I need to.

Grateful thanks.

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

Re: alignment

by Kees Bakker Feb 15, 2007 3:52PM PST

Mach,

I see the inconvenience. That's why Excel, like Word (normal.dot) has a default template. Just make that as you wish and you're done.

See: http://www.pcmag.com/article2/0,1895,1566043,00.asp

Hope this helps.

Kees

- Collapse -

Thank you!

by Mach1.02 Feb 15, 2007 9:25PM PST

Terrific!
As was clear, I had no idea, and this looks just the ticket.

My sincere thanks, Kees

- Collapse -

Excel help

by boriszex Feb 16, 2007 12:43AM PST

Well I think you don't need to do anything inside registry, you can find it in excel options, I hope that this link will help you there is few things about excel and I hope you can find you answer http://www.softwaretipspalace.com/MS_Excel_2003/Tips_And_Tricks.html

Back to Office & Productivity Software forum