0905 Trick - Hide/Unhide Rows and Columns and Freeze Panes

Advanced Excel Crash Course Section 9: Organising Data
5 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

Greetings from Russia Puglia from Excel action solutions. In the last of the series of dashboards one, we will be talking about hiding and hiding columns and rows one trick regarding that and freeze unfreeze panes. Now, generally when you have a data as big as this, you would want that when you scroll down, the headers must be there on your screen. And if you scroll right, which are talking about dealer wise quarterly details of all the sales amount, the dealer name should be there. Now, most of the time it happens. Let me undo one setting is unfreeze panes.

Most the time it happens if we scroll down we do not get to see the header. If we scroll to the right, we do not get to see the columns. So I would want that this column the one that is blinking should be there on my skin, always. The cells the rows that are blinking now on my screen, those should also be there. Always Now both of these requirements, where are they meeting? When I say meeting?

I would want to refer to the cell because the column before it, and the rows before it, this is would you want to fix it? There's something would you want to fix it? Yes, of course, because I would want that whenever I schooled round down behind us should be there. So I choose this cell very carefully. I go to View dad, and I reach out to freeze panes. First option Freeze Panes, because I just do not want the top row to be frozen.

I want that three rows should be frozen. So freeze panes. What has happened, the rows on top of this yellow cell has been frozen the column before this yellow cell has been frozen, the one that he wanted. In case you want to unfreeze it, simply click anywhere good if you and unfreeze panes. So the main idea is choosing that relevant cell layer. See if I choose this cell this time, the one in the second yellow cell, this means these row shall be fixed, frozen will not change.

Let me just color code them. These columns shall not change. So if I choose the 378 Here, let me go to View. Freeze Panes. Let's see what happens. You'll notice as as much as I scroll down, the rows will be visible always, as much as I scrolled right.

The numbers in red on my left are going to be present simple technique, freeze and unfreeze panes. Now, after having spoken about freeze unfreeze panes, I would want to talk about a small trick with respect to hiding and hiding columns and rows. At the basic level, you may want to hide a particular column just by selecting the column T, let's say you may right click on that letter D and say hide If you want to bring that column D back, you may choose both C and E, both E and E and then right click and unhide. Now, this was the basic stuff I will talk about one trick. Let us say that you may have chosen this area no man's land. So not even column not even rows of the choosing the entire sheet.

I put my cursor on any one of the column headings and right click and say hi, please note, I am not clicking left hand click and then right clicking because with that the entire selection goes off. So, I go to the mean sheet, select all sheet, sheet if you right click on any one of the column and say hide. Now, when I look at this several questions come before me. Can I unhide quickly, let me try. Right click on height, nothing happens. Right click right click doesn't happen.

Right click here height and height doesn't matter. Up to a to be able to unhide. This. I want to ask one question, what do you think has been hidden? Is it the column? Is it the row?

Or is that the Is it the sheet? sheet column? No. Now, it's not the sheet that is hidden because you can see the sheet tab. It's not the door that has been hidden, because you can see the row numbers what has been hidden is the column now to unhide. That in 2007, I will have to guide you to that button the command where unhide hide options are present.

So I will have to ask you to go to Home towards the right hand side, go to Format. Within format, go to hide unhide and choose unhide rows. Let's say nothing happened. Why? Because it's not the road that has been hidden. It's the column that were hidden.

So let me go to Format mechanic And this time let me say unhide columns. Yes. There you go. This way it comes back. So simple hiding and hiding and the command for unhiding hiding also exists under format, hide unhide tie this with multiple sheets with different data sets. And we will talk about more advanced stuff more customized, more appealing stuff in the subsequent videos.

See you there.

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.