{"id":8900,"date":"2018-06-07T11:58:53","date_gmt":"2018-06-07T09:58:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=8900"},"modified":"2024-02-06T16:14:41","modified_gmt":"2024-02-06T15:14:41","slug":"how-to-use-macro-recorder-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-macro-recorder-in-excel\/","title":{"rendered":"How to Use Macro Recorder in Excel"},"content":{"rendered":"<p>Sometimes we want to automate some steps in Excel to save us time, however it&#8217;s cumbersome to code the exact <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"macro\" data-wpil-keyword-link=\"linked\">macro<\/a> for it &#8211; especially as a VBA beginner.<\/p>\n<p>But you know what?\u00a0 There is an easy way around \ud83d\ude42<\/p>\n<p>You can try out the <strong>Macro Recorder\u00a0<\/strong>to mimic each step inside Excel and reuse those steps next time around.\u00a0 How cool is that?!<\/p>\n<p>Make sure your Excel ribbon has the <strong>Developer Tab<\/strong> enabled following\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-create-your-first-macro-button-in-excel-beginners-tutorial\/\" target=\"_blank\" rel=\"noopener noreferrer\">this tutorial<\/a>.<\/p>\n<p>Turn on the Macro Recorder, do the steps, stop the Macro Recorder, run the Macro and bam! Excel will repeat the exact same steps you just did!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/zkmEP1M-YgU?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Use-Macro-Recorder-in-Excel.xlsm<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Developer &gt; Record Macro<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8902\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-01.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"785\" height=\"193\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-01.jpg 785w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-01-300x74.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-01-768x189.jpg 768w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p>Go with the default name\u00a0<strong>Macro1\u00a0<\/strong>and click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8903\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-02.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"344\" height=\"288\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-02.jpg 344w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-02-300x251.jpg 300w\" sizes=\"(max-width: 344px) 100vw, 344px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Now it&#8217;s starting to record! Here&#8217;s what we want to do:<\/p>\n<ul>\n<li>Select a Cell (A8 in our example below)<\/li>\n<li>Click <strong>Bold<\/strong><\/li>\n<li>Click <em>Italic<\/em><\/li>\n<li>Select the highlight color to be <strong><span style=\"color: #ffff00;\">yellow<\/span><\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8904\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-03.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"417\" height=\"349\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-03.jpg 417w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-03-300x251.jpg 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" \/><\/a><\/p>\n<p>Go to\u00a0<em><strong>Developer &gt; Stop Recording<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8905\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-04.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"697\" height=\"132\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-04.jpg 697w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-04-300x57.jpg 300w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:\u00a0<\/strong><\/span>Now let us try out the macro in action.<\/p>\n<p>Select the rest of the cells that we want to apply the actions on.<\/p>\n<p>Go to\u00a0<em><strong>Developer &gt; <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macros\" data-wpil-keyword-link=\"linked\">Macros<\/a><\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8906\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-05.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"645\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-05.jpg 645w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-05-300x161.jpg 300w\" sizes=\"(max-width: 645px) 100vw, 645px\" \/><\/a><\/p>\n<p>Make sure\u00a0<strong>Macro1<\/strong> is selected and click\u00a0<strong>Run.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8907\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-06.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"520\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-06.jpg 520w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-06-300x209.jpg 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>And it&#8217;s like magic! The same steps are now applied!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8908\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-07.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"173\" height=\"148\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0Let us have a look how that magic was done. Go to\u00a0<em><strong>Developer &gt; Visual Basic<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8909\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-08.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"652\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-08.jpg 652w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-08-300x59.jpg 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<p>Go to\u00a0<strong>Modules &gt; Module1<\/strong>. You can see the code that does the following: Setting Bold, Italic, and filling the color with Yellow:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Macro Recorder in Excel\"  class=\"alignnone size-full wp-image-8910\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09.jpg\" alt=\"How to Use Macro Recorder in Excel\" width=\"1164\" height=\"546\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09.jpg 1164w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09-300x141.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09-1024x480.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/06\/How-to-Use-Macro-Recorder-in-Excel-09-768x360.jpg 768w\" sizes=\"(max-width: 1164px) 100vw, 1164px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>Use Macro Recorder in Excel<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-66.html\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13266\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png\" alt=\"101 Macros Book\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes we want to automate some steps in Excel to save us time, however it&#8217;s cumbersome to code the exact macro for it &#8211; especially as a VBA beginner. But you know what?\u00a0 There is an easy way around \ud83d\ude42 You can try out the Macro Recorder\u00a0to mimic each step inside Excel and reuse those [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17723,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[56,648],"tags":[371,393],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8900"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=8900"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17723"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=8900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=8900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=8900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}