Get a month of TabletWise Pro for free! Click here to redeem

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.18
You save:  د.إ146.92
List Price:  A$201.56
You save:  A$57.59
List Price:  ৳11,877.18
You save:  ৳3,393.72
List Price:  CA$189.69
You save:  CA$54.20
CHF 94.55
List Price:  CHF 132.38
You save:  CHF 37.82
List Price:  kr927.46
You save:  kr265.01
List Price:  €124.49
You save:  €35.57
List Price:  £112.13
You save:  £32.04
List Price:  HK$1,084.92
You save:  HK$310
List Price:  ₹10,454.37
You save:  ₹2,987.17
List Price:  RM600.20
You save:  RM171.50
List Price:  ₦54,316.12
You save:  ₦15,520
List Price:  kr1,326.46
You save:  kr379.01
List Price:  NZ$214.23
You save:  NZ$61.21
List Price:  ₱6,937.62
You save:  ₱1,982.32
List Price:  ₨23,458.82
You save:  ₨6,703
List Price:  S$195.29
You save:  S$55.80
List Price:  ฿4,356.68
You save:  ฿1,244.85
List Price:  ₺960.74
You save:  ₺274.51
List Price:  R2,381.85
You save:  R680.57
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