Search results

Is there a way to apply the PROPER Function (or any other Function) to the entire worksheet without having to copy and paste? Thanks, Katarina

I have a large spreadsheet: 30,000KB, but until recently, it was functioning well. Now, when I turn on the filter and try to change data by copying and pasting across the selection, it takes forever (30 minutes to change one cell across 1000 rows) I tried removing the pivot table, removing...

Thank you Kanti and Hui, I made my calculator completely interactive by adding a scroll bar to the result, but then linking that cell back to one of the variable scroll bars. It is super cool! Katarina

Thank you Hui, I have all the scroll bars and cell links set up, but how do I make it interactive so that I can toggle and it will update the other scroll bars? Don't I need a function like the =PMT((xxxxxxx))??? Katarina

I just followed the steps to create a mortgage calculator - Awesome, thank you so much! Now, I would like to create similar calculators with other functions, for example, 60/12=5 or 1000*80%*50%*(600/300)=800 How do I set up the formula, or where do I find help learning about how to do...