No matter if India lost another one.... here is another excel tip

Cell Function


This function examines a cell and displays information about the contents, position and formatting.

=CELL("TypeOfInfoRequired",CellToTest)
The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".


The following example uses the =CELL() function as part of a formula which extracts various information

Quick Tip - How to format Heading rows in one click!

If the Format as Table option formats the entire data and does not suits your requirement to only format the heading row leaving the data intact, follow these steps to quickly format only the heading rows.

E.g. this is your data

Select the heading row and click on the Cell Styles drop down (available on Styles group of the Home tab).

Now select the format which looks presentable to you.

And that is it!!!