Microsoft Excel

Dragging the contents of a cell in MS excel 2007 not working (autocomplete)

Disabled fill handle and cell drag-and-drop check box are not checked from the Excel options. […]

Relative Cell References Relative cell references are basic cell references that adjust and change when […]

Match function returns the relative position of an item in a range that matches a […]

Typically you can change the fill color in a Microsoft Excel spreadsheet using the “Fill […]

Let’s highlight duplicate cell values from the following cells. Step 1 : (Select all cells […]

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace […]

Step 1 (Install the Add-in) Install the Add-in for PDF and XPS from http://www.microsoft.com/en-in/download/details.aspx?id=7 Step […]

Correlation is a statistical technique that can show whether and how strongly pairs of variables […]

In order to automatically drag sequence or serial number we have to drag numbers as […]

Returns a value either from a one-row or one-column range or from an array (array: […]

Here we are creating a Microsoft Visual Basic application module in excel sheet to convert […]

If you need to generate the ratio of two numbers to each other (e.g. 4:3, […]

In order to enter superscript and subscript in excel, follow following steps: Step 1 (write […]

For highlighting blank cells in excel, we are using conditional formatting. Steps are : Sample […]

Following example illustrates how to add N number of Days to a date in excel. […]