Select the range of Columns or Rows you would like to Ungroup.ĭid you like this step-by-step tutorial? We've got a great video, 10 Microsoft Excel Aha Features You Need to Know.Not only are your columns or rows hidden but Excel has added show hide buttons to help you toggle your view: Click the Group button located on the Data tab / Outline group then choose.Select the number of contiguous columns or rows you are interested in hiding (you cannot use the Control key during this operation).On the View tab, click Freeze Panes > Freeze Panes. Grouping only works with Columns and Rows that are contiguous (together). In case you want to lock several rows (starting with row 1), carry out these steps: Select the row (or the first cell in the row) right below the last row you want to freeze. The following steps below outline how to use the Group option in Excel for versions 2007, 2010, 2013, and 2016. Hide and Unhide Columns and Rows Using the Group Feature From the View Ribbon, select Freeze Panes, which will bring up a dropdown menu. Click on the Format button located under the Home tab / Cells group then choose Unhide Columns or Rows (another option is to drag over the range of columns or rows you are interested in unhiding then Right click in the column or row heading and choose unhide). Click on the View tab from the main menu.Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide).Select the number of columns or rows you are interested in hiding (use the Control key to select additional noncontiguous columns or rows).Below I have outlined a couple of time-saving ways to hide and unhide your Excel columns and rows. Better yet, if they are contiguous you can use Excel's Grouping tool. One thing you might not be aware of: you can hide and unhide more than one column or row, at the same time, even if they are non-contiguous. There are several ways to hide and unhide columns and rows in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |