Excel

1. Type the list items into cells in a column of the current worksheet or another worksheet. Name the list if you enter it into a differen...

1. Type '=COUNTBLANK(' in an empty cell. 2. Highlight the column of data you want to calculate the number of empty cells. 3. P...

1. Complete the data and calculations in your worksheet. Even if your data and calculations span multiple worksheets, you can pull the dat...

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 100, 200, 300, 400, 500 and 600 in A2, A3...

1. Select your items, row, or column that you would like to subtotal in your pivot table report. 2. Click 'Field Settings' in th...

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart in which you want to change the formatting of t...

1. Log on to your computer and open Microsoft Excel. Create a new spreadsheet. 2. Label the columns in your spreadsheet by giving them d...

1. Launch Microsoft Office Excel, click the 'File' tab and click 'Options' to open the Excel Options Window. 2. Click ...

1. Select the first range of cells by holding down the 'Ctrl' key, selecting the fist cell of interest with the left mouse button,...

1. Download a preferred converter software. Websites such as Free Downloads Center or File Buzz have XPS-to-Excel 2003 converter software ...

1. Open the spreadsheet you wish to modify. Hold down the 'Ctrl' key, and tap the 'A' key twice. This should select all of...

1. Open an Excel workbook that contains a macro. 2. Click the arrow to the right of the Quick Access Toolbar to reveal a drop-down menu;...

1. Open a new Microsoft Excel 2010 spreadsheet. 2. Click on cell 'A1' and type in the header for the first half of your set of c...

1. Launch Excel 2007 and open the file you want to spell-check. 2. Click the 'Review' tab at the top of the screen. 3. Click t...

1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add gridlines. 2. Cli...