Question: In Microsoft Excel 2003, my Excel spreadsheet has numbers for both rows and columns. How do I change the column headings back to letters such as A, B, C, D ...

MS Excel: Columns. In Microsoft Excel, a column runs vertically in the grid layout of a worksheet. Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such 1, 2, 3. Each column in the worksheet has its own column number which is used as part of a cell reference such as A1, A2 ...

In Microsoft Excel, a hyperlink is a link to another location in the same workbook, another workbook, or another application. When the hyperlink is clicked, the user will be taken to the new location. Here is a list of topics that explain how to use hyperlinks in Excel.

Sum Values. Use an array formula to sum values in Column A when value in Column B and Column C match criteria in Excel 2003; Use an array formula to sum values in Column AB when value in Column E and Column AB match criteria in Excel 2003; Use an array formula to sum all of the order values for a given client in Excel 2007; Count Values

A pivot table does not change the original data set. A pivot table a powerful tool that allows you to extract certain data and then summarize the data with calculations such as Sum, Count, Average, Max, and Min. You can configure the column and row headings for the pivot table and then apply any filters and sort orders to the data once your pivot table has been created. There are many things ...

MS Excel: Workbooks A workbook is another name for your file in Excel. It is used to store and work with data. Each workbook contains one of more sheets.