Category: Microsoft Excel

Following example illustrates how to add N number of Days to a date in excel. Example

For highlighting blank cells in excel, we are using conditional formatting. Steps are : Sample Step 1 (Open more rules of conditional formatting) Select data range > Conditional Formatting > Highlight Cell Rules >...

In order to enter superscript and subscript in excel, follow following steps: Step 1 (write the text in a regular way, and select the text) Step 2 (select Format -> Format Cells) Step 3...

If you need to generate the ratio of two numbers to each other (e.g. 4:3, 16:9, etc.), you can do using division, the GCD function, and concatenation. In the generic form of the formula...

Here we are creating a Microsoft Visual Basic application module in excel sheet to convert Indian rupee (digit format) to their respective amount in words (in english). In order to do this we have...

Returns a value either from a one-row or one-column range or from an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are...

In order to automatically drag sequence or serial number we have to drag numbers as : Example Write at least two numbers in cells, and then position your mouse in the lower right corner...

Correlation is a statistical technique that can show whether and how strongly pairs of variables are related. For example, height and weight are related; taller people tend to be heavier than shorter people. Correlation...

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 2 Step 3

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a...

Let’s highlight duplicate cell values from the following cells. Step 1 : (Select all cells and click condition formatting) Step 2 : (Select Highlight Cell Rules > Duplicate Values) Step 3 : (Select any...

Typically you can change the fill color in a Microsoft Excel spreadsheet using the “Fill Color” tool located in the “Font” section of the “Home” tab in Microsoft Excel 2010. However, if you have...

Match function returns the relative position of an item in a range that matches a specified value in a specified order. Syntax : MATCH(lookup_value,lookup_array,match_type) 1. Lookup_value is the value you use to find the value...

Relative Cell References Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Step 1: In the following image we have shown a simple excel spreadsheet. No...

Disabled fill handle and cell drag-and-drop check box are not checked from the Excel options. Cell handle is not shown draggable as shown in the following image : To enable this please follow these...