basgive.blogg.se - How to unhide a column in excel 2010

The rows 2,3,5 and 7 numbers are now hidden.įor hiding the columns in specific sheet, select the columns you want to hide. Upon click it will automatically hide the selected rows. Now from Hide & Unhide options, click Hide Rows. Selection hold Ctrl key) you want to hide and navigate to Home tab.įrom Cells group, click Format button. In desired spreadsheet select the rows (for multiple non-contagious

Right click on one of the selected rows.

Continue to hold down the CTRL key and left click on the rest of rows to be hidden.

Press and hold down the CTRL key on the keyboard.

In the row header left click on the first row to be hidden.

The selected rows and row numbers will be hidden from view.įor example, you want to hide rows 3, 5, and 7.

In the row header drag select to highlight all of the rows you want to hide.

The selected row and the row number will be be hidden from view.įor example, you want to hide rows 4, 5, and 6.

Right click on the row header of the row to be hidden.When you hide a row in a worksheet, data in that row can still be used and referenced in the worksheet. The row header is the gray bar along the left edge of the worksheet containing the row numbers. These instructions show you how to hide rows by right clicking on the row header. As with all things Microsoft, there is more than one way to hide rows in an Excel worksheet.