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

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

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

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

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

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

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

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

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

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