{"id":3313,"date":"2023-01-19T20:22:03","date_gmt":"2023-01-19T20:22:03","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3313"},"modified":"2024-01-26T20:42:20","modified_gmt":"2024-01-26T20:42:20","slug":"how-to-unhide-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-unhide-columns-in-excel\/","title":{"rendered":"How to Unhide Columns in Excel?"},"content":{"rendered":"<p>Unhide Columns in Excel is your trusty companion in data visibility and precision. This invaluable feature transcends the confines of hidden data, allowing you to bring vital information back into the spotlight with ease. With &#8216;Unhide Columns in Excel,&#8217; you&#8217;re not just revealing data; you&#8217;re empowering yourself to review, correct, and customize your worksheets with unparalleled accuracy. Embrace the simplicity and impact of this function to ensure that your Excel workbooks are comprehensive, error-free, and tailored to your specific needs. Whether you&#8217;re conducting data reviews, making corrections, or crafting customized reports, &#8216;Unhide Columns in Excel&#8217; is the tool that ensures your data remains accessible and your Excel experience is nothing short of efficient and precise.<\/p>\n<p><strong>\u00a0<\/strong><strong>This Content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#how-to-unhide-the-first-column?\"><strong>How to Unhide the First Column?<\/strong><\/a>\n<ul>\n<li><strong>By Dragging the First Column using Mouse<\/strong><\/li>\n<li><strong>Unhide the First Column using the Go to Option<\/strong><\/li>\n<li><strong>Unhide the First Column using Format Option.<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-unhide-all-hidden-columns?\"><strong>How to Unhide All Hidden Columns?<\/strong><\/a>\n<ul>\n<li><strong>Unhide All Columns Using Right Click<\/strong><\/li>\n<li><strong>Using a Keyboard Shortcut<\/strong><\/li>\n<li><strong>Unhide All Columns by Setting the Column Width<\/strong><\/li>\n<li><strong>Using a VBA Script<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-show-all-hidden-columns-via-go-t\"><strong>How to Show all Hidden Columns Via Go to Special?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-check-a-workbook-for-the-number-\"><strong>How to Check a Workbook for the Number of Hidden Columns?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-disable-unhide-column-option-in-\"><strong>How to Disable Unhide Column Option in Excel?<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"how-to-unhide-the-first-column?\">1.How to Unhide the First Column?<\/strong><\/h2>\n<p><strong>1.1 By Dragging the First Column using the Mouse<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Place the cursor on column B&#8217;s left border. The cursor will turn into a double arrow pointer.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-3314 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-1.png\" alt=\"Unhide Columns in Excel\" width=\"649\" height=\"293\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-1.png 649w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-1-300x135.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click and drag it towards the right to unhide the first column.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-3315 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-2.png\" alt=\"Unhide Columns in Excel\" width=\"647\" height=\"262\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-2.png 647w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-2-300x121.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/p>\n<p><strong>1.2 Unhide the First Column using the Go to Option<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Press the<strong> F5<\/strong> button of your keyboard and then go to <strong>Format&gt;&gt;Hide &amp; Unhide&gt;&gt;Unhide Columns. <\/strong>Column A will be visible again.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-3316 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-3.png\" alt=\"Unhide Columns in Excel\" width=\"467\" height=\"493\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-3.png 467w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-3-284x300.png 284w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/p>\n<p><strong>Step 2: <\/strong>When you click on <strong>Unhide Columns,<\/strong> column A will be visible again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3317\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-4.png\" alt=\"Unhide Columns\" width=\"641\" height=\"282\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-4.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-4-300x132.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><strong>1.3 Unhide the First Column using the Format Option.<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Select and then drag column B towards the left until the border color changes, this means column A is selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3318\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-5.png\" alt=\"Unhide Columns\" width=\"453\" height=\"271\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-5.png 453w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-5-300x179.png 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/p>\n<p><strong>Step 2: <\/strong>From Home tab go to <strong>Format&gt;&gt;Hide &amp; Unhide&gt;&gt;Unhide Columns. <\/strong>Column A will be visible again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3319\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-6.png\" alt=\"Unhide Columns\" width=\"410\" height=\"435\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-6.png 410w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-6-283x300.png 283w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/p>\n<h2><strong id=\"how-to-unhide-all-hidden-columns?\">2. How to Unhide All Hidden Columns?<\/strong><\/h2>\n<p><strong>2.1 Unhide All Columns Using Right Click<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Column A, C, E are hidden in this worksheet. To unhide them click on the triangle in the upper left corner of your table to select all the cells or use <strong>CTRL+A<\/strong> shortcut to select all the cells. Now right-click on any of the column headers. Select <strong>Unhide.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3320\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-7.png\" alt=\"Unhide Columns\" width=\"588\" height=\"388\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-7.png 588w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-7-300x198.png 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/p>\n<p><strong>Step 2:<\/strong> When you select <strong>Unhide,<\/strong> all the hidden columns in this worksheet will be visible again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3321\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-8.png\" alt=\"Unhide Columns\" width=\"638\" height=\"279\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-8.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-8-300x131.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>2.2 Using a Keyboard Shortcut<\/strong><\/p>\n<p>Use <strong>CTRL+A<\/strong> to select all the columns in your worksheet. Now press <strong>ALT+H+O+U+L <\/strong>keys one after another to unhide all the hidden columns in your worksheet.<\/p>\n<p>Unhide all columns automatically with VBA<\/p>\n<p>Show hidden columns that you select<\/p>\n<p><strong>\u00a0<\/strong><strong>2.3 Unhide All Columns by Setting the Column Width<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Select the whole worksheet using <strong>CTRL+A <\/strong>command and from <strong>Home <\/strong>tab go to <strong>Format&gt;&gt;Column Width.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3322\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-9.png\" alt=\"Unhide Columns\" width=\"468\" height=\"291\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-9.png 468w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-9-300x187.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Insert a value which will be large enough to show the columns in the worksheet and click <strong>OK.<\/strong> The hidden columns will be unhidden.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3323\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-10.png\" alt=\"Unhide Columns\" width=\"413\" height=\"233\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-10.png 413w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-10-300x169.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/p>\n<p><strong>2.4 Using a VBA Script<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Right-click on your worksheet name and select <strong>View Code.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3324\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-11.png\" alt=\"Unhide Columns\" width=\"390\" height=\"330\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-11.png 390w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-11-300x254.png 300w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Insert this code given below inside the <strong>VBA Script Box <\/strong>and click on <strong>RUN. <\/strong>All the hidden columns will be visible now in your worksheet.<\/p>\n<p><strong>Sub UnhideAllColumns()<\/strong><\/p>\n<p><strong>\u00a0 Cells.EntireColumn.Hidden = False<\/strong><\/p>\n<p><strong>End Sub<\/strong><\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3325\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-12.png\" alt=\"Unhide Columns\" width=\"628\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-12.png 628w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-12-300x146.png 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><strong id=\"how-to-show-all-hidden-columns-via-go-to-special?\" style=\"font-size: 16px;\">3. How to Show all Hidden Columns Via Go to Special?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Click on<strong> F5<\/strong> key from your keyboard to activate <strong>Go To<\/strong> dialogue box and select <strong>Special.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3327\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-13.png\" alt=\"Unhide Columns\" width=\"367\" height=\"346\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-13.png 367w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-13-300x283.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Select <strong>Visible cells only<\/strong> and click on <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3328\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-14.png\" alt=\"Unhide Columns\" width=\"627\" height=\"393\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-14.png 627w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-14-300x188.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/p>\n<p><strong>Step 3: <\/strong>The whole visible portion of the table will be highlighted, and the adjacent column borders to the hidden column borders will turn whitish.<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3329\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-15.png\" alt=\"Unhide Columns\" width=\"571\" height=\"315\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-15.png 571w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-15-300x165.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><strong id=\"how-to-check-a-workbook-for-the-number-of-hidden-columns?\" style=\"font-size: 16px;\">4. How to Check a Workbook for the Number of Hidden Columns?<\/strong><\/h2>\n<p><strong>Step 1:<\/strong> Go to <strong>File&gt;&gt;Info&gt;&gt;Check for Issues&gt;&gt;Inspect Document.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3330\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-16.png\" alt=\"Unhide Columns\" width=\"645\" height=\"289\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-16.png 645w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-16-300x134.png 300w\" sizes=\"(max-width: 645px) 100vw, 645px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3331\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-17.png\" alt=\"Unhide Columns\" width=\"652\" height=\"406\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-17.png 652w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-17-300x187.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Select <strong>Yes <\/strong>or <strong>No<\/strong> from the dialogue box according to your preferences.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3332\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-18.png\" alt=\"Unhide Columns\" width=\"648\" height=\"108\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-18.png 648w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-18-300x50.png 300w\" sizes=\"(max-width: 648px) 100vw, 648px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Check <strong>Hidden Rows and Columns<\/strong> and select <strong>Inspect.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3333\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-19.png\" alt=\"Unhide Columns\" width=\"414\" height=\"381\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-19.png 414w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-19-300x276.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/><\/p>\n<p><strong>Step 4: <\/strong>As soon as the inspection is over this dialogue box will appear with the inspection result. Here you can see how many columns are hidden in this worksheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3334\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-20.png\" alt=\"Unhide Columns\" width=\"442\" height=\"408\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-20.png 442w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-20-300x277.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><strong id=\"how-to-disable-unhide-column-option-in-excel?\" style=\"font-size: 16px;\">5. How to Disable Unhide Column Option in Excel?<\/strong><\/p>\n<p>If you are working on a worksheet and you have to share this file with someone else for work purposes but don\u2019t want them to be able to unhide columns you have hidden, then follow the steps below to see how you can disable the unhide column option for your worksheet in Excel.<\/p>\n<p><strong>Step 1: <\/strong>Select the whole worksheet by using <strong>CTRL+A<\/strong> command and then right-click. Select <strong>Format Cells.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3335\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-21.png\" alt=\"Unhide Columns\" width=\"629\" height=\"487\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-21.png 629w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-21-300x232.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p><strong>Step 2: <\/strong>From <strong>Format Cells<\/strong> dialogue box select <strong>Protection<\/strong> and uncheck Locked. Click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3336\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-22.png\" alt=\"Unhide Columns\" width=\"490\" height=\"448\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-22.png 490w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-22-300x274.png 300w\" sizes=\"(max-width: 490px) 100vw, 490px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Hold the<strong> CTRL<\/strong> key and select the columns u want to protect from being unhidden and go to <strong>Format cells<\/strong> dialogue box. Check <strong>Locked<\/strong> and click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3337\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-23.png\" alt=\"Unhide Columns\" width=\"643\" height=\"341\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-23.png 643w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-23-300x159.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Select the columns by holding <strong>CTRL <\/strong>key and right click on the column header of any of the selected column. Select <strong>Hide<\/strong> to hide these columns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3338\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-24.png\" alt=\"Unhide Columns\" width=\"644\" height=\"303\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-24.png 644w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-24-300x141.png 300w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/p>\n<p><strong>Step 5: <\/strong>Go to <strong>Review&gt;&gt;Protect Sheet.<\/strong> Check <strong>Select locked cells<\/strong> and <strong>Select unlocked cells. <\/strong>Set a <strong>Password <\/strong>then click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3339\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-25.png\" alt=\"Unhide Columns\" width=\"609\" height=\"441\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-25.png 609w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-25-300x217.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p><strong>Step 6: <\/strong>Type the password again inside <strong>Confirm Password<\/strong> dialogue box and click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3340\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-26.png\" alt=\"Unhide Columns\" width=\"464\" height=\"302\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-26.png 464w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-26-300x195.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/p>\n<p><strong>Step 7: <\/strong>The hidden columns are locked and unhide option will be unavailable for anyone who tries to unhide the hidden columns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3341\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-27.png\" alt=\"Unhide Columns\" width=\"499\" height=\"441\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-27.png 499w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Unhide-Columns-27-300x265.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/p>\n<h2><strong>Application of Unhide Columns in Excel<\/strong><\/h2>\n<ol>\n<li><strong>Data Review<\/strong>:\n<ul>\n<li>Unhide columns to review and verify hidden data, ensuring data integrity and accuracy.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Data Entry Correction<\/strong>:\n<ul>\n<li>Correct errors or update information in previously hidden columns without recreating the entire worksheet.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Customized Reports<\/strong>:\n<ul>\n<li>Unhide specific columns to create customized reports or views tailored to your audience&#8217;s needs.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Data Comparison<\/strong>:\n<ul>\n<li>Compare data in hidden columns with visible data to identify discrepancies or trends.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Print Optimization<\/strong>:\n<ul>\n<li>Unhide columns before printing to include all necessary data in physical or PDF copies of your worksheet.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Formula Validation<\/strong>:\n<ul>\n<li>Check and validate formulas in hidden columns for accuracy and consistency with other data.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Unhiding columns in Excel ensures that you have complete access to your data, allowing for data analysis, correction, and customization as needed.<\/p>\n<p>You may be interested:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Unhide Columns in Excel is your trusty companion in data visibility and precision. This invaluable feature transcends the confines of hidden data, allowing you to bring vital information back into the spotlight with ease. With &#8216;Unhide Columns in Excel,&#8217; you&#8217;re not just revealing data; you&#8217;re empowering yourself to review, correct, and customize your worksheets with &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-unhide-columns-in-excel\/\"> <span class=\"screen-reader-text\">How to Unhide Columns in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[410],"tags":[412,411],"class_list":["post-3313","post","type-post","status-publish","format-standard","hentry","category-unhide-columns","tag-unhide-columns","tag-unhide-columns-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=3313"}],"version-history":[{"count":6,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3313\/revisions"}],"predecessor-version":[{"id":8324,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3313\/revisions\/8324"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=3313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=3313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=3313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}