Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel column problem
Name: bob56 Date: February 17, 2004 at 08:43:18 Pacific OS: win2k CPU/Ram: pentiv
Comment:
in excel2000 my colume headings have numbers as well as my row headings. My cell refs are coming out as 1,1 etc instead of a1 Does anyone know how to revert back to letters for the columes and numbers for the rows.
Name: Report_2 Date: February 17, 2004 at 10:30:52 Pacific
Reply:
Not sure if this will do it but go to Excel Tools, Options, General tab and remove the check next to R1C1 Reference style. Click Ok. (I am on Excel 97)
HTH Bryan
0
Response Number 2
Name: bob56 Date: February 18, 2004 at 01:04:22 Pacific
Summary: Some options in my insert cell menu have mysteriously disappeared! If I choose several cells in Excel 2000 then right click and choose insert, a box pops up with insert column and insert row as option...
Summary: I have a problem calculating time in Excel. For example, in column A the time is 30:20(30 hours and 20 minutes), how can I turn the minutes into hours in Column B and get the answer of 30.33. If the h...
Summary: I would like to print a column from an Excel spread sheet, which contains written responses to a particular question in a survey. The problem is, each reply is shown in one long continoues line, and s...
0 
