Hello, I need a keyboard shortcut. We put any formula in a cell and make a double click at the right bottom to effect this formula for the below cells. Is there any shortcut or macro to do that? I know it expected that it’s a matter of double click and I should not request about that but it will be really helpful if I found a shortcut or macro shortcut to do that. I have attached a sample for better understanding. Double Clieck Shortcut.jpg
You can create a macro that copy the formula to the other cells, but I dont understand why do you need that? If you explain a little bit your raison maybe I can help you to create the macro.
http://excelmooc.com
I dont see how having a macro to click on will be much quicker then the double-click...1 click for a macro button vs double-click on the "handle"??
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks