{"id":7686,"date":"2025-04-02T11:00:34","date_gmt":"2025-04-02T05:30:34","guid":{"rendered":"https:\/\/www.notiontechnologies.com\/blog\/?p=7686"},"modified":"2025-04-02T15:44:29","modified_gmt":"2025-04-02T10:14:29","slug":"how-to-unhide-columns-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/","title":{"rendered":"How to Unhide Columns in Google Sheets"},"content":{"rendered":"\n

Sometimes, columns in Google Sheets<\/strong> get hidden accidentally. If you can’t see your data, don\u2019t worry. Unhiding columns in Google Sheets<\/strong> is easy. This guide will show you different ways to unhide columns<\/strong> and restore your sheet.<\/p>\n\n\n\n

Why Are Columns Hidden in Google Sheets?<\/h2>\n\n\n\n

Columns can be hidden for many reasons:<\/p>\n\n\n\n

    \n
  • Someone hid them manually.<\/li>\n\n\n\n
  • The column width was set to zero.<\/li>\n\n\n\n
  • Data filtering may hide columns.<\/li>\n<\/ul>\n\n\n\n

    Knowing how to unhide columns in Google Sheets<\/strong> helps fix these issues.<\/p>\n\n\n\n

    Method 1: Unhide Columns Using the Right-Click Menu<\/h2>\n\n\n\n

    This is the easiest way to unhide columns in Google Sheets<\/strong>:<\/p>\n\n\n\n

      \n
    1. Select the columns<\/strong> around the hidden one. For example, if column B is hidden, select columns A and C.<\/li>\n\n\n\n
    2. Right-click<\/strong> on the selected columns.<\/li>\n\n\n\n
    3. Click “Unhide columns”<\/strong> from the menu.<\/li>\n\n\n\n
    4. The hidden column will reappear.<\/li>\n<\/ol>\n\n\n\n

      Tip:<\/strong> If multiple columns are hidden, repeat these steps.<\/p>\n\n\n\n

      Method 2: Unhide Columns Using the Column Header<\/h2>\n\n\n\n

      Another quick way to unhide columns in Google Sheets<\/strong>:<\/p>\n\n\n\n

        \n
      1. Look at the column letters<\/strong> (A, B, C, etc.).<\/li>\n\n\n\n
      2. If a column is hidden, you\u2019ll see a small double line<\/strong> between the letters.<\/li>\n\n\n\n
      3. Hover your mouse<\/strong> over the double line.<\/li>\n\n\n\n
      4. A left-right arrow<\/strong> will appear.<\/li>\n\n\n\n
      5. Double-click<\/strong> to unhide the column.<\/li>\n<\/ol>\n\n\n\n

        This method works best for a single hidden column.<\/p>\n\n\n\n

        Method 3: Unhide All Columns at Once<\/h2>\n\n\n\n

        If many columns are hidden, follow these steps:<\/p>\n\n\n\n

          \n
        1. Click the rectangle in the top-left corner<\/strong> (between A and 1). This selects the whole sheet.<\/li>\n\n\n\n
        2. Right-click<\/strong> any column letter.<\/li>\n\n\n\n
        3. Choose “Resize columns”<\/strong>.<\/li>\n\n\n\n
        4. Enter a number (like 100) and click OK<\/strong>.<\/li>\n\n\n\n
        5. All hidden columns will now be visible.<\/li>\n<\/ol>\n\n\n\n

          Note:<\/strong> This changes the width of all columns. Adjust them later if needed.<\/p>\n\n\n\n

          Method 4: Unhide Columns Using Keyboard Shortcuts<\/h2>\n\n\n\n

          Keyboard shortcuts make unhiding columns in Google Sheets<\/strong> faster:<\/p>\n\n\n\n

            \n
          1. Select the columns next to the hidden one (e.g., A and C if B is hidden).<\/li>\n\n\n\n
          2. Press Ctrl + Shift + 0<\/strong> (Windows) or Cmd + Shift + 0<\/strong> (Mac).<\/li>\n\n\n\n
          3. The hidden column will reappear.<\/li>\n<\/ol>\n\n\n\n

            Warning:<\/strong> Some keyboards may need different shortcuts. Check your settings.<\/p>\n\n\n\n

            What If the Unhide Option Is Missing?<\/h2>\n\n\n\n

            Sometimes, the “Unhide columns”<\/strong> option doesn\u2019t appear. Here\u2019s why:<\/p>\n\n\n\n

              \n
            • The column isn\u2019t hidden (it may be deleted).<\/li>\n\n\n\n
            • The sheet is protected. Ask the owner for access.<\/li>\n\n\n\n
            • The column width is too small. Try dragging it manually.<\/li>\n<\/ul>\n\n\n\n

              How to Prevent Columns from Getting Hidden<\/h2>\n\n\n\n

              To avoid hiding columns by mistake:<\/p>\n\n\n\n

                \n
              • Double-check<\/strong> before hiding.<\/li>\n\n\n\n
              • Use protected ranges<\/strong> to lock important columns.<\/li>\n\n\n\n
              • Train your team on how to unhide columns in Google Sheets<\/strong>.<\/li>\n<\/ul>\n\n\n\n

                FAQs<\/h2>\n\n\n\n
                Q1. Can I unhide multiple columns at once?<\/strong><\/strong>

                Yes. Select the range around the hidden columns and right-click “Unhide columns”<\/strong>.<\/p> <\/div>

                Q2. Why won\u2019t my columns unhide?<\/strong><\/strong>

                Check if the sheet is protected or if the columns are deleted.<\/p> <\/div>

                Q3. Is there an undo shortcut for hidden columns?<\/strong><\/strong>

                Press Ctrl + Z<\/strong> (Windows) or Cmd + Z<\/strong> (Mac) to undo hiding.<\/p> <\/div> <\/div>\n\n\n\n

                By following these steps, you can easily unhide columns in Google Sheets<\/strong> and keep your data organized.<\/p>\n\n\n\n

                Conclusion<\/h2>\n\n\n\n

                Now you know how to unhide columns in Google Sheets<\/strong> in different ways. Whether you use the right-click method<\/strong>, column headers<\/strong>, or keyboard shortcuts<\/strong>, fixing hidden columns is simple.<\/p>\n\n\n\n

                Need more help?<\/strong> Check Google\u2019s official support page for extra tips.<\/p>\n","protected":false},"excerpt":{"rendered":"

                Sometimes, columns in Google Sheets get hidden accidentally. If you can’t see your data, don\u2019t worry. Unhiding columns in Google Sheets is easy. This guide will show you different ways…<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[],"class_list":["post-7686","post","type-post","status-publish","format-standard","hentry","category-resources"],"yoast_head":"\nHow to Unhide Columns in Google Sheets<\/title>\n<meta name=\"description\" content=\"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Unhide Columns in Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/NotionTechnologies\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-02T05:30:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T10:14:29+00:00\" \/>\n<meta name=\"author\" content=\"Caroline Murphy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to Unhide Columns in Google Sheets\" \/>\n<meta name=\"twitter:description\" content=\"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.\" \/>\n<meta name=\"twitter:creator\" content=\"@notiontech\" \/>\n<meta name=\"twitter:site\" content=\"@notiontech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Caroline Murphy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Unhide Columns in Google Sheets","description":"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Unhide Columns in Google Sheets","og_description":"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.","og_url":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/","article_publisher":"https:\/\/www.facebook.com\/NotionTechnologies","article_published_time":"2025-04-02T05:30:34+00:00","article_modified_time":"2025-04-02T10:14:29+00:00","author":"Caroline Murphy","twitter_card":"summary_large_image","twitter_title":"How to Unhide Columns in Google Sheets","twitter_description":"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.","twitter_creator":"@notiontech","twitter_site":"@notiontech","twitter_misc":{"Written by":"Caroline Murphy","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/"},"author":{"name":"Caroline Murphy","@id":"https:\/\/www.notiontechnologies.com\/blog\/#\/schema\/person\/e3e03eb273f61161a2d803ecf8d50be7"},"headline":"How to Unhide Columns in Google Sheets","datePublished":"2025-04-02T05:30:34+00:00","dateModified":"2025-04-02T10:14:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/"},"wordCount":533,"publisher":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/#organization"},"articleSection":["Resources"],"inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/","url":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/","name":"How to Unhide Columns in Google Sheets","isPartOf":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/#website"},"datePublished":"2025-04-02T05:30:34+00:00","dateModified":"2025-04-02T10:14:29+00:00","description":"Learn how to unhide columns in Google Sheets quickly with step-by-step instructions. Fix hidden columns and organize your data easily.","breadcrumb":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588778239"},{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588806689"},{"@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588817828"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.notiontechnologies.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Unhide Columns in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.notiontechnologies.com\/blog\/#website","url":"https:\/\/www.notiontechnologies.com\/blog\/","name":"notiontechnologies.com","description":"","publisher":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.notiontechnologies.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.notiontechnologies.com\/blog\/#organization","name":"Notion Technologies","url":"https:\/\/www.notiontechnologies.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.notiontechnologies.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.notiontechnologies.com\/blog\/wp-content\/uploads\/2023\/05\/notion-technologies.png","contentUrl":"https:\/\/www.notiontechnologies.com\/blog\/wp-content\/uploads\/2023\/05\/notion-technologies.png","width":336,"height":156,"caption":"Notion Technologies"},"image":{"@id":"https:\/\/www.notiontechnologies.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/NotionTechnologies","https:\/\/x.com\/notiontech","https:\/\/www.linkedin.com\/company\/notiontechnologies","https:\/\/twitter.com\/notiontech"]},{"@type":"Person","@id":"https:\/\/www.notiontechnologies.com\/blog\/#\/schema\/person\/e3e03eb273f61161a2d803ecf8d50be7","name":"Caroline Murphy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.notiontechnologies.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ce57f0ceee12fcdf8b2015d2d3b9e4c2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce57f0ceee12fcdf8b2015d2d3b9e4c2?s=96&d=mm&r=g","caption":"Caroline Murphy"},"description":"Staff Writer. Frequently covers tech, business psychology, social media, startups and digital marketing.","sameAs":["https:\/\/www.notiontechnologies.com"],"url":"https:\/\/www.notiontechnologies.com\/blog\/author\/caroline-murphy\/"},{"@type":"Question","@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588778239","position":1,"url":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588778239","name":"Q1. Can I unhide multiple columns at once?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes. Select the range around the hidden columns and right-click <strong>\"Unhide columns\"<\/strong>.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588806689","position":2,"url":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588806689","name":"Q2. Why won\u2019t my columns unhide?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Check if the sheet is protected or if the columns are deleted.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588817828","position":3,"url":"https:\/\/www.notiontechnologies.com\/blog\/how-to-unhide-columns-in-google-sheets\/#faq-question-1743588817828","name":"Q3. Is there an undo shortcut for hidden columns?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Press <strong>Ctrl + Z<\/strong> (Windows) or <strong>Cmd + Z<\/strong> (Mac) to undo hiding.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/7686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/comments?post=7686"}],"version-history":[{"count":4,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/7686\/revisions"}],"predecessor-version":[{"id":7691,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/7686\/revisions\/7691"}],"wp:attachment":[{"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/media?parent=7686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/categories?post=7686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.notiontechnologies.com\/blog\/wp-json\/wp\/v2\/tags?post=7686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}