ALT+H+FI+F (for excel 2013)
I think the above one is more easy then the one you suggested, i use yours
one but it does not work with my excel, yes the key ALT+E+I+S opens up the
SERIES dialogue box but then we have to work more so it takes a lot of time
and you know very well we use keyboard
First thing you need to know is there is no shortcut to click that Plus
button, The functionality which is used there is autofill, But you can use
this shortcut to do the auto fill ALT+E+I+S then ALT+F enter or Ctrl+D is
the best, Best functionality of + sign pressing it copies the data to
Suppose I want to copy it till 500,000 rows then how is it possible, if
there is possibility then first select the range (i.e. 500,000 rows) and
the press CTRL+D but i dont want to select the range, I just press the cona
of the cell so that it copies till A50, I think you understand my
CTRL+D
CTRL + R
to copy the formula below and to the right.
Regards,
Mandeep baluja
On Monday, November 23, 2015 at 9:32:12 AM UTC+5:30, GENIUS wrote:
>
> HI EVERYONE
> can we use any keyboard key for double clicking the plus sign for copying
> the formula below in the range or is