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

quick switch between a

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Quick switch between A1 and R1C1 views in Excel

Quick switch between A1 and R1C1 views in Excel

ResolvedVersion 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:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.