Excel - Defining Text Alignment During Data Entry
Excel - Defining Text Alignment During Data Entry
(OP)
In 123 I was able to establish the alignment of my text during data entry by using ' ^ " for left, center, and right aligned text.
I've looked through Excel help and didn't see anything like this.
Does anybody know if this exists in Excel?
I've looked through Excel help and didn't see anything like this.
Does anybody know if this exists in Excel?





RE: Excel - Defining Text Alignment During Data Entry
1) to type in the codes as described then run a macro to check every cell, delete the code, and format it to suit.
2) assign a shortcut to the align button
Cheers
Greg Locock
RE: Excel - Defining Text Alignment During Data Entry
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Excel - Defining Text Alignment During Data Entry
Thank you Joerd and a star for you!
RE: Excel - Defining Text Alignment During Data Entry
RE: Excel - Defining Text Alignment During Data Entry
You'll have to split the text into multiple cells.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.