{"id":293,"date":"2015-02-22T19:13:53","date_gmt":"2015-02-22T11:13:53","guid":{"rendered":"http:\/\/excelchamp.net\/?p=293"},"modified":"2022-07-11T06:27:39","modified_gmt":"2022-07-10T22:27:39","slug":"show-first-hidden-column-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/show-first-hidden-column-in-excel\/","title":{"rendered":"Showing The Hidden First Column in Excel"},"content":{"rendered":"

It is quite easy to show or hide columns in Excel. Simply select a column, and press Control + 0 . The column is hidden from the view. You can make it out because of a dark line separating the columns. If you hide the B column, you will only see column A & Column C, and it is apparent that column B is hidden.<\/p>\n

To unhide, simply select both column A & Column C. Then right click and select Unhide. Column B is brought back into view.<\/p>\n

This works great most of the time. And it works in showing or hiding rows too.
\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Want to Improve Your Excel Skills?<\/strong><\/span><\/p>

Learn the Key Features of Excel Quickly & Easily, by <\/span>Joining the
Online Training<\/strong> on <\/u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p>

To Get Most out of Excel, Learn the\u00a0 Pivot Table techniques in our
Pivot Table Masterclass Training<\/a><\/u><\/b>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t
\nBut the problem arises when you want to hide the first column – Column A. Now it is difficult to select 2 adjacent columns, and you are unable to Unhide Column A.<\/p>\n

Steps to Display the Hidden First Column (Column A) in Excel<\/strong><\/p>\n

    \n
  1. Press F5<\/strong>. The Go To<\/strong> dialog box will popup.<\/li>\n
  2. Key in the cell A1<\/strong> in Reference<\/em>, and press Enter.<\/li>\n
  3. The cursor would have moved to the cell A1, even if you can not see it. Do not worry.<\/li>\n
  4. Now go to the Home<\/strong> Tab (in Excel 2007, 10 & 2013<\/em>)<\/li>\n
  5. Click on Format<\/strong> button – it is near the far end of the screen… toward the right side of the ribbon.<\/li>\n
  6. Choose Visibility > Hide & Unhide<\/strong>. Then select to Unhide Columns<\/strong>.\n

    \"Unhide<\/a>
    Unhide columns or Rows in Excel<\/figcaption><\/figure><\/li>\n
  7. Voila! You will now be able to see the column A. It has been un-hidden.<\/em><\/li>\n<\/ol>\n

    It is a simple trick. Excel is all about simple tips and tricks… The more you practice, the more you try, the more gold shall ye find!<\/p>\n

    Cheers,
    \nVinai Prakash
    \n\t\t

    \n\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Are you facing any problem in using Excel? Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    You have come to the right place<\/span>. Tell us your needs. We’ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t\n\t\t\t\n\t\t\t\n\n\t\t\t\n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t