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

5 of my most used commands

Thought of listing something which I frequently use. Here is a list of 5 of my most used commands in Excel:

Sort your data using Data - Sort & Filter

Apply Data Validation using Data - Data Tools

Apply Conditional Formatting using Home - Styles

Change the format of text using Home - Font

Create a Pivot table using Insert - Tables