How to hide columns and rows in Excel

If your Excel spreadsheet has data that cannot be deleted, but you don’t want it to appear or have the same prominence as the others, a good option is to hide that information. To do this, see how to hide Excel columns and rows quickly and easily, and also learn to show them again when needed.

Time required: 2 minutes.

Here’s how to hide columns (steps 1 and 2) and how to hide rows (steps 3 and 4) in Excel, either on Windows, macOS, or via the web:

  1. Select the columns you want to hide:

    To select a column, click on its corresponding letter, located at the top of the column. To select multiple columns that are next to each other, click on the letter of the first one and drag the cursor over the others. To select multiple columns that are not next to each other, click the letter of one of them and hold down the Ctrl key while clicking the letters of the others;

  2. Hide column:

    Once the columns have been selected, right click on any of their corresponding letters (located at the top of the columns) and click on the “Hide columns” option. Done, the selected columns will be automatically hidden;

  3. Select the lines you want to hide:

    To select a line, click on its corresponding number, located to the left of the line. To select multiple lines that are next to each other, click the number of the first and drag the cursor over the others. To select multiple lines that are not next to each other, click the number of one of them and hold down the Ctrl key while clicking the numbers of the others;

  4. Hide the line:

    Once the lines are selected, right click on any of their matching numbers (located to the left of the lines) and click on the “Hide lines” option. Done, the selected lines will automatically be hidden.

How to re-show a column or row that has been hidden

Even if you did not hide an Excel column or row, note that it is easy to find out if there are items like this in an editor file, since the corresponding letter or number disappears, leaving their alphabetical or numerical order incomplete. Also, where the column or row was hidden, the grid line (the row that separates cells in a worksheet and has a more subtle hue) becomes double.

Given this information, there are two ways to redisplay an Excel column or row (and they may vary depending on which editor you use). For the first, do the following:

  1. Select the columns or rows adjacent to the item that was hidden;
  2. Right-click on the letter (for column) or number (for row) of one of them and click the “Redisplay Columns” or “Redisplay Rows” option.

Another option to show this data again is to follow the steps:

  1. Pause the mouse over the double grid line that was formed where the data was hidden and notice that the cursor appears with a division in which there is an arrow for each of its sides;
  2. Drag the cursor slightly to the side where the column or row was hidden (keeping your view with the arrows) and click on its letter or number to make the item appear again.

Leave a Comment