Now our target is to show this data as Al1,Al2.Bl6,Bl7.Bl10 then click Ctrl+Enter.then that formula applies to all selected blank cells.do Paste Special Values.then the data is looks like Select alphabet e F5.go to special.click blank and click ok.it will select all the blank cells.just enter =up allow.then it will take the above cell value. right? If the that is the case the following is the solution Let my correct if i wrongly understand your question.Īl1.means A in one cell and 1 in Adjucent cell. Quick Comparison of Data using Row Differences.What about you? Do you use this? How do you use it? Please share using comments. I use CTRL+Enter often when I need to fill in the same value in multiple places. Do you use CTRL+Enter? Share your tips & uses? I have a lot of work to do since we are re-opening VBA classes this Wednesday (11th Jan). See this demo to understand this technique.
Select “Blanks” to select all blank cells.We can use this technique to fill all the blank cells too. Using CTRL+Enter to fill blanks with same value See the animation aside to understand how this works. Select all the cells where you want to enter the same data.You can use CTRL+Enter to do this in a snap. Sometimes, we want to enter same data in to several cells. Here is a quick Excel tip to kick start your week.
0 kommentar(er)
