Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch column headers from numbers back to letters?
The column headers are displaying numbers (1,2,3) instead of letters (A,B,C),
which is making it difficult for me to type in formulas. Ultimately, I'd like to have a column at the right end of my spreadsheet that totals a specific set of columns *within each row*. How do I do this? I am using Excel that came with Microsoft Windows XP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch column headers from numbers back to letters?
Tools/Options/General, uncheck the R1C1 Reference Style checkbox.
In article , "Measurement Consultant" <Measurement wrote: The column headers are displaying numbers (1,2,3) instead of letters (A,B,C), which is making it difficult for me to type in formulas. Ultimately, I'd like to have a column at the right end of my spreadsheet that totals a specific set of columns *within each row*. How do I do this? I am using Excel that came with Microsoft Windows XP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch column headers from numbers back to letters?
1) Under Tools Options, select the Settings tab and uncheck the 'R1C1
reference style'. 2) In the first row where you want the totals, enter a formula, something like =a2+c2+e2 or =sum(a2:f2), whichever more easily specifies the columns you want added. Autofill that formula into subsequent rows. "Measurement Consultant" wrote: The column headers are displaying numbers (1,2,3) instead of letters (A,B,C), which is making it difficult for me to type in formulas. Ultimately, I'd like to have a column at the right end of my spreadsheet that totals a specific set of columns *within each row*. How do I do this? I am using Excel that came with Microsoft Windows XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
Trying to get a column of numbers to refer back | Excel Worksheet Functions | |||
row numbers & column letters | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
My column headers are numbers | Excel Discussion (Misc queries) |