Advertisement If you’re dealing with a data-heavy spreadsheet, sometimes it’s helpful to hide or unhide rows and columns to better see the information you need to analyze. Fortunately, Excel makes it easy to do this. How to Hide Columns and Rows in Excel • Select the column(s) or row(s) you want to hide. You can select multiple columns or rows that are side-by-side by holding down the Shift key, otherwise you can select multiple cells by holding down the Control key ( Command on Mac).

• You can also type in the row or column identifier in the name box to the left of the formula field, so if you want to hide the second row, for example, type B2. • Once you’ve made your selection: • In the Home tab under the Cells group, click Format > Hide and Unhide > Hide Rows or Hide Columns. • Or you can right click on the Excel worksheet in the column or row you want to hide and click hide. (This method will not work if you’ve typed in the row or column identifier.) • The column or row will be removed, and you’ll see a thin double line indicating where the hidden column or row was. How to Unhide Columns or Rows There are a few ways to select which rows or columns you want to unhide: • Right click the thin double line indicating a hidden row or column and click Unhide.

For row height. Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width.

• Click on the thin double line indicating a hidden row or column to select it. If you want to unhide all rows or columns, select all using the keyboard shortcut Ctrl or Command + A. In the Home tab under the Cells group, click Format > Hide and Unhide > Unh ide Rows or Unh ide Columns.

Adobe premiere free download+mac os x. Overall, there is no doubt that Adobe Premiere Pro CC is an incredibly powerful tool, there is a learning curve, but its worth it in the end. Features Include: • Industry Standard Software • Add Colour Effects and Looks • Intuitive Graphics Workflows • Immersive 360/vr Video and Audio Editing • Auto-duck Music • Compatible With Footage of Any Format and Resolution Adobe Premiere Pro CC steps it up to a level above its competitors by creating synergy with Adobes other Creative Cloud applications, allowing users to easily switch between them or manage team projects.

While you can hide or unhide either multiple rows or multiple columns at the same time, you can’t hide or unhide both rows and columns simultaneously. What are your favorite Excel productivity tips? Let us know in the comments. Explore more about:.

In this video, we'll cover shortcuts for hiding and unhiding rows and columns. To hide columns, use Control + 0. When you do this, you'll see the columns on either side bolded as a visual indicator that columns are hidden. You can also work with multiple columns at the same time. To unhide columns, make a selection that spans the hidden columns, and use Control Shift 0. To hide rows, use Control + 9. Again, you'll see a visual indication in row numbers to indicate that rows are hidden.

To unhide rows, make a selection that spans hidden rows, and use Control Shift 9. When you're hiding and unhiding rows and columns, you can make multiple selections before you use shortcuts. So for example, I can hide ever other column in this table. Or every other row.