## how to create salary ranges in excel

Only Markers | Straight LinesUse a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship ...

## how to copy and paste spreadsheets in excel

Paste | Values | Formulas | Formatting | Paste SpecialThis example illustrates the various paste options in Excel. Cell B5 below contains the SUM fu...

## how to convert xml file to html& file

You can convert your Excel file to an XML data file, or vice versa. This enables you to exchange data between different applications. First, turn on the Deve...

## how to calculate original price from percentage

Calculate Percentage Discount | Calculate Discounted Price | Calculate Original PriceIf you know the original price and the discounted price, you can ca...

## how to insert multiple blank rows in excel at once

Insert Row | Insert Rows | Insert CellsTo quickly insert a row in Excel, select a row and use the shortcut CTRL SHIFT +. To quickly insert multiple rows...

## how to find the sample mean and standard deviation

What is Standard Deviation? | STDEV.P | STDEV.S | VarianceThis page explains how to calculate the standard deviation based on the entire population us...

## how to do a frequency distribution in excel 2010

Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.R...

## how to make words fit in a cell in excel

Wrap Text Automatically | Manual Line BreakWrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically...

## how to move columns in a table in excel

Shift Key | Insert Cut Cells | Magic MoveTo move columns in Excel, use the shift key or use Insert Cut Cells. You can also change the order of all colum...

## how to password excel 2007

This example shows you how to make your workbook read-only. Users can still save changes by creating a new copy of the workbook. For a better protection, pro...