![How to hide and unhide a column in excel](https://kumkoniak.com/65.jpg)
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.omnisecu.com/images/excel/worksheet/hide-columns-from-excel-ribbon.jpg)
When you simply want to hide rows or columns in Google Sheets, use option # 1 below. Here we go! Three Options to Hide and Unhide Rows or Columns and Benefits I may write a few more tutorials in this kind. This tutorial is especially for beginners. There are three different methods actually. I mean, first, you must know the way the rows or columns are got hidden. The unhiding of rows or columns depends on different aspects. With the entire sheet selected, it doesn't matter where in the headings you right-click.There are different ways to hide and unhide rows or columns in Google Sheets. You can then right-click on row and column headings and select Unhide for each. If you'd like to unhide all rows and columns in a worksheet, first, select the entire worksheet. Then, right-click in the row selection and choose Unhide from the menu. Notice the gap in row numbers when rows are hidden.Īs with columns, you need to select rows on both sides of the rows you want to unhide. Or, you can use the right-click menu, which is faster. You can hide and unhide rows using Hide Rows and Unhide Rows in the Format menu. Rows work in much the same way as columns. Then, right-click and choose Unhide from the menu.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://i.ytimg.com/vi/K50cj5INLcw/maxresdefault.jpg)
To unhide the columns, make sure to select columns on both sides of the hidden columns. Select one or more columns, right-click in the selection, and choose Hide from the menu. You can also hide and unhide columns using the right-click menu. Then, choose Unhide Columns from the Format menu. To unhide a column, you need to select columns on both sides of the hidden column. Notice that when a column is hidden, its heading is also hidden, so that there is a gap in the column letters that run across the top of the worksheet.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.dummies.com/wp-content/uploads/205980.image0.jpg)
One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon. Hiding rows or columns is a good way to visually simplify a worksheet without removing important information.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.lifewire.com/thmb/X5TZrVv6e3UDki4AJzOz4qRLYzs=/957x718/smart/filters:no_upscale()/HideColumnRightClick-5c1955b6c9e77c0001af5f98.jpg)
In this lesson, we'll look at how to hide and unhide columns and rows.
![How to hide and unhide a column in excel](https://kumkoniak.com/65.jpg)