how do I change cell labelling from R1C1 to A1?
My excell is now labelling rows and columns as numbers. Instead of having
letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
how do I change cell labelling from R1C1 to A1?
Click TOOLS/OPTIONS on the menu and select the GENERAL tab. Remove the check
mark from R1C1 REFERENCE STYLE the first check box on the left side of the tab page. -- Kevin Backmann "agua" wrote: My excell is now labelling rows and columns as numbers. Instead of having letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
how do I change cell labelling from R1C1 to A1?
Toolsoptionsgeneral and clear "R1C1 reference style"
-- Regards, Peo Sjoblom "agua" wrote in message ... My excell is now labelling rows and columns as numbers. Instead of having letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com