Excel Tips, Tricks, and Shortcuts

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: The trick to paste the data in the multiple cells in a single paste. Tip Quiz What is the formula to move the unwanted spaces in the cell(s)? Do you know how to paste data to multiple cells in your Excel worksheet? Therefore, whether you know or you don't; it does not matter at all. Because I am going to tell you the trick to paste the data into cells as much as you want in an Excel worksheet with an easy way. Look at and follow the method below: Select the data in the cell and copy it. Use the mouse to select any cells being pasted. Press “Ctrl” and “V” buttons. (The data will be pasted immediately.). Figure no.1 Show the cell to be copied. Figure no.2 Show how to select all the cells to be pasted. Figure no. 3 Show all the cells be pasted with the data entered. Tip Answer  a.  The formula is =trim().  b.  ...