Quick switch between A1 and R1C1 views in Excel

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Andrew has attended:
Excel Advanced course
Excel VBA course

by - delegate Andrew [2 posts] (2008 May 9 Fri, 16:47) Reply

Hi,
Is there a keyboard shortcut to quickly switch the column headings between A,B,C... and 1,2,3...?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Quick switch between A1 and R1C1 views in Excel

by - trainer Pete platinum contributer [571 posts] (2008 May 9 Fri, 23:17) Reply

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

· A Beginners Guide To Formulas In Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees
· Do You Really Need Excel VBA Training?

Please browse our web site to find out more about
vba-excel-training and other Microsoft training courses.

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Quick switch between A1 and R1C1 views in Excel

Related articles

Excel tip:

Calculate age or service