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

excel 2003 visual basic intermediate course - why does my worksheet

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Why does my worksheet show =SUM(R[-2]C:R[-1]C)?

excel 2003 visual basic intermediate course - Why does my worksheet show =SUM(R[-2]C:R[-1]C)?

ResolvedVersion Standard
Edited on Tue 4 Dec 2007, 10:28

Why does my worksheet show =SUM(R[-2]C:R[-1]C)?

Why does my worksheet show =SUM(R[-2]C:R[-1]C) in the formula? and why does my worksheet column headings display 1 2 3 instead of A B C etc., ?

RE: Why does my worksheet show =SUM(R[-2]C:R[-1]C)?

The reason why you have this result =SUM(R[-2]C:R[-1]C) showing in your formula and your column headings are displaying 1 2 3 instead of A B C etc., is because your settings have been changed in Tools, Options.

To reset so that your formula reads as =SUM(A1:A2) and your column headings display A B C;

Select Tools, Options,
General Tab,
under Settings uncheck the box R1C1 Reference style.
Click OK
Your worksheet should be back to normal settings.

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

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.1 secs.