0108 Using Quick Access Toolbar (QAT)

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
€92.78
List Price:  €129.90
You save:  €37.11
£79.40
List Price:  £111.16
You save:  £31.76
CA$136.11
List Price:  CA$190.56
You save:  CA$54.44
A$154.13
List Price:  A$215.78
You save:  A$61.65
S$135.08
List Price:  S$189.12
You save:  S$54.03
HK$782.28
List Price:  HK$1,095.23
You save:  HK$312.94
CHF 90.61
List Price:  CHF 126.85
You save:  CHF 36.24
NOK kr1,085.23
List Price:  NOK kr1,519.37
You save:  NOK kr434.13
DKK kr692.01
List Price:  DKK kr968.84
You save:  DKK kr276.83
NZ$167.80
List Price:  NZ$234.94
You save:  NZ$67.13
د.إ367.19
List Price:  د.إ514.08
You save:  د.إ146.89
৳10,976.08
List Price:  ৳15,366.96
You save:  ৳4,390.87
₹8,339.52
List Price:  ₹11,675.66
You save:  ₹3,336.14
RM473.25
List Price:  RM662.57
You save:  RM189.32
₦141,842.81
List Price:  ₦198,585.61
You save:  ₦56,742.80
₨27,810.04
List Price:  ₨38,935.18
You save:  ₨11,125.13
฿3,647.70
List Price:  ฿5,106.92
You save:  ฿1,459.22
₺3,232.12
List Price:  ₺4,525.11
You save:  ₺1,292.98
B$499.21
List Price:  B$698.91
You save:  B$199.70
R1,908.54
List Price:  R2,672.04
You save:  R763.49
Лв180.65
List Price:  Лв252.92
You save:  Лв72.26
₩135,197.71
List Price:  ₩189,282.20
You save:  ₩54,084.49
₪368.63
List Price:  ₪516.10
You save:  ₪147.47
₱5,633.91
List Price:  ₱7,887.71
You save:  ₱2,253.79
¥15,144.47
List Price:  ¥21,202.86
You save:  ¥6,058.39
MX$1,659.40
List Price:  MX$2,323.22
You save:  MX$663.82
QR364.31
List Price:  QR510.04
You save:  QR145.73
P1,370.91
List Price:  P1,919.33
You save:  P548.42
KSh13,148.68
List Price:  KSh18,408.68
You save:  KSh5,260
E£4,729.52
List Price:  E£6,621.52
You save:  E£1,892
ብር5,680.63
List Price:  ብር7,953.11
You save:  ብር2,272.48
Kz83,612.74
List Price:  Kz117,061.18
You save:  Kz33,448.44
CLP$97,978.20
List Price:  CLP$137,173.40
You save:  CLP$39,195.20
CN¥722.95
List Price:  CN¥1,012.16
You save:  CN¥289.21
RD$5,921.50
List Price:  RD$8,290.34
You save:  RD$2,368.83
DA13,490.83
List Price:  DA18,887.70
You save:  DA5,396.87
FJ$226.12
List Price:  FJ$316.58
You save:  FJ$90.46
Q779.86
List Price:  Q1,091.83
You save:  Q311.97
GY$20,923.51
List Price:  GY$29,293.76
You save:  GY$8,370.24
ISK kr13,946.60
List Price:  ISK kr19,525.80
You save:  ISK kr5,579.20
DH1,013.19
List Price:  DH1,418.51
You save:  DH405.32
L1,763.34
List Price:  L2,468.75
You save:  L705.40
ден5,702.11
List Price:  ден7,983.18
You save:  ден2,281.07
MOP$805.89
List Price:  MOP$1,128.28
You save:  MOP$322.39
N$1,893.44
List Price:  N$2,650.90
You save:  N$757.45
C$3,681.15
List Price:  C$5,153.75
You save:  C$1,472.60
रु13,335.63
List Price:  रु18,670.42
You save:  रु5,334.78
S/370.84
List Price:  S/519.19
You save:  S/148.35
K382.72
List Price:  K535.82
You save:  K153.10
SAR375
List Price:  SAR525.01
You save:  SAR150.01
ZK2,522.76
List Price:  ZK3,531.96
You save:  ZK1,009.20
L461.43
List Price:  L646.02
You save:  L184.59
Kč2,350.75
List Price:  Kč3,291.15
You save:  Kč940.39
Ft36,729.02
List Price:  Ft51,422.10
You save:  Ft14,693.08
SEK kr1,071.30
List Price:  SEK kr1,499.86
You save:  SEK kr428.56
ARS$85,766.82
List Price:  ARS$120,076.98
You save:  ARS$34,310.16
Bs691.04
List Price:  Bs967.48
You save:  Bs276.44
COP$387,583.68
List Price:  COP$542,632.66
You save:  COP$155,048.97
₡50,832.34
List Price:  ₡71,167.31
You save:  ₡20,334.97
L2,468.78
List Price:  L3,456.40
You save:  L987.61
₲737,805.73
List Price:  ₲1,032,957.54
You save:  ₲295,151.80
$U3,781.90
List Price:  $U5,294.82
You save:  $U1,512.91
zł400.73
List Price:  zł561.05
You save:  zł160.31
Already have an account? Log In

