Can you aggregate in Excel?

The AGGREGATE function in Excel allows applying different aggregate functions like AVERAGE, SUM, PRODUCT, COUNT, COUNTA, MAX, or MIN to a list of data, with an option to ignore hidden rows and error values.

Does Excel 2003 have macros?

Therefore, if you want to run a macro in Excel 2003, the Excel Macro Security Setting needs to be set to Low or Medium. In order to view or alter the Macro Security Setting in Excel 2003: Select Tools> Macro> Security… Select one of the security levels and click OK.

Does Excel 2003 have templates?

Open Excel. New from the main menu. View the templates on your computer. Click Templates on Office Online.

How do I freeze cells in Excel 2003?

To freeze the top row, open your Excel spreadsheet. Select the cell that is below the left-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.

How do I aggregate text in Excel?

Here are the detailed steps:

Select a cell where you want to enter the formula.
Type =CONCATENATE( in that cell or in the formula bar.
Press and hold Ctrl and click on each cell you want to concatenate.
Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.

How do I create a macro in Excel 2003?

How do I enable macros in Excel 2003?

Start Excel.
Click the Tools menu, click Macros, and click Security. The following window will be displayed.
Click Medium (show me)
Click OK.
Open your workbook.
When the Security Warning window displays, click Enable Macros to allow macros in your workbook to run (show me)

How do I enable macros in Word 2003?

Word 2002 (XP) / 2003

Start Word.
Click on Tools and select Options.
Select the Security tab and click on the Macro Security button.
Click on either Medium or High to select it.
Click on OK.
Click on OK again to close out of the options menu.

How do I freeze a column in old Excel?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then under the Window menu, select Freeze Panes.