0503 Go To (Special) w. Ctrl+Enter

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$180.54
You save:  A$51.58
List Price:  ৳11,866.68
You save:  ৳3,390.72
List Price:  CA$176.88
You save:  CA$50.54
CHF 88.56
List Price:  CHF 123.99
You save:  CHF 35.42
List Price:  kr856.85
You save:  kr244.83
List Price:  €115.16
You save:  €32.90
List Price:  £102.10
You save:  £29.17
List Price:  HK$1,085.16
You save:  HK$310.07
List Price:  ₹10,216.03
You save:  ₹2,919.07
List Price:  RM564.15
You save:  RM161.20
List Price:  ₦53,196.20
You save:  ₦15,200
List Price:  kr1,178.92
You save:  kr336.86
List Price:  NZ$194.68
You save:  NZ$55.62
List Price:  ₱6,730.59
You save:  ₱1,923.16
List Price:  ₨22,489.39
You save:  ₨6,426
List Price:  S$185.22
You save:  S$52.92
List Price:  ฿4,192.56
You save:  ฿1,197.96
List Price:  ₺1,033.78
You save:  ₺295.38
List Price:  B$750.37
You save:  B$214.40
List Price:  R2,095.15
You save:  R598.65
List Price:  Лв225.25
You save:  Лв64.36
List Price:  ₩154,078.01
You save:  ₩44,025.43
List Price:  ₪458.17
You save:  ₪130.91
Already have an account? Log In


Hi there, somehow I'm getting a feeling that you're loving the tasks that we are sharing with each other, and especially the techniques which helps us overcome those challenges. Here comes another one. On the left hand side, as usual, I have the similar data, but this time the question is different. I have a lot of blank cells inside this table have a lot of numbers. And I would fill a word pending in that, not to be able to do that I must share with you one simple and very important trick. before I proceed, let's do small experiment, I will ask you to choose a group of blank cells randomly and start writing pending.

Notice that my cursor is still blinking inside the first cell when the pending word is being written. And all the other cells which I had initially chosen are still holding the selection. Now normally when we press enter, what does it do? It will only give you one occurrence of the word bending. Let me go few seconds back again to the data. This time, let me write the same word again, but not press Enter instead, Let me press Ctrl Enter, you noticed all the cells, which was chosen gets filled with the data, or formula or text or number that I had initially written and Ctrl Enter just replicates that in all the cells.

Similarly, if I choose all the data points in the table, I press Ctrl G, I go to special. Thereafter I choose blanks. Yes, there's one more option blanks, which will help you choose all the blank cells inside the data set. I'll be careful, I will not choose a cell separately because if I do, I'll lose the selection. So let me quickly do this once again. Ctrl G, special blinds, okay.

Not choosing a cell separately and straight away typing, bending. You notice the first selected cells is holding the word pending the cursor still blinking. Now finally, it's time for Ctrl Enter. It fills up all the selected cells with the same word you started off with

Sign Up


Share with friends, get 20% off
Invite your friends to TabletWise learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.