Tips and tricks in Excel 2016 (updated 2017)

by Ali June 6, 2017 at 11:51 am

There are many tips and tricks in Excel 2016 that today I am going to show you some in this article. In Excel 2016 there are many formulas and functions but without that, there are tips and tricks. If we know some tips or trick of Microsoft Excel, then they can make the work easy. For example, instead of writing the month’s name one by one you can write one of them then use the fill series option other will be filled automatically. Like the example, there are many other tips and trick that some people don’t know and in this article, I am going to show some basic and easy tips for Excel users.

Tips and tricks with the formula and functions (Auto sum)

There are some tips that are possible by using the formula. I think all of you had listened to the name of AutoSum. By this option, we can do so much. For example, if you want to count many numbers in a row you can use the AutoSum option to add them all. you can also find out the average of the numbers in a row. There is another ability of the auto sum option like maximum, minimum. It means that we can find out the minimum and maximum of the numbers exist in a row.

If you need to collect some numbers in a row and get the result of all then you don’t need to select them one by one to add them. At the last of numbers click on the Auto sum option to add them all. you can see the example in the following picture.

AutoSum in Excel 2016
Auto Sum

Also if you want to know the minimum and maximum of the numbers in a row. Click auto sum option and then select the min or max option. it will automatically find out the min or max of the numbers that exist in the row. You can get the instruction from the following picture.

How to find out the maximum in Excel 2016
Maximum

If between the numbers that are in a row a text come, then the auto sum will count only till the text not the other side of the text. You can see the example in the following picture.

Tips and tricks EXCEL 2016
Text in the Middle

Tips and tricks in Excel 2016 spreadsheet

On the above paragraph, I taught you some tips and trick with the auto sum option. Here I will tell those trick that you can do within the spreadsheet of Excel. There are some amazing tricks that you can use daily in your work. For example, without typing months’ name one by one we can type them at once.

1st tips and tricks in Excel 2016

If you need series of the numbers till anyhow. You don’t need to type individually. Type any number that you want to make the series after then take from the left corner of the cell, pull it till anywhere you want. A small square will appear at the end of the cell you pull. Click on that and then select the fill series option. you can see the instruction from the following Picture.

Fill series in Excel 2016
Fill series

You can see the result of that in the following picture.
Note: you can make series of the months vertically and portrait.

Tips and tricks in Excel 2016
Result

2nd tips and tricks in Excel 2016

Write any name of the month you want then take from the corner of the cell. If you pull it above, then the previous months will appear and if you pull down the upcoming months will appear.

Excel 2016 tips
Month Name

Use the shortcut form of the name of the months. For example, Jan, Aug., Sep, Oct, or any other. You can make series of the months vertically and portrait. the result below.

Excel 2016
result for month tip

3rd tips and tricks in Excel 2016

If you want to fill specific cells one by one, then there is a simple trick. Press control and select the cells with the mouse cursor. After selection type one cell and then press tab to move to the other cell. The selection can be everywhere. Look at the picture below.

Excel tips
Excel tips

More tricks

If you want to fill many cells with one word, then it is possible. First of all, select the cell that you want to fill them with one word. After selection type the word in one of the cells and then press control and press enter. The word will be filled in all of the selected cells. You can see the instruction in the following picture.

More tips
More tips

Conclusion

I write this article for those who didn’t know this tricks and they are going far away just for doing some easy works. I hope this article is helpful and beneficial for those who read this. Put a comment below the post and ask any question you have about the article. Also provide us a feedback in the comment. Rate this article from 10. We will be happy knowing the result of our work.

Click here for more Microsoft Office Tutorials.
Click here for more YouTube tutorials.

Share

Add Comment