All Questions
693
questions
3
votes
3
answers
56k
views
How to set Function "formula" for whole column in Excel 2007?
I want to set "Formula" to all cells in certain column whatever the number of rows was.
But i don't want to set this function to first cell "Header" of this column.
How do i make it ?.
- 1,905
5
votes
2
answers
4k
views
How can I create a reusable function in Excel 2007?
How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function:
=(((HOUR(...
- 6,444
2
votes
3
answers
611
views
How to update all functions in Excel 2007?
Is there a way to quickly fill down a column of functions. For example, if I change my function from
=3*B2
And then fill down so it does it for a lot of rows.
But then change this column to:
=10*...
- 1,560