# Category: Microsoft Excel

Microsoft Excel

## Add days in date Excel

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

## Highlight blank cells using conditional formatting in Excel

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 >...

## Superscript (power) and Subscript in Microsoft Excel

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...

## Calculate ratio from two numbers

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...

## excel convert number to words in rupees

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...

## Vlookup function in Microsoft Excel

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...

## Drag sequence number automatically in Microsoft Excel

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...

## Calculating Correlation in Microsoft Excel

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...

## Substitute function in excel

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...

## highlight duplicate cells in excel

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...

## Remove Cell Fill Color That Will Not Go Away

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...

## matching values in specified range excel with match function

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 and Absolute Cell References

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...

## 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. Cell handle is not shown draggable as shown in the following image : To enable this please follow these...