Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Useful Microsoft Excel Tricks

Date:2021-2-1 Author:Sandra

We have shared many Excel tricks to improve your work efficiency in previous tutorials. But there’s a saying that goes: multi-skills are not pressure. So in this article, the author would still share with you guys useful and best Excel tricks.

How to Highlight Nonworking Days in Excel Sheet?

You need to prepare the date sheet first, let’s take June 2021 as an example. Choose all the data and go to Conditional Formatting Rule.

Useful Microsoft Excel Tricks
Useful Microsoft Excel Tricks

Select the last rule type: Use a formula to determine which cells to format. Then enter the formula [=mod(a1-2,7)>4] into the lined box. Change the Format by the way.

Useful Microsoft Excel Tricks
Useful Microsoft Excel Tricks
Useful Microsoft Excel Tricks

How To Insert Table Title in Bulk?

If you need to insert many same titles at one time, you can keep pressing the Ctrl key and click every sheet to choose them all and finish one table title like in sheet 1.

Useful Microsoft Excel Tricks
Useful Microsoft Excel Tricks

Now you will get all the table titles immediately.

How To Calculate Incremental Sum In Microsoft Excel?

Useful Microsoft Excel Tricks

Select the cells to be filled, pay attention to that you can only select these cells from right to left. And enter the formula [=sum($B2:G2)], place your cursor between B and 2 then press three times F4 to and press Ctrl and Enter together.

Useful Microsoft Excel Tricks
Useful Microsoft Excel Tricks

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *