quick switch between a

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips


Server loaded in 0.07 secs.