Wheni drag a formula across it automatically changes the cells in the
formula. How can i copy the formula across if the cells to which they refer
are not next to each other? Help. Got a large spreadsheet to complete in 3
hours and it will take all night at this rate!