Microsoft Excel is an awesome tool which makes your monotonous job in a simple way. Whether it is dealing with the information or handling the repeated tasks, Excel can easily finish it up. There are numerous Excel features which the vast majority of us don’t have the idea. By knowing those hidden features and tips will help us to save time and finish the work quickly. Today, we are going to discuss about some Excel tips to save your time and finish the work easily.
- Make Chart from various cell values
We can makea chart from cell values which are not contiguous. As we definitely realize that, we can choose values present in different cells by holding the Ctrl key, and then similarly choose values which are not the contiguous cells and after that insert the required chart.
- Multiple Lines in a single cell
Sometime while filling the Excel sheet, here and there we need part of data in a single cell. For instance, in case you need to write the location in a cell, then it should be in numerous lines. So, you press “Enter” button, control moves to the following cell, however that is not what we need. Press Alt + Enter to move the cursor to the following line of the same cell and this will make it possible to have multiple lines in a cell.
- Include cell values speedily
In case you need to include average value of different cell values, then there is no compelling reason for utilizing the formula. To complete these essential things, choose the cell, press “Ctrl” key and choose the cells which you need. On the status bar which is at the base of the Excel sheet you can see the Sum, Average and different values. So, choose the value you need to see.
- Tab between Worksheets
Going from worksheet to worksheet doesn’t require you to move hand off the keyboard with this cool tip. To change to the following worksheet enter Ctrl + Pgdn. What’s more, then again change to the worksheet same side by entering Ctrl + Pgup.
- Automatically SUM () with ALT + =
Quickly you can add an entire row or column by clicking in the first empty cell in the column. Then just press ALT + ‘=’ (equals key) to add up the numbers in every cell above.