98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Quick switch between A1 and R1C1 views in Excel | Excel forum
Quick switch between A1 and R1C1 views in Excel | Excel forum
Resolved · Low Priority · Version 2003
Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Quick switch between A1 and R1C1 views in Excel
Hi,
Is there a keyboard shortcut to quickly switch the column headings between A,B,C... and 1,2,3...?
RE: Quick switch between A1 and R1C1 views in Excel
Hi Andrew, Thank you for your post, welcome to the forum, in answer to your question there is a keyboard combination but whether it is a shortcut is another story; the combination is;
ALT+T O G Tab Space Bar Enter, only the Alt and T need to be pressed together then go through the sequence O, G, Tab, Space Bar, Enter - without any stops or pauses or commas. You will notice that these are just the keyboard commands for the individual items and they have been run together. Regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Manually wrapping textTo manually wrap text, use the shortcut key Alt+Enter. |