{"id":7273,"date":"2026-04-22T09:50:42","date_gmt":"2026-04-22T00:50:42","guid":{"rendered":"https:\/\/dandelions.co.jp\/blog\/?p=7273"},"modified":"2026-04-22T09:50:42","modified_gmt":"2026-04-22T00:50:42","slug":"engineers-blog-creating-an-excel-macro-move-to-cell-a1-and-set-zoom-level-to-100","status":"publish","type":"post","link":"https:\/\/dandelions.co.jp\/blog\/blog\/2026\/04\/22\/engineers-blog-creating-an-excel-macro-move-to-cell-a1-and-set-zoom-level-to-100\/","title":{"rendered":"Engineer’s Blog: Creating an Excel Macro (Move to Cell A1 and Set Zoom Level to 100%)"},"content":{"rendered":"\n

Hello! I\u2019m Hirotomaru, and I\u2019m writing this article.
In this post, I\u2019ll show you how to use an Excel macro to \u201cjump to cell A1 and reset the zoom level to 100%.\u201d
You may have experienced situations where your scroll position or zoom level gets saved incorrectly, making the file hard to read the next time you open it. This macro makes it incredibly convenient to perform this action with just one click.<\/p>\n\n\n\n

I will explain the steps for creating a macro shortcut button.<\/p>\n\n\n\n

Show the Development tab<\/h2>\n\n\n\n

First, display the \u201cDeveloper\u201d tab to use macros.<\/p>\n\n\n\n

  1. Click \u201cFile\u201d in the upper-left corner<\/li>
  2. Select \u201cOther\u201d \u2192 \u201cOptions\u201d<\/li>
  3. Open \u201cRibbon Customization\u201d<\/li>
  4. Check the \u201cDevelopment\u201d box<\/li><\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Create a macro<\/h2>\n\n\n\n

    1.Click \u201cRecord Macro\u201d on the \u201cDeveloper\u201d tab<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    2.Enter the macro name, select \u201cPersonal Macro Workbook\u201d under \u201cSave macro in (I)\u201d, and click \u201cOK\u201d<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    3.Without doing anything, click \u201cStop Recording\u201d<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Paste the code<\/h2>\n\n\n\n

    Open the \u201cVisual Basic\u201d section in the Development tab and paste the following code into the Standard Module.
    Delete all existing text, and replace \u201cSub MacroName()\u201d on the first line with the macro name you entered when you created it.
    Once you’ve pasted the code, save and close the file.<\/p>\n\n\n\n

    Sub A1 Shortcut()<\/p>\n\n\n\n

    \u2018 Disable screen updating (to prevent screen flickering)
    Application.ScreenUpdating = False<\/p>\n\n\n\n

    Dim ws As Worksheet<\/p>\n\n\n\n

    Process all sheets in order
    For Each ws In Worksheets<\/p>\n\n\n\n

    ‘ Select a sheet
    ws.Select<\/p>\n\n\n\n

    ‘ Move to cell A1
    Range(\u201cA1\u201d).Select<\/p>\n\n\n\n

    ‘ Reset the display position to the top-left
    ActiveWindow.ScrollColumn = 1
    ActiveWindow.ScrollRow = 1<\/p>\n\n\n\n

    ‘ Set the display zoom level to 100%
    ActiveWindow.Zoom = 100<\/p>\n\n\n\n

    Next ws<\/p>\n\n\n\n

    Return to the first sheet
    Sheets(1).Select<\/p>\n\n\n\n

    Resume screen updating
    Application.ScreenUpdating = True<\/p>\n\n\n\n

    \u2018 Completion message
    MsgBox \u201cProcessing is complete\u201d<\/p>\n\n\n\n

    End Sub<\/p>\n\n\n\n

    In this case, I pasted the code into Module 7 of the standard modules.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Add to Favorites<\/h2>\n\n\n\n

    Add to Shortcuts Since you can\u2019t run the macro with a single click as it is, let\u2019s add it to the Quick Access Toolbar so you can run it immediately.<\/p>\n\n\n\n

    1. Open the Quick Access Toolbar settings<\/li>
    2. Select the macro<\/li>
    3. Add the macro you created (A1 Shortcut) and click OK<\/li><\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      You can run it with a single click using the button in the upper-left corner.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Summary<\/h2>\n\n\n\n

      By setting up the macro we\u2019ve introduced here, you can easily reset the view position and zoom level for each sheet to their default settings. Since it can be executed with a single click, I believe it will help streamline your work. Please give it a try.<\/p>\n\n\n\n

      Stay tuned for our next engineer blog post!!<\/p>\n","protected":false},"excerpt":{"rendered":"

      Hello! I\u2019m Hirotomaru, and I\u2019m writing this article.In this post, I\u2019ll show you how to use an Excel macro to \u201c … <\/p>\n

      “Engineer’s Blog: Creating an Excel Macro (Move to Cell A1 and Set Zoom Level to 100%)” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[8],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paR9rw-1Tj","_links":{"self":[{"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/posts\/7273"}],"collection":[{"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/comments?post=7273"}],"version-history":[{"count":1,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/posts\/7273\/revisions"}],"predecessor-version":[{"id":7276,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/posts\/7273\/revisions\/7276"}],"wp:attachment":[{"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/media?parent=7273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/categories?post=7273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dandelions.co.jp\/blog\/wp-json\/wp\/v2\/tags?post=7273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}