Microsoft Excel has been one of the best database handling applications since decades and it has achieved this position in its own unique style. Microsoft Excel has a spreadsheet style for storing information and data and this data can be viewed, reviewed and altered at the same place. No need to write lengthy codes or queries for doing the same as we do in most of the other database applications. Excel simply saves and keeps the data in tabular format which is very well visible in its file called as workbooks. Each workbook has 3 worksheets by default and more worksheets can be added or deleted anytime while working on the workbook. Excel has given a whole new dimension to tradition log keeping and now people seldom use the big and heavy registers for keeping track of various things and have started using Microsoft Excel.
The reason why Excel gained such a massive acceptance is because of its easy to use interface and its customizable approach towards information display. You can create table and display your data, you can perform calculations on the data which you have, you can create reports right next to the data, and you can even create illustrative charts and graphs on the data you have in your worksheet. Excel gives it users liberty to color cells and range of cells individually for better presentation and users can even hide resize the rows and columns as according to the requirement. In this post we will discuss about how to unhide a column if it is hidden. Before we go to the steps we should know how to know if a column is hidden? It is simple. In Excel columns are sequentially named starting from Letter A, B, C, D and so on. Now for example if you see that column D and F are visible but E is not then it means that column E is set to be hidden. The same can happen with multiple columns.
Steps to unhide specific columns in Microsoft Excel 2003
Use the bottom scroll bar and scroll to the point in your worksheet where you know the hidden column(s) are.
Select the Left and the Right columns where you know the hidden column is. For example if column C is hidden then select column B and column D.
Right click on the Column name and then click on Unhide Column option from the context menu.
Now, you will see that the column which was earlier not visible because of its hidden properties is visible now and ready for alteration.
Steps to unhide all columns in Microsoft Excel 2003
Press Ctrl+A to select all the cells of your worksheet
Right click and then select Unhide from the context menu that appears.
Now, you will see that all the columns and rows which were earlier hidden have turned visible now and can be altered.