How To Unhide Columns in Google Sheets With 3 Methods

Step-by-step tutorials on how you can unhide columns in Google Sheets on both your desktop and smartphone! Well take you through the toggle and right-click options.EtEtty EtQuam VeroRepudiandaeExpedita Culpa

Sometimes you have to hide certain columns in Google Sheets to make it easier for you to read and analyze the data in spreadsheets. Now comes the time that you are looking for certain information that you are pretty sure is written inside the spreadsheet. But you can’t easily find it! You realize that you have hidden the column where that information is located! How can you unhide that column again?

To unhide the hidden columns in your selection, right-click the letter for any selected column and choose “Unhide Columns” from the menu. And instantly, Google Sheets will display all your previously-hidden columns. You’re all done.

Google Sheets – Hide, Unhide, Group, Ungroup Columns or Rows

How to unhide columns in Google Sheets using the arrow method

On a desktop or laptop computer, you can use the following steps to help you unhide columns in Google Sheets:

1. Find the hidden columns

Finding the hidden columns in a Google Sheet is the first step in unhiding them. When you are looking at the spreadsheet, you may notice the names of the columns are letters “A, B, C, etc.” You can use these letters to see if there are any hidden columns. As you look through them, if you notice that two columns skip a letter, there is likely a hidden column there. Another indicator is if there are two small arrows, one that points to the right and one that points to the left.

2. Find the small arrows pointing right or left

After you find the hidden columns on a spreadsheet, you may notice two small arrows on either that point left and right. These arrows act as a visual indicator of a hidden column and a way for you to interact with that column. They are also clickable, meaning you can use them for the next step.

3. Click on one of the small arrows

Clicking on one arrow unhides the columns that hide toward that arrow. If an arrow points to the right, a column is hiding before the one where the arrow is pointing. The arrow that points left shows a column that is hidden after the column where that arrow is pointing. Using these arrows can make sure that you unhide all the hidden columns.

What’s the purpose of hiding and unhiding spreadsheet columns?

Hiding columns and rows in spreadsheets can help you more quickly find the important information and minimize the amount of information on the screen. Many data professionals hide columns that dont have information relevant to them, such as the names of team members when they need information on output. They may also want to unhide columns if they need information in them. In Google Sheets specifically, the ability to collaborate on the same document means different people may want to hide or unhide columns as they work.

How to unhide columns in Google Sheets with the right-click function

Another way that you can uncover hidden columns is by using the right-click functionality of Google Sheets. Below are steps that may help you unhide the columns in your spreadsheet:

1. Find the hidden columns

Just like in the previous method, to unhide the columns that you have, you can find them by looking for skipped letters in the sequence of columns. You can also look for the small arrows the show hidden columns in the spreadsheet. Once you find the hidden columns, you are ready to move on to the next step.

2. Select the columns on both sides of the hidden columns

After you find the hidden columns, you can select the rows on either side of the hidden column. To do this, you can click and hold the left mouse button on the name of the column, “A, B, C, etc.” After you select the columns on either side of the hidden one, you can move on to the next step.

3. Right-click on the column names bar above the selected columns

With the columns selected, right-click and a drop-down menu can appear. This column begins with the option “Cut” and ends with the option “Column Stats.” About one-third of the way down this list of options, you may see the “Hide Columns” and “Unhide Columns” options. Once you see these options, you can move on to the next step.

4. Click “unhide column” from the drop-down menu that appears

Once you find the “Unhide Columns” option and click on it, Google Sheets unhides the entire range of columns that were previously hidden. After you select this option, you can check to ensure that the columns you wanted to unhide are there. You can do this by looking at the names of the columns and making sure they are sequential. Once you have confirmed your column is there, youve successfully unhidden columns on your spreadsheet.

How to unhide columns in Google Sheets on a smartphone

The process is relatively similar on smartphones as it is on computers. One slight difference is that you can only select one column at a time. Because of this, the steps to unhide columns in this way are different:

1. Find the hidden columns

The Google Sheets app allows you to make small edits and look at your spreadsheet on your smartphone. Using this method, you can look for missing columns in the same way as the other methods. You may see two small arrows that show a hidden column or notice a skipped letter. Once you find the hidden columns, you can move on to the next step.

2. Locate the small arrows on the columns to either side of the hidden column and tap one

Finding the small arrows may be tricky because of the size of your smartphone, but once you find them, they are useful for unhiding columns. Once you find the small arrows, you can tap on one to unhide the columns. Doing this expands the spreadsheet to include the columns you want. You can double-check that you uncovered the columns by looking for the small arrows and skipped letters in the column names section of the spreadsheet.

Please note that none of the organizations or products in this article are affiliated with Indeed.


How do I unhide columns and rows in Google Sheets?

How to Unhide Rows in Google Sheets (for larger datasets)
  1. Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet.
  2. Next, right-click on your selection.
  3. If you have any rows hidden in the sheet, you should see a menu option that says “Unhide Rows”.

How do I make columns visible in Google Sheets?

To pin data in the same place and see it when you scroll, you can freeze rows or columns.
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column you want to freeze or unfreeze.
  3. At the top, click View. Freeze.
  4. Select how many rows or columns to freeze.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *