Select the View ribbon. Under Macro (on the right side of the toolbar) choose Record Macro.
The help in Excel (the question mark top right) for RECORD MACRO gives much more help. The first hit: http://office.microsoft.com/en-us/excel-help/save-time-by-creating-and-running-macros-in-excel-2010-RZ102337714.aspx?CTT=1
Didnt' you install the help?
I am in the process of moving from Excel 2003 to Excel 2010
In Excel 2003, I have added a custom button to the toolbar called 'T1', and recorded a macro called temp1.
This macro is then assigned to button 'T1'
(I also have T2 - T10, but if I can create one I suspect I can create them all)
So if I record a sequence of actions to a macro called temp 1, I can replay these actions with a single click of button 'T1', which is really useful if I have to do the same edits to 10 identical spreadsheets.
How can I replicate this in Excel 2010?