Free Project Management Tools - Tutorials,Ebooks and Setups

We know it is easy to copy and paste the data, but there is a technique to enter data in multiple cells so quickly. Select the range of cells, where you would like to enter a value. Holding the CTRL key, click on any cell and then type the value as per your wish, say “DP”.   And don’t press enter now, instead press Ctrl+Enter and then you will get the entire series with the same name DP. This works with the numbers as well, it doesn’t have to be in the same row or same column. Let’s see, if I want to type 100 in these 4 cells, I simply select these 4 cells by pressing Ctrl key and selecting a cell of these and I type 100 and press Ctrl+Enter. So, you can use this trick for numbers, text and also for formulas. Let’s see an example for using the formulas as well.   Here, I have got some numbers and let us find the sum of all these columns. First, let me select all the cells here, type the formula as = Sum (select the range in the first column) and press Ctrl+Ent

  In order to see a formula in a cell, we generally double click a cell.   But sometimes, we may want to see all the formulas at once. To do that, there is a key stroke shortcut and also a menu command that will allow you to display all the formulas. The key below the Esc key on your keyboard having the Tilde & accent grave can be used along with the Ctrl key as a key stroke shortcut now. So, let’s try now by pressing the Ctrl+` key on your keyboard to see that all the formulas in the sheet, getting displayed and columns width has been increased. If you press the Ctrl+` again you will be back to the normal display. You can also find this feature from the menu bar, Go to the Formulas tab and select the option called show formulas Now, let’s see the other trick of highlighting all the cells that contain formula Go to the Menu bar and in the extreme right, you will see the Find & Select button, click it and choose formulas and then all cells that have f

How To Change The Data Without Using The Formula In Excel || MS Excel Tricks And Tips If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. In this example, I have some numbers 1 to 10 in this column and if I suppose to multiple each cell by 2, what would everyone generally do? Using formula in the next column, we multiple each cell by 2 but let’s see how we can do this without using the formula. I type 2 in a cell and then copy the cell.(CTrl+C) now select the entire range which needs to be changed and then press CTRL+ALT+V and under operations select the multiply option and click OK, you will see the result getting exactly the way u wished. Let us see one more example, here you will notice that using the formula is no better than using our new feature. Here I have targets for 4 regions by month wise and what if your boss ask

·          Flash fill is the most powerful tool that has been introduced in MS Excel 2013. Using this feature, we can combine multiple columns and separate the data from a column. Now let’s see with an example. ·          In the first column, I have Full names (First name separated by last name) and if I would like to reverse the order of first name and last name, we generally do that by using the Text to columns / concatenate functions. But using this new feature of flash fill, we don’t’ need to do this anymore. ·          In the adjacent column, I type the last name of the first entry, comma and type the first name and then go to the menu bar and go to the Data tab and click on flash fil (either u can press Ctl+E as a shortcut) and you will notice that the names populated as per your wish. It’s nice right. ·          In the 2 nd example, let’s try combining the two columns. Now we have first name and last name in two separate columns and lets start by typing the firs