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