Click the Office button, and then click Excel Options.
|
|
![Click the Office button, and then click Excel Options.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_t7cjpiFbAmWPLEKpmWdM5TrKK10NwKCPU_BI1YVZThJAtsxLG2w_6r1ct1BCWSHmOR5w900UnRJFsmsOPi8apeGir804hBtZfWakIT1at4fdbhRsTtVevOCeFKuDf_OTgY0yNjGcjyzmpF4FbTUEl_Remps0vk0VaugVXJXt7ZMQxmzsOjR8pt-T6zSyrijrcgj4lVbyJvW2qo=s0-d) |
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
|
|
![In the left pane, click Popular. Select the Show Developer tab in the Ribbon.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_unykFVLmw_or_AMmf_Ceu5iE2NHR7y9JtyI_2oyVaSWWpTNtRBg7e2AtJM1GduPUiS613JhV0DaU5JT3bYmR2RMa5_WSVcSzLPAC08Prz-0iCmyMgtDfUa2QfSp_t18EiPRm3dA4TuEHwb9O08us2oW_07JwK5iik-nTD_xubWiArBArPxqeaSOjERrdK0uGcsRpsXgDGHQSs=s0-d) |
Click the Developer or View tab.
|
|
![Click the Developer or View tab.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sR_LAzmfZ5NuLqXyFYZy44R-a7eMaWQHT8fejGI2_jl4TMWH020uSxGIZXfKh18GunX4t7o_lkqjMjMSV8Wuovygw72bRLM4GCtCHqverkTfI4Rz58n0pHt34xb8Sr84woAxgN-Lqw-OqtkwV2s_2SMVhyQHDKTxGtj1bJWqdwZJkBVtU3LH1Ks35JZYPGAIf5-Q=s0-d) |
To record a macro with actions relative to the
initially selected cell, click the Use Relative References button.
|
|
![To record a macro with actions relative to the initially selected cell, click the Use Relative References button.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_svW0IPtlVl0oe0N1_YNbCSQyRuiE-DttKXfxcsyNajhouI0zJ9MDHRhp8EUEqN1d5Lo8or3HXj0WVV3aCSrzbOr2cxAv5BKjcMyrtXZeaYfl0xXiX3Fv0XcFhzD3HNSFbQUwY4av2bS_QjbivK4_Y5ioNlQVco8BSjSxeR-zQESyglS0GTn1MlS36sIxIFw4Wi4ocvATklNBw=s0-d) |
Click the Record Macro button.
|
|
![Click the Record Macro button.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uek8Fj-kgTEmFN-6f_Nzy8BMlh0gAZeoXz5faHyW9DODpCQQY3b8xwBeAsM3Ki1NDn24ZcI5Zg_0C6xeeYkJPMcvATla_37GYeDPi0hWOVnnY29OBgC-tUbUxEqzlZRKorieloRFRbmMg_7VFSMw--XU9-GcKrP2zF9yvij2Hy4rOcjxYqhue3TuLqAsnWTA=s0-d) |
Type a name for the macro. Assign a shortcut key to run the macro.
|
|
![Type a name for the macro. Assign a shortcut key to run the macro.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_t2-vZi3r7ZWO5lqQKO3hFvMqt1c45QyISGDRdB-vpigVEjuSJ8G9BCJMtvwwqGUKsqyQEn4TeXnHaKHTQ__I5IPU1s7mUvlrqqRxpJ92JnRS8t-T5JWrPirWVShW6sA3dOkuSGN7hqFTJf2qheBCpnSyc4U9-_7biZKOuSQ0pgGfbSKx08ySpy--A5KzdEyQaeCDtLbLAVByu0=s0-d) |
Click the Store macros in list arrow, and then select: Personal Macro Workbook to use the macro whenever you use Excel. New Workbook to use the macro in new workbooks. This Workbook to use the macro only in this workbook.
|
|
![Click the Store macros in list arrow, and then select:](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_slMVDNKjCNkBo0OPB8FvBbxcCxI3zuloFGhs-LyVOT5Zq4HH9XE05IlgfanaH44TMIzweiN5g-3i_Elz9x6pKep9szrv-zagxwEFiwK7bPYKLipVGnh7emM-5mX5NAkva4wz6K-eyd76st49O0OMFbX3AKhAusrmxuN3dKb1GW78XolqdpOc88J0tkR9NmxozmGsZz1kKJHCae=s0-d) |
Type a description. Click OK.
|
|
![Type a description. Click OK.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uW2rqtwISs8DtOrG5jIHrnNRz3d-qwqidzz0NQhNO6Ik0gIUaxFfqlaKYH39Xr6GLhlcGHNWAF97UljQ5N0aTtM3DaSyRw730PQtzjSX442Mk0lCq3FdegGDdnnJg99VBqXp1q2CwEMc3isJxXGOMWrmR7_FHlqEp9LdcAc-0EkN5j_b8Jgn9w-ZByJ84Xkg=s0-d) |
|
![Execute the commands.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_t08_FPMuMq5E0nnF8MCdwr3XGtG7PElTH9oPPWfbEd8fbNMS71XUqEms3zlfO4VItpNbmwGgu86i6SS_CbNxNvdN06nSrxqeT39GsnADrUV17jP1PNTxuk9QpHRK-yOqlm9EIBinZnpzgrI8_ofCyL60ALmomyM4_oVMOu5-9AMD_FU5VI5A=s0-d)
Click the Stop Recording button |