Transcript

Hello there. This video I especially focus on the shortcut key that we have been or we will be using for paste special value. Well, the concept is in case you have a formula, which probably in this case is adding a few of the numbers above, and you want to replace these this formula with a value which says nine and 17, respectively. So what we do generally we copy the cell, and we right click on it, and then we say PASTE SPECIAL. Once I click on Paste Special, it brings me the old dialog box to one of the options, same values. Okay, so what it does is it replaces the formula with a value.

Now I'm going to press Ctrl Zed, because the next time I'm going to apply a special value, it is going to be with a series of shortcut keys. So first things first, I copy the cell. On occasion I see people working in midnight they forget to copy the cell and they are trying to use the shortcut key of A special it will never get applied. Make sure that he first copy the cells, the content and then people receive these special shortcut key. So Ctrl C, one of the first shot at which I want to show you is Alt E s v, enter. This is a series of shortcut key one at a time to be pressed one at a time.

So all then e, then S, then you notice the values, the V has been underlined V for victory, so I press V and then enter. This is one way of the special value. This is another way. Let me press controls that bring back the data to its original form. Again, choose a cell I press Ctrl C, then this time, I'm going to press Ctrl Alt v together, and it prompts me with the same pay special value dialog box. So I press the letter V V for values and then I press enter.

It does the same effect. It does the same thing as what all ESP would have done. Besides this. You might comment that look these ports shortcut key or rather cumbersome they involve a seat Have these to be pressed either simultaneously or one at a time. I want the easy scenario, which probably just uses water just to shortcut key not even enter the How's that possible? Let me show you the trick.

I will go to file I will go to options. Within options I go to Quick Access Toolbar. Now what is quick access toolbar, I have this small area where a couple of icons are already predefined. Now I want to have a button which says paste value on this Quick Access Toolbar section. So when I go to Quick Access toolbar, I from the drop down choose all command. Now this is necessary because this allows you to see all the possible commands exhaustively.

Now I'll select any one and press the letter P which allows me to see all the shortcut keys starting with letter P. So as I scroll down notice towards the bottom of the P a series you will find pasted Be very careful do not choose Paste name or paste special, use paste values and then say add. What it then does is after you press OK and get out of this entire dialog box, besides save beside undo redo, you will have another icon which will say is values. Notice how with just to shortcut key will you be able to use this. So, I choose a cell primarily should have been with formula. So I choose Excel, I'm going to press Ctrl C, which is a standard format of copying cell. Thereafter, I press ALT key.

And notice as soon as I press all key on the Quick Access toolbar, the digit four is indicating paste value. So all I have to do is press the digit four. There you go, that was a special value, I just had to press to shortcut key. Now if you are putting a lot of these icons on Quick Access toolbar, maybe maybe the sequence would then define paste value as old five or maybe six depending on where it is placed. So at the end of Wait, what I noticed is it just requires two shortcut key not even enter. If you've been using a special value, start with this technique where you are going to go to File options within which Quick Access toolbar, then all commands, pick up the pace value, which certainly you will find in the list and then just make sure you added Not only that, in case you happen to use filter quite often, you find out various filter icon and from that given list, you simply add that to the Quick Access Toolbar.

So next time if you wish to apply a filter, all you got to do is choose the data and press ALT and then in this case, digit five. That's about it. So see you in the next series of shortcut videos.

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.