Posted by MO on February 02, 2001 3:55 PM
Hello, I have a fairly large spreadsheet with lots of formulas. The formulas are exactly the same for every so many rows. I just use fill down to copy to so many different rows. Obviously as the spreadsheet gets bigger it ends up being slower. Is there a way to input a formula just once to apply to so many rows, but display results in the relevant row, that will actually speed it up.
Also the workbook is shared, and everyone inputs data in it. The formulas sometime confuse people, Is there anyway to hide them, The usual method of protecting wont work, as it shared by many people who need to input it?
Thankyou in advance for your help.