Safequip Member May 15, 2013 #1 hi how do I get my formula to the bottom of a spread sheet without having to drag it for ages. Thanks
hi how do I get my formula to the bottom of a spread sheet without having to drag it for ages. Thanks
bobhc Excel Ninja May 15, 2013 #2 Good day Safequip If you have no empty call in the left hand column that holds the data just double click on the right hand corner of the cell holding the formula and in will auto fill down but will stop at the first empty cell to the left
Good day Safequip If you have no empty call in the left hand column that holds the data just double click on the right hand corner of the cell holding the formula and in will auto fill down but will stop at the first empty cell to the left
SirJB7 Excel Rōnin May 15, 2013 #3 Hi, Safequip! You could too use Ctrl-End / Ctr-Home to go downwards and upwards, or Ctrl-DownArrow / Ctr-UpArrow to do the same keeping column. Regards!
Hi, Safequip! You could too use Ctrl-End / Ctr-Home to go downwards and upwards, or Ctrl-DownArrow / Ctr-UpArrow to do the same keeping column. Regards!
