When i have a column of data, say A1:A10 and i add a formaula to B!, I double click the bottom right hand corner to fill this down to B10, very useful.
I found myself working with a lot of horizontal info and was wondering if there was a quick way to do this too?