![]() (In Excel 2007 click the Office button and then click Excel Options. To control the R1C1 setting, follow these steps: Some people prefer this method of cell reference, while it drives other people (like Jerry) crazy. It even has a name-R1C1 format, which means "row 1 column 1." It is a way of referring to rows and columns that is a "holdover" from older spreadsheet programs. ![]() The bothersome (to Jerry) way that he is seeing columns displayed is actually a feature in Excel. Instead he sees columns 1, 2, and 3.) Jerry wants to forbid this from ever happening and he has spent quite a bit of time trying to find someone who can tell him how to NEVER use that option nor have it available. (In other words, he doesn't see columns A, B, or C anymore. Some of Jerry's workbooks keep reverting to showing both columns and rows as numbers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |