0103 AutoFill Selected Cell(s) With Pre-defined Formula/Text/No.

1 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Welcome to the series of ninja shortcut keys. And let me continue the discussion. This time my eyes are on the shortcut key called Control Enter. Although we'll be talking about the applications of Control Enter as we proceed in our other video series and other application, right now, let me just give you a theoretical base work off Ctrl Enter. Well, if you're selecting a group of cells, either continuous or mi be scattered. And if you write anything, let's say okay, normally, when you press enter, what happens?

It only appears in one cell. Well, let me write okay again, and this time, let me not press enter, but instead of letting press Control Enter, so what Ctrl Enter does all the cells that has been selected and you initiate a particular formula or a text or a number, any data point, and then if you press Ctrl, enter, it replicates that same logical text or number or group of cells that you may have chosen. In fact, at times I use this then I want to initiate a particular word and put that across different shelves. So I Select those cells. And let's say I want to give a word less accepted. I type that word accepted.

Notice the selection is still on, and then I press Control Enter. There you go. That was Ctrl. Enter the applications of which we'll see more in detail as we proceed.

Sign Up