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_sxKuSLDK9ka1JB0vq3AGQHULAoexvKE2D7BRQnL4NZAxyVok9HWWe9Bcmy3rsZlsX4LCBdIBO8QyYn_YEAei2JSbJrjcpuqhE_zyqhWu4C_F4NUtIbeZX9Kn8E-WSY1XBBMeMnpqdWfM3JwPOVkHxKlzJVhi5S70xU95w1sOd_-TgRkQwsaA-PnbECXD8X9XWHbA=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_trm7MfC-Kb1T1wDCbVRcRGKNNwblyYm4deSbefrfTjNGqgSoufPg5axTC7E2r-91qZybBPL-5oWCvN1T8tOMfMPrIn0xgoNnVzD7IeEUFlhuOVKp_skybiXroOycN_kzONLTGsIyyrsQ9AsPZiHvhDjbRhDTII-1i25J1LQPpElo1DAVL7ez1-6PtuxbVBeA=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_vcDmQZOK9muASJ74PZZCY1oewYMhDBf5Zi3FagA_bMSoO84-Jr6R6IxC4J862QOA83DOInzCGwMZZ8lEf1C6NjLzWrgjWqXZ8f2Hlc9rwG0ADFYASgPbGlePeJnEfE-kZYlm4rfeklVRmmNa_9XiW-0Lo3NQtbDOCUqiLzCCIXJ5wjw5udIQ_xq4nvy3KMT6lWa1RXa96nYBXb=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 |
No comments:
Post a Comment