For this, firstly find that hidden row and then unhide it. Hence, it is a good way to unhide the individual row specifically. Sometimes an Excel sheet contains only one or two hidden rows. Unhide the row by increasing row heightĮach of these methods works differently to achieve the same result.You can unhide the row however you want, either individual row, all row at once, or only first row. Methods to unhide rowsĮxcel offers several methods to unhide the hidden rows in different ways. Hence, you do not need to find and unhide each hidden row one by one. Excel enables the method to enable all hidden rows at once without knowing hidden rows. In that case, you can directly use " unhide all rows" method instead of finding hidden rows. Thus, it will be a time-consuming process to find all the hidden rows one by one. Because, it might be possible that more than one row is hidden at different places. This can be a hectic and lengthy process to find each hidden row in the entire worksheet. You will also see a double line where a row is hidden. You can go for the row number and check which number is skipped.įor example, if the number 5 6 is not showing between 4 and inside row numbers, it means row5 is hidden. To unhide any specific row, you should know that which row is hidden.
We will describe all the possible methods in this chapter. For example, you can unhide individual rows, multiple rows, or all hidden rows at once. So, whenever you do not want to show the data of a particular row or column, you need to unhide them.Įxcel enables several ways to unhide the rows. When a row is hidden, its data does not display to the users.
Excel allows the users to hide and unhide the rows of an Excel spreadsheet. This chapter is based on unhiding the rows in Excel.
#UNHIDE FIRST COLUMN IN EXCEL 2007 HOW TO#
Here we have discussed different methods of unhiding columns in Excel like Using a Mouse, using VBA code, Using Key Board Shortcut, etc.Next → ← prev How to unhide rows in Excel? This has been a guide to Unhide Columns in Excel.
#UNHIDE FIRST COLUMN IN EXCEL 2007 CODE#
This is just a click of the button once the code has written.Ĭopy and paste the below code to your module in the Visual Basic Editor Window. Step 3: Once you double-clicked, it will unhide all the hidden columns in the range.įinally, automate the unhiding columns task by using VBA code. Double click on there, and your hidden columns will be unhiding. Step 2: Place the cursor in between column B and column F. This suddenly unhidden my hidden columns. One day I was working on excel suddenly I adjusted the column width by selecting the hidden columns ranges. Unhide Columns in Excel by Adjusting Column Width This looks like the first method, but it is good to know all the methods to become a master. Step 3: Once you click on this, it will unhide all the hidden columns. Step 2: Go to Home tab > Format > Hide & Unhide > Unhide Columns Step 1: Select the entire range you want to unhide. This method requires a lot of your time than the previous two methods. Unhide Columns in Excel Using Format Option Instead of unhiding columns, it will hide columns. Note: You can use Ctrl + 0 to unhide the columns, but this may not work in many operating systems. Step 3: This will unhide the hidden columns instantly. Step 2: Press the key board shortcut ALT + H + O + U + L. I have selected the columns from A to F because totally there are 3 columns hidden in this range.
The reason why I told you this is because we can unhide all the columns using a keyboard shortcut. That word still playing in my mind all the time when I open an excel sheet. They told me if you want to learn or masters excel, you need to forget that you have a mouse you should know everything on the keyboard itself. There was a golden word from one of my seniors at the start of my career. Unhide Columns in Excel Using Key Board Shortcut Now we can see the entire column in the worksheet, right from column A to G. Note: All another hidden column other than in the range of A to G remains hidden only.