Excel Shortcut for Multiple Fill

Have you ever felt the need to work on multiple cells simultaneously?

On my excel sheet, sometimes I need to implement the same formula on various cells. For this I have to put the formula in one cell, then copy them to the other cells. This is very time consuming.

For example in my road model, I have to implement the same formula over various financial years. For this I have to keep copying the same formula into every cell.

Is there any way to do this quicker and more effectively? Yes Use Multiple Fill!

I have a shortcut which implements the formula in every selected cell.That shortcut is the multiple fill shortcut. I can use the shortcut after selecting the cells to fill.

⌃ + Return is the shortcut for multiple fill.

Excel Multiple Fill

How is it useful to me ?

It saves me the time and energy of filling cells repeatedly!

I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to legal@edupristine.com and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 57183