Forum Discussion
Autofilling a formula in an excel spreadsheet
Hello All!! I need some help with a PTO spreadsheet. I have formula put into cell F42 to get the sum of two cells =SUM(F41,D42) Can someone please help me with using that blanket formula =SU...
or
- enter your formula in F42
- stay on F42, press and hold Shift
- scroll down till end of the range in column F, left click, release Shift
(other words select the range down starting from F42)
- Ctrl+D
