0505 Go To (Special) - Fill Intermittent Blank Cells - Case 2

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Hi, as part of the series of Ctrl, G and Ctrl, enter techniques from the previous video session, here comes another task. On the left hand side lies a table where a set of number has been totaled up. And that particular line item which has a hypothetical limb, ABC contains the total of the above numbers in this case. Now, what we want is to fill up all these gaps such that if I wish to apply filter, I can do so very quickly. How do I do so? First, let me place my cursor on the first blank cell.

Let me press Shift, control m key. It uses the last use as an anchor to take its selection to now I press Shift control up arrow key, shift left, left, left, left, left, left press Ctrl backspace key, it keeps the selection and at the same time, lets me look at the entire data set right from the header. I press Ctrl G. I'm good. to press Alt, S key, this will take me to the gold especially box and within which I'm going to choose key letter key. This will take me to blanks. And since I need to build a chain which reference a value from the bottom cell or the cell below it, I'll put equal to the cell below it.

In this case, if I let me press Ctrl, enter, and there you go, you'll notice all the selection has been filled with the requisite value, which has been taken from this cell, which is acting as an anchor, in this case, ABC. If you wish to apply a special value, this will just solidify the entire data set such that if one data is needed, it doesn't destabilize the entire data set. So I'm going to select the first cell, shift, right shift CTRL down arrow key Ctrl C, the shortcut key for paste special value Ctrl, Alt V, and then let me choose letter V, which will highlight value and Let me press enter. So there you go. In a few seconds, you're able to fill All the blank cells. See you the next video.

Sign Up


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.