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

Advanced Excel Crash Course Section 1: Ninja Shortcuts
1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€95.55
List Price:  €133.77
You save:  €38.22
£79.30
List Price:  £111.02
You save:  £31.72
CA$141.90
List Price:  CA$198.66
You save:  CA$56.76
A$157.20
List Price:  A$220.09
You save:  A$62.88
S$134.19
List Price:  S$187.87
You save:  S$53.68
HK$777.47
List Price:  HK$1,088.50
You save:  HK$311.02
CHF 90.03
List Price:  CHF 126.04
You save:  CHF 36.01
NOK kr1,113.09
List Price:  NOK kr1,558.38
You save:  NOK kr445.28
DKK kr712.70
List Price:  DKK kr997.81
You save:  DKK kr285.11
NZ$175.11
List Price:  NZ$245.17
You save:  NZ$70.05
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,166.46
List Price:  ৳17,033.53
You save:  ৳4,867.07
₹8,691.60
List Price:  ₹12,168.59
You save:  ₹3,476.99
RM444.50
List Price:  RM622.32
You save:  RM177.82
₦150,999.89
List Price:  ₦211,405.89
You save:  ₦60,406
₨27,959.15
List Price:  ₨39,143.93
You save:  ₨11,184.78
฿3,368.76
List Price:  ฿4,716.40
You save:  ฿1,347.64
₺3,627.05
List Price:  ₺5,078.02
You save:  ₺1,450.96
B$572.50
List Price:  B$801.52
You save:  B$229.02
R1,838.04
List Price:  R2,573.33
You save:  R735.29
Лв186.91
List Price:  Лв261.69
You save:  Лв74.77
₩144,050.71
List Price:  ₩201,676.76
You save:  ₩57,626.04
₪356.60
List Price:  ₪499.25
You save:  ₪142.65
₱5,816.56
List Price:  ₱8,143.42
You save:  ₱2,326.86
¥15,183.26
List Price:  ¥21,257.18
You save:  ¥6,073.91
MX$2,025.94
List Price:  MX$2,836.40
You save:  MX$810.45
QR365
List Price:  QR511.01
You save:  QR146.01
P1,382.22
List Price:  P1,935.16
You save:  P552.94
KSh12,923.70
List Price:  KSh18,093.70
You save:  KSh5,170
E£5,060.50
List Price:  E£7,084.90
You save:  E£2,024.40
ብር12,853.61
List Price:  ብር17,995.56
You save:  ብር5,141.95
Kz91,190.88
List Price:  Kz127,670.88
You save:  Kz36,480
CLP$94,785.52
List Price:  CLP$132,703.52
You save:  CLP$37,918
CN¥727.91
List Price:  CN¥1,019.11
You save:  CN¥291.19
RD$6,215.25
List Price:  RD$8,701.60
You save:  RD$2,486.34
DA13,481.55
List Price:  DA18,874.71
You save:  DA5,393.16
FJ$229.81
List Price:  FJ$321.75
You save:  FJ$91.93
Q772.59
List Price:  Q1,081.66
You save:  Q309.06
GY$20,950.95
List Price:  GY$29,332.18
You save:  GY$8,381.22
ISK kr14,017.59
List Price:  ISK kr19,625.19
You save:  ISK kr5,607.60
DH997.60
List Price:  DH1,396.68
You save:  DH399.08
L1,864.97
List Price:  L2,611.03
You save:  L746.06
ден5,879.23
List Price:  ден8,231.16
You save:  ден2,351.92
MOP$802.38
List Price:  MOP$1,123.37
You save:  MOP$320.98
N$1,845.90
List Price:  N$2,584.33
You save:  N$738.43
C$3,684.65
List Price:  C$5,158.65
You save:  C$1,474
रु13,912.57
List Price:  रु19,478.15
You save:  रु5,565.58
S/370.44
List Price:  S/518.64
You save:  S/148.19
K402.76
List Price:  K563.88
You save:  K161.12
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,816.41
List Price:  ZK3,943.09
You save:  ZK1,126.67
L475.58
List Price:  L665.83
You save:  L190.25
Kč2,396.16
List Price:  Kč3,354.72
You save:  Kč958.56
Ft38,385.49
List Price:  Ft53,741.23
You save:  Ft15,355.73
SEK kr1,071.44
List Price:  SEK kr1,500.06
You save:  SEK kr428.62
ARS$105,926.90
List Price:  ARS$148,301.90
You save:  ARS$42,375
Bs694.44
List Price:  Bs972.25
You save:  Bs277.80
COP$413,151.75
List Price:  COP$578,428.98
You save:  COP$165,277.22
₡50,717.92
List Price:  ₡71,007.11
You save:  ₡20,289.19
L2,552.87
List Price:  L3,574.13
You save:  L1,021.25
₲791,418.37
List Price:  ₲1,108,017.38
You save:  ₲316,599.01
$U4,324.45
List Price:  $U6,054.41
You save:  $U1,729.95
zł397.30
List Price:  zł556.24
You save:  zł158.93
Already have an account? Log In

Transcript

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

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.