suppose u av to enter ...
- word "Alien" in 10 selected cells... or
- a formula as =A2*A3 in cell A4 then =B2*B3 in cell B4 and so on till cell E10
Shortcut method is as follows:
- Select the range where data is to be filled up
- Enter data or formula, in first cell (don't press enter)
- Hold down "Ctrl" key and Press "Enter"
In above case, If you have presses "Enter" instead of "Ctrl+Enter" then simply press followings:
- Ctrl+R to fill data from Ist cell to rightward over selection
- Ctrl+D to fill data from Ist cell to downward over selection
Be careful, "Ctrl+D/R" is applicable only if data is entered in first cell of selection whereas "Ctrl+Enter" is applicable in all cases.
0 comments:
Post a Comment