ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel (https://www.excelbanter.com/new-users-excel/137932-excel.html)

allybell1980

Excel
 
I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...

The question is: "If you see a spreadsheet with row AND column headings as
NUMBERS, what is the problem (if any!!)?

Teethless mama

Excel
 
Tools Options General tab uncheck R1C1 reference style OK

"allybell1980" wrote:

I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...

The question is: "If you see a spreadsheet with row AND column headings as
NUMBERS, what is the problem (if any!!)?


T. Valko

Excel
 
That means that the file is setup to use R1C1 reference style.

Row1Column1

A1 would be R1C1

B3 would be R3C2

The setting for this is located in the menu at ToolOptionsGeneral
TabSettingsR1C1 reference style

Biff

"allybell1980" wrote in message
...
I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...

The question is: "If you see a spreadsheet with row AND column headings as
NUMBERS, what is the problem (if any!!)?




JLatham

Excel
 
As for the "what is the problem (if any)" portion - there's no real problem,
it is just a matter of the way that the workbook has been set up.

"allybell1980" wrote:

I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...

The question is: "If you see a spreadsheet with row AND column headings as
NUMBERS, what is the problem (if any!!)?



All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com