If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cannot copy and paste specific function
I am trying to copy a function from the formaula bar and
paste it to each row and will not work for me. Everytime I get something pasted it has added the row number, etc. If I ever get it copied I will then have to change the specific row numbers to have it work. Each row will have a different answer as the numbers will be different but the formula the same. If anyone can think of a better way please let me know. Maybe an array. Also, is there anyway once working that the formauls could be hidden but still work when it runs. Appreciate any help I can obtain. Thank you. Mary C. Lydon |
#2
|
|||
|
|||
cannot copy and paste specific function
using absolutes in the right place will make it happen.
=if(a1=$a$2,1,2) "Mary C. Lydon" wrote in message ... I am trying to copy a function from the formaula bar and paste it to each row and will not work for me. Everytime I get something pasted it has added the row number, etc. If I ever get it copied I will then have to change the specific row numbers to have it work. Each row will have a different answer as the numbers will be different but the formula the same. If anyone can think of a better way please let me know. Maybe an array. Also, is there anyway once working that the formauls could be hidden but still work when it runs. Appreciate any help I can obtain. Thank you. Mary C. Lydon |
#3
|
|||
|
|||
cannot copy and paste specific function
On the second part of your question:
Select the cells that contain the formulas that you wish to hide, Then, Format Cells Protection tab, Click on "Hidden", then OK. Now, you have to protect the sheet in order for this to take affect. If this protection inhibits some of the functionality of the sheet, you can unlock any affected cells beforehand, even the ones that contain the hidden formulas (means users can replace hidden formula with data entry). -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Don Guillett" wrote in message ... using absolutes in the right place will make it happen. =if(a1=$a$2,1,2) "Mary C. Lydon" wrote in message ... I am trying to copy a function from the formaula bar and paste it to each row and will not work for me. Everytime I get something pasted it has added the row number, etc. If I ever get it copied I will then have to change the specific row numbers to have it work. Each row will have a different answer as the numbers will be different but the formula the same. If anyone can think of a better way please let me know. Maybe an array. Also, is there anyway once working that the formauls could be hidden but still work when it runs. Appreciate any help I can obtain. Thank you. Mary C. Lydon |
Thread Tools | |
Display Modes | |
|
|