How to fill formula in a selected range through keyboard keys in MS Excel / Shortcut to fill the formula without mouse in Excel / Auto Fill a formula by a single click in Excel.
In Microsoft Excel many times we enter a formula in a cell and then fill it till the end of the data or the range we required or want the formula to be filled, so what a person do to fill the formula in MS Excel or paste the excel formula in the desired cells?
To fill or paste the excel formula in a selected range of cells in Excel 2007 or in any Excel version, a person can simply copy the formula and paste in the desired cells. On the other hand, you can also double the lower right corner of the cell (the cell that contains the excel formula).
But here is a very simple and amazing trick to do all this by press two keys at once. To fill a formula follow the below steps:-
1) First select a range of cells in which you want to put / fill / enter the Excel formula.
2) Start typing the formula without doing anything, just enter the formula (the formula you will type, will be written in the upper first cell of your selection / range).
3) Now press CTRL+ENTER instead of Enter, and the excel formula you typed in very first cell of your selected range or selection fill automatically.
0 comments:
Post a Comment