I want to get the result when I enter a num, for example the formula is multiply 2 and plus 1.
So when I type in '10' in a cell and press enter I will get the result '21'(10 * 2 + 1) immediately. I know there is a way using mouse drag to get this done, but I prefer to use command or sth else instead of mouse?
Is there a alternative ?
By the way my excel version is 2016.
I don't exactly know what you mean, I understand that you want to drag a formula to neighbour cells using something different than mouse. I personaly use this method:
1. I am writing a formula in, for example A1.
2. Next I am using combination of Shift+arrows to select a range I am interested in (for example A1:A5).
3. I use Ctrl + D to fill up empty cells in range with formula in A1 cell (or Ctrl + R if I want to fill horizontal range like A1:C1).
Hope that is what you looking for
Liked my solution? Please, click "Add Reputation".
excellent idea, I just find a way to make it by using VBA, which is a very powerful, tool , this is the vba code implement my goal, hope this will help you too
Please Login or Register to view this content.
Thanks a lot, I will definitely try it
If you are satisfied with solution, mark this topic as solved
And If you like my response, click Add Reputation button below my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks