login
Excel Question
-
No new posts
 2006-03-08 4:40 PM |
Master  1867     The real USC, in the ghetto of LA |  Subject: Excel QuestionOkay I need some help from all you Microsoft Excel Pros. I’m working on a large project and I am doing formulas. I was to make a formula and have a cell stay fixed, so when I copy the ratio it will maintain one of the variables (a set cell) how do I make excel do that. (I know it can be done, just not sure if it’s a # or a !! or something) |
| 2006-03-08 4:47 PM in reply to: #364537 |
Pro 5153 Helena, MT | Subject: RE: Excel Question Money, baby. $ |
| 2006-03-08 4:48 PM in reply to: #364537 |
| over a barrier | Subject: RE: Excel Question Dollar signs....$a$4 |
| 2006-03-08 4:48 PM in reply to: #364537 |
Champion 13323 | Subject: RE: Excel Question |
| 2006-03-08 4:48 PM in reply to: #364545 |
Master 1867 The real USC, in the ghetto of LA | Subject: RE: Excel Question |
| 2006-03-08 4:49 PM in reply to: #364537 |
Master 2314 Gulf Shores, AL | Subject: RE: Excel Question $ sign in front of the variable you want fixed put a dollar sign. If its just the column then $A, if you want both column and row its $A$1. |
| 2006-03-08 4:50 PM in reply to: #364537 |
Master 1867 The real USC, in the ghetto of LA | Subject: RE: Excel Question awesome you saved me lots of time on my accounting project!!!! |
| 2006-03-08 4:53 PM in reply to: #364552 |
Pro 5153 Helena, MT | Subject: RE: Excel Question Manatee Express - 2006-03-08 2:49 PM $ sign in front of the variable you want fixed put a dollar sign. If its just the column then $A, if you want both column and row its $A$1. What he said. |
| 2006-03-08 5:09 PM in reply to: #364553 |
Pro 4481 Reston | Subject: RE: Excel Question tyrant - 2006-03-08 5:50 PM awesome you saved me lots of time on my accounting project!!!!
too bad they can't help you cook. |
| 2006-03-08 7:02 PM in reply to: #364537 |
Extreme Veteran 474 Sydney | Subject: RE: Excel Question If you fit [F4] while editing the cell it will cycle through the $ options. If you have multiple cell references just highlight the one you want lock. Alternatively you could name the cell that you want to lock.... |
| 2006-03-08 7:05 PM in reply to: #364537 |
Master 1867 The real USC, in the ghetto of LA | Subject: RE: Excel Question |
| 2006-03-08 8:23 PM in reply to: #364537 |
| over a barrier | Subject: RE: Excel Question In the cell, hit "=" then go to the sheet and then highlight the cell you want to reference. |
|
|
|
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK