0107 Formatting Cells

Advanced Excel Crash Course Section 1: Ninja Shortcuts
4 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
€91.73
List Price:  €128.43
You save:  €36.69
£78.50
List Price:  £109.90
You save:  £31.40
CA$135.42
List Price:  CA$189.60
You save:  CA$54.17
A$152.22
List Price:  A$213.12
You save:  A$60.89
S$133.77
List Price:  S$187.28
You save:  S$53.51
HK$781.89
List Price:  HK$1,094.68
You save:  HK$312.79
CHF 88.30
List Price:  CHF 123.63
You save:  CHF 35.32
NOK kr1,058
List Price:  NOK kr1,481.24
You save:  NOK kr423.24
DKK kr684.10
List Price:  DKK kr957.77
You save:  DKK kr273.66
NZ$164.15
List Price:  NZ$229.81
You save:  NZ$65.66
د.إ367.20
List Price:  د.إ514.09
You save:  د.إ146.89
৳10,978.23
List Price:  ৳15,369.96
You save:  ৳4,391.73
₹8,290.53
List Price:  ₹11,607.08
You save:  ₹3,316.54
RM471.80
List Price:  RM660.54
You save:  RM188.74
₦156,534.34
List Price:  ₦219,154.34
You save:  ₦62,620
₨27,950.66
List Price:  ₨39,132.05
You save:  ₨11,181.38
฿3,595.26
List Price:  ฿5,033.51
You save:  ฿1,438.25
₺3,229.78
List Price:  ₺4,521.83
You save:  ₺1,292.04
B$499.40
List Price:  B$699.18
You save:  B$199.78
R1,883.20
List Price:  R2,636.56
You save:  R753.35
Лв179.42
List Price:  Лв251.19
You save:  Лв71.77
₩133,286.20
List Price:  ₩186,606.01
You save:  ₩53,319.81
₪365.03
List Price:  ₪511.06
You save:  ₪146.02
₱5,561.09
List Price:  ₱7,785.75
You save:  ₱2,224.66
¥14,911.76
List Price:  ¥20,877.07
You save:  ¥5,965.30
MX$1,670.32
List Price:  MX$2,338.52
You save:  MX$668.19
QR364.82
List Price:  QR510.77
You save:  QR145.94
P1,359.04
List Price:  P1,902.71
You save:  P543.67
KSh13,398.66
List Price:  KSh18,758.66
You save:  KSh5,360
E£4,718.65
List Price:  E£6,606.31
You save:  E£1,887.65
ብር5,656.15
List Price:  ብር7,918.84
You save:  ብር2,262.68
Kz83,512.74
List Price:  Kz116,921.18
You save:  Kz33,408.44
CLP$93,810.03
List Price:  CLP$131,337.80
You save:  CLP$37,527.76
CN¥710.61
List Price:  CN¥994.89
You save:  CN¥284.27
RD$5,917.87
List Price:  RD$8,285.25
You save:  RD$2,367.38
DA13,435.55
List Price:  DA18,810.31
You save:  DA5,374.76
FJ$226.69
List Price:  FJ$317.37
You save:  FJ$90.68
Q780.94
List Price:  Q1,093.35
You save:  Q312.40
GY$20,949.18
List Price:  GY$29,329.69
You save:  GY$8,380.51
ISK kr13,659.63
List Price:  ISK kr19,124.03
You save:  ISK kr5,464.40
DH1,002.67
List Price:  DH1,403.78
You save:  DH401.11
L1,768.33
List Price:  L2,475.73
You save:  L707.40
ден5,652.42
List Price:  ден7,913.61
You save:  ден2,261.19
MOP$805.88
List Price:  MOP$1,128.27
You save:  MOP$322.38
N$1,866.55
List Price:  N$2,613.25
You save:  N$746.69
C$3,681.10
List Price:  C$5,153.70
You save:  C$1,472.59
रु13,266.49
List Price:  रु18,573.62
You save:  रु5,307.13
S/368.83
List Price:  S/516.39
You save:  S/147.55
K382.06
List Price:  K534.91
You save:  K152.84
SAR375
List Price:  SAR525.02
You save:  SAR150.01
ZK2,508.19
List Price:  ZK3,511.57
You save:  ZK1,003.37
L456.04
List Price:  L638.48
You save:  L182.43
Kč2,310.02
List Price:  Kč3,234.13
You save:  Kč924.10
Ft36,211.46
List Price:  Ft50,697.50
You save:  Ft14,486.03
SEK kr1,038.11
List Price:  SEK kr1,453.39
You save:  SEK kr415.28
ARS$85,066.49
List Price:  ARS$119,096.49
You save:  ARS$34,030
Bs691.23
List Price:  Bs967.75
You save:  Bs276.52
COP$389,029.38
List Price:  COP$544,656.70
You save:  COP$155,627.31
₡50,979.09
List Price:  ₡71,372.77
You save:  ₡20,393.67
L2,470.17
List Price:  L3,458.33
You save:  L988.16
₲730,160.41
List Price:  ₲1,022,253.79
You save:  ₲292,093.37
$U3,841.23
List Price:  $U5,377.88
You save:  $U1,536.64
zł395.31
List Price:  zł553.46
You save:  zł158.14
Already have an account? Log In

Transcript

Hello there. In this current series of short It is my focus will be more on formatting tricks with respect to shortcut keys. I'm not going to burden with you loads and loads of shortcut key, in fact very selective but the ones which I'll be using along with you are the ones which you must remember and start using. And you will soon find out why. Well, in this case, often it happens that you right click and go to Format Cells. Correct.

Now, instead of doing that, you as well, might as well use Ctrl digit one control and one will prompt you with this Format Cells dialog box, which otherwise you would have got by clicking on Format Cells separately. Now just a word of caution while using the shortcut key. Use the digit one from this series of digits on your keyboard, not the one which are present on the num keypad. If you press control and digit one from this num keypad, it will not work. Next, if you are working with a date and you wish to get today's data on a single cell, you click on a cell and then press Ctrl semi colon, it quickly gives today's date which in this case happens to be second of February 2014. Let me press enter and there you go.

You have today's date. Not only that, this is a format you may approve a format which says to fpb 2014 in which case if you keep the cell selected and press Ctrl, Shift digit three Ctrl Shift and three, it quickly changes that in what format DD Mmm, why, why format. So combination of these two shortcut keys are used quite often to give a date today's date and then making sure the format is the one which I desire which looks good on the printout. Next, if you are working with a series of numbers, let's say I'm putting some numbers there you go. And you wish to apply comma style which we do using this million separator. So what you might as well do in as an alternative is press all key press the H Key from the keyboard, so as to activate the Home tab.

And once you do that, notice the letter key is the one which is indicated by the comma style. So I press escape. And there you go all the numbers in million separator. Not only that, if you wish to reduce the decimals, then do what old letter H. Then notice the digit nine is the one which is indicating decrease decimals. So I press nine. So all h nine once again, it shows me a whole number with no decimals.

So there you go. This is the same shortcut key which I was speaking about in the in one of the initial videos where I explained you the benefits of using alt and then following the key tips. Apart from this, a couple of miscellaneous shortcut keys are if you press Ctrl F, it quickly gives you the print preview and a lot of us while working with Excel before seeing a printout would like to use this shortcut key Ctrl f1 if I press Ctrl f1 it quickly hides the ribbon if I press Ctrl f1 again, it quickly bring Sit back. Apart from using shortcut key, you can also double click on any tab, it hides the ribbon and double click again, it bring back the ribbon. So this is if you want to increase your working area and want to see more numbers without getting interfered while the ribbon is still on.

Finally, let me talk about a short copy, which I have been using a lot in data cleaning and formatting all semi cool. Now what does it do? Let me go to sample data where I will show you the benefits of the shocker key. Let's assume Jan till June, you have a very simple list of months, I'm going to hide two particular rows. So I say hi. And I choose the entire block.

I just want to color those cells which are visible to me right now. So what do I do? I select the cells I go to home and then I pick up the color. Well, if I now unhide the rows which I had hidden, notice the cells which were hidden also got colored so what are the alternatives before me well Bring back the data, I will hide it again. Then let me choose the entire block and I will press the shortcut key which is mentioned on top this is called all semi colon. The benefit is it only chooses cells which are currently visible.

And then if you apply the color yellow, as I unhide the remaining rows back, notice the color doesn't get applied to the cells which were hidden or semi colon for choosing visible cells. Practice all this and trust me, as you work with Excel more and more, these shortcut keys are going to save a lot of time.

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.