This does not work.Anybody know if there is an option in Excel preventing this from working, or if it is broken, etc.If you toggle a setting, you can use special characters when you enter the text.ToolsOptionstransition tabcheck Transition navigation keys asdf (will center asdf in the cell) asdf (will right justify asdf in the cell) Id uncheck that setting when I was done with the data entry.
It changes the behavior of other keys. ![]() I guess my main question is whether CtrlE works correctly for anybody else And if so, what am I doing incorrectly. You could, of course, create a short macro to center a cells contents and assign that macro to CTRLE. ![]() ![]() I am copying text from a website and pasting it into Excel and would like the formatting removed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |