| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet
In Excel 2007:
Click the Office button Excel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "SwatMan" wrote in message ... How does this work in Office 2007 which has no tools menu? "challa prabhu" wrote: Hi, Do the following: 1. On the Tools menu, click Options. 2. In the Options dialog box, click the General Tab 3. Click to slect the R1C1 Refernce Style check box 4. Click Ok to return to active worksheet. Now the column heading have changed to ABCDEFG and so on. Challa Prabhu "Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
