You can quickly unhide all rows and columns by using control + A to select the entire worksheet, and then using Control + Shift + 0, or Control + Shift + 9, or both.Īlso, remember that you can use Select Special to make more complicated selections before you hide.įor example, to hide all rows that contain the divide by zero error in this table, I can use select special to select the errors, then Control + 9 to hide the rows.įinally, you can hide extra rows and columns to focus attention on just the work area. So for example, I can hide ever other column in this table. When you're hiding and unhiding rows and columns, you can make multiple selections before you use shortcuts. To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9. To unhide columns again, make a selection that spans the hidden columns, and use Control Shift 0.Īgain, you'll see a visual indication in row numbers to indicate that rows are hidden. You can also work with multiple columns at the same time. In this video, we'll cover shortcuts for hiding and unhiding rows and columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |