How to Create Index Sheet Hyper-linked to Other Sheets

Some days ago, I was working with some data which was distributed in about 18 sheets within a single Excel file. I was supposed to make calculations and then present that file to senior management. Now presentation was important as well. I must have made it easier for...
How To Add Colored Cells in Microsoft Excel

How To Add Colored Cells in Microsoft Excel

Use of SUM formula is very common to add a range of cells. You can also use SUMIF as well if some condition has to be fulfilled for addition of certain cells. But if we have to add certain cells from a range on basis of cell background color or font color of those...
workingWithExcel.com

Subscribe To Excel Newsletter

 

You will receive it when a new post is published

You have Successfully Subscribed!

Pin It on Pinterest