Results 1 to 8 of 8
Thread: Excel Office 2007
-
17-06-2007, 04:23 PM #1
Excel Office 2007
In the older version of Excel, the rows allways were numbers and the colums were letters.
I must have pushed somewhere a button in Office 2007 because rows and colums are both numbers now.
How can I set this to the original settings?
It's better to keep your mouth shut and give the impression that you're stupid than to open it and remove all doubt.
-
17-06-2007, 05:17 PM #2
Re: Excel Office 2007
Peter,
I do not have this version yet. In the older version there is a list of optins you can change. What you have found must be new.
There may be something in the "Options" box, located under the "Tools" menu.
Or, you might try right clicking the column header and see if there are options that allow you to change the column header labels.If all else fails, ask for help.
-
17-06-2007, 05:38 PM #3
Re: Excel Office 2007
Try posting your question on here Peter.
http://www.mrexcel.com/board2/viewfo...db0fc0b448c0c5
-
17-06-2007, 05:45 PM #4
Re: Excel Office 2007
Thanks, I tried everything yet.
I made a screenshot with 10 and 20 in the first and section line and the sum in the 3th line.
So I just gave in in the 3th row: box 1 + box 2
The mouse is standing on the result in the 3th line (result= 30) and look once to the phormula in the upper box =R[-1]C+R[-2]C
I already found out what this mean but I'm not used to work this wayIt's better to keep your mouth shut and give the impression that you're stupid than to open it and remove all doubt.
-
17-06-2007, 07:21 PM #5
Re: Excel Office 2007
I found it Peter!!!
Go to "Tools", then select "Options". When the "Options" box appears go to the tab marked "General".
On this screen you will see some check boxes. Look for a check box named "R1C1 reference style". If that is checked, then click it to remove the check.
Then click the OK button and your page should go back to the normal column labels.
No charge for the service...If all else fails, ask for help.
-
17-06-2007, 10:03 PM #6
Re: Excel Office 2007
Thanks my friend but the solution with the R1C1 reference is not valid any longer for Office 2007, there's even no Tools Button in the new Excel.
Also the help function doesn't give me a solution, at least I don't find it.It's better to keep your mouth shut and give the impression that you're stupid than to open it and remove all doubt.
-
17-06-2007, 10:34 PM #7
Re: Excel Office 2007
I'm sorry. I guess never thought about that. Hopefully at least this points you to a possible solution.
PS. I did find this that might help.
http://safari.quepublishing.com/9780...6/ch06lev1sec2Last edited by US Iceman; 17-06-2007 at 10:38 PM. Reason: added PS
If all else fails, ask for help.
-
17-06-2007, 11:27 PM #8
Re: Excel Office 2007
@Peter, It is still there. Just in a different place.
Then go to "More commands"
Then click "Formulas"
Half way down you will see "R1C1 reference style"
Unclick the box and thats it.
ChillinIF AT FIRST YOU DON`T SUCCEED.
DESTROY ALL EVIDENCE THAT YOU TRIED!
and go get a cuppa
Similar Threads
-
Our office central AC cycles every 27 secs...
By Vincent9993 in forum Air ConditioningReplies: 6Last Post: 23-04-2007, 06:51 PM -
2007 China HVACR Exhibition
By Lc_shi in forum Chit Chat & Service StoriesReplies: 2Last Post: 20-03-2007, 02:36 AM -
Help with Microsoft Excel
By Coolie in forum Computers & the InternetReplies: 3Last Post: 18-05-2005, 10:46 PM -
Free Office Software
By frank in forum Computers & the InternetReplies: 0Last Post: 06-04-2005, 07:48 PM -
microsoft office xp
By dan wong in forum Computers & the InternetReplies: 0Last Post: 13-10-2002, 07:18 AM