| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
f4 to make constant
I am trying to do a spreadsheet and keep one cell as a constant number for my
formula. Where do I put my cursor to hit f4? Karen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
f4 to make constant
On or next to the cell reference
-- Kind regards, Niek Otten Microsoft MVP - Excel "xololady" wrote in message ... I am trying to do a spreadsheet and keep one cell as a constant number for my formula. Where do I put my cursor to hit f4? Karen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
f4 to make constant
Select that part of the address which you want to keep absolute and then
press F4 For example to get $A1 select A and press F4 to get A$1 select 1 and press F4 tp get $A$4 select A4... to get $A$1:$B$10 select A1:B10... Experiment and you will get the hang of it. Actually F4 cycles through all the combinations... so can keep pressing it and stop when you get what you want "xololady" wrote: I am trying to do a spreadsheet and keep one cell as a constant number for my formula. Where do I put my cursor to hit f4? Karen |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
f4 to make constant
hi,
When you enter the formula into the formula bar you may have something that looks like =if(a1 just after you enter the cell or range address tap F4 then and it will turn to absolute and you can carry on entering your formula -if($A$1 If you've entered it then in the formula bar select the cell/range to make absolute and then tap F4. Mike "xololady" wrote: I am trying to do a spreadsheet and keep one cell as a constant number for my formula. Where do I put my cursor to hit f4? Karen |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
f4 to make constant
Click on the cell containing the formula, then, in the *formula bar*,
select the cell that you wish to make absolute, then hit <F4. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "xololady" wrote in message ... I am trying to do a spreadsheet and keep one cell as a constant number for my formula. Where do I put my cursor to hit f4? Karen |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
f4 to make constant
Hi
Place the cursor in the formula cell at the cell reference which you want to toggle. Regards, Per On 16 Jan., 21:43, xololady wrote: I am trying to do a spreadsheet and keep one cell as a constant number for my formula. *Where do I put my cursor to hit f4? Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to make a result from an IF or SUM a constant? | Excel Discussion (Misc queries) | |||
| How do I make the 1st column constant in viewing a wide spreadshee | Excel Worksheet Functions | |||
| When I do an @sum, is there anyway to make the sum a constant ? | Excel Worksheet Functions | |||
| what symbol should i put in the formula to make a cell constant? | Excel Discussion (Misc queries) | |||
| Make one row a constant display? | Excel Discussion (Misc queries) | |||
Linear Mode
