0104 Navigating Across Worksheets, Data Table Selection and Maneuvring

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, in this continuing series of ninja level shortcut keys, let me walk you through some of the shortcut keys which relate to workbook navigation sheet navigation and cell or cells selection. And in between also some of the very important shortages, which you would normally not find even the advanced users of Excel using those. So let's go with certain base data. Now you notice the first thing I have on my workbook is couple of worksheets, some are old, some are generated right now, if you want to toggle between the different sheets, you might want to use Ctrl page up PG Up and Page down CTRL p GD n. So this is a shortcut key which actually helps you toggle between the different sheets in specially in case if you're working with multiple worksheets. Now let me take a test data before I talk about other shortcut keys.

Let me go to sample data one which you will also find in the Excel case 35 advantage with us is that you have both the videos Trainer with you and the actual case studies too. Practice on. So let's go ahead. First things first, if you work with data, the primary step is to choose the data before you can apply sort filter or pivot table, isn't it. Now, given the data we have, I wish to apply a certain filter. Now to do that, I must use the data.

Now if I place my cursor on any one cell and press Ctrl A, notice it chooses the data but it stops at the point where there is a blind group. So to circumvent this, I will take you through another series of shortcut key which will help you select the data. So I place my cursor on the orange cell and I keep Shift Ctrl pressed with my left hand I'm keeping shift control pressed, keeping it pressed. Now let me put my right hand side finger on the right arrow key. What it does, it quickly selects the data on one direction that is right direction. Then keeping shift control pressed I pull the down arrow key down arrow key down arrow key down arrow key and I continued till the last line Have the data, although it helps you in selecting the data.

But notice since there are so many blanks is actually making your life worse. So now, let me again take you to a shortcut key, which is going to help solve this problem. So put your cursor on the orange cell, we will not be using ctrl shift right and down. Instead, we'll be using shift control n key. Now what is shift control n key doing? If I take you to a blank worksheet, and if I write some letter, let's say a B, and let's see, or maybe the notice this cell has been the last use cell of this worksheet.

Now even if I delete that particular letter, and then place my cursor on letter A, and then if I press Shift Ctrl N key, it takes my selection, right from active cell to the last use cell. So I used this trick. Why because orange cell was the active cell and shift control and key helped me take the selection to the last use set. Now at times it may happen that could be other cells which have been used previously, and there is no data. So if you intend to apply Shift Ctrl N key, it will take your selection to the last cell. A couple of things, this has allowed you to skip the blanks and choose the last cell.

But wait, you do not want to choose the cells are in fact columns of B f g h i n j. So what we do, we want to reduce the selection, one step at a time, Shift key pressed and then left, left, left, left, left, left. Now, only three columns have been chosen. Now, what shift right right or left does is it allows you to select one column or row at a time in terms of direction you are taking. At the same time you would say look, I've chosen the data but I want to go back to the header right. So if I press Ctrl backspace key notice the data is still selected.

And yet your selection appears to be taking you to the header because I've seen people What they do, once they've selected the data, they use the scroll bar on the right to reach to the header of the data. This could be painful task, especially if you're working with really large data. So just summarizing what have we learned? We talked about control a, we talked about shift control right down, down. And better than that on occasions he also use shift control and key in terms of selection, reducing the selection, shift left, left, left, left, and control backspace key to help me go to the head. More shortcuts on way as you go to the next video.

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.