is there a way to drag a formula without using the mouse? dragging over say 1000+ cells can be tedious. can it be made to 'drag' for a given number of cells, or to just go on indefinitely?
thanks in advance
is there a way to drag a formula without using the mouse? dragging over say 1000+ cells can be tedious. can it be made to 'drag' for a given number of cells, or to just go on indefinitely?
thanks in advance
Try this.
Say your formula in A1.
Select A1 > in the name box next to the formula bar Type A1:A100 (or your end range) > Edit > fill > Down
Or if you have data in Col A and Formula in Col b then double click the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
If you have data in the adjoining cells (say column A) and you are inputting your formula in column B, then a quick solution is to enter your data in B1, then double-click on the little black box in the lower right corner of the cell and it will auto-fill down in a nano-second!
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thank you both! i got it working
Using Office 2008 for MAC OS, NO VB SUGGESTIONS PLEASE, IT IS UNSUPPORTED!
We're both glad it worked for you - ah VBA?
When using the vlookup formula, if you drag the forumla across multiple columns and you want to change the column index number rather than have it remain the same, is there a way to do this without manually changing the number in all the cells?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks