About this tutorial: Video duration: 6:43 How to freeze rows and columns in Excel (for Mac 2011) even if it is grayed out. The trick if it is grayed out: go to View, then choose “Normal” view (it does not work in Page Layout). Freezing panes in Excel for Mac will help with keeping things organized aka, keeping yourself sane while working through excel spreadsheets. This video is only freezing panes in Excel for Mac 2011.
To remove grouping for certain rows without deleting the whole outline, do the following: Select the rows you want to ungroup. Go to the Data tab > Outline group, and click the Ungroup button. Or press Shift + Alt + Left Arrow which is the Ungroup shortcut in Excel. In the Ungroup dialog box, select Rows. Mar 21, 2014 Excel 2007: Grouping of Rows is not working! Become a Registered Member (free) to remove the ads that appear in thread area. Click here to reset your password.
![Rows Rows](/uploads/1/2/5/3/125391962/898470118.gif)
Hope this is helpful ? Incoming search terms:. Categories: / / by August 30, 2016.