 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
=E2/C2
Or vice versa In a spreadsheet columns are designated by letters, rows by numbers. Easier to refer to them that way, so you would enter that formula in another columns in Row 2. If you copy the formula down a column it will adjust the row automatically. |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
I'm relative new to Excel having just used it as a lined sheet of paper for listing things. I'm trying to develop an Excel spreadsheet for tracking my car's mileage. Thus far I'm using a basic sheet with 4 columns - designated A=date, B=Miles travelled, C= Gallons used, and D= the computed MPG...
Can anyone help 1) how to transpose the data in rows into columns and columns into rows in a Excel spread sheet? 2) how to change the numerical order of data in rows/ columns in a Excel spread sheet? i.e.. from the first row to last row and last row to first row ? Thank "U'
I am used to doing this in Access but don't see how to do it in Excel. And, of course, nothing is easy to find any more in the 2007 version of the program. I want the a cell in a row to auto enter a value when people are doing simple data entry into a spreadsheet. I do not, of course, want...
I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143
View more questions Search
|
