'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Remove Sidebar or Outline Controls in Excel for Mac
Question details
The user needs to remove an unexpected sidebar or outline controls appearing in an Excel worksheet.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Working on a spreadsheet where an extra sidebar with grouping controls has appeared on the edge of the screen.
- Observed behavior
- An unexpected sidebar featuring plus/minus symbols or numbering controls is visible, indicating grouped rows or columns.
Before making changes, click the plus or minus symbols on the sidebar outline to see which specific rows or columns are grouped and expanding.
Ungroup Data or Clear Outline in Excel
Use the built-in ungrouping feature in the Data tab to remove the outline controls and return the worksheet layout to normal.
Outline controls automatically appear when the Grouping feature is applied to rows or columns. By ungrouping the selection or clearing the outline entirely, you can remove this sidebar without affecting your actual data.
Navigate to the top ribbon in your Excel application and click on the 'Data' tab.
Look toward the right end of the Data tab to find the 'Outline' or 'Group' tools.
Select the grouped area, click 'Ungroup', and choose 'Rows' or 'Columns'. Alternatively, you can select 'Clear Outline' from the menu to remove all grouping from the entire worksheet at once.
Once the unwanted sidebar controls have disappeared, save your workbook to confirm the layout changes.
Clear Outline Controls Effortlessly Using WPS Office
WPS Spreadsheet offers a highly intuitive interface for managing grouped data. You can quickly clear or modify outline controls without digging through complex settings menus.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office on your Mac and open the spreadsheet containing the unexpected outline controls.
- 2. Navigate to the Data tab: Click on the 'Data' tab located in the top main menu ribbon.
- 3. Clear the Outline: Click the 'Group' icon and select 'Clear Outline' from the drop-down menu to remove all groupings and sidebars instantly.
Frequently Asked Questions
Why do outline controls suddenly appear in my Excel worksheet?
Outline controls appear when the 'Group' feature is applied to rows or columns. This can happen intentionally to collapse and expand detailed data, or accidentally if a grouping shortcut was pressed.
Can I hide the outline controls without actually ungrouping the data?
Yes, you can temporarily hide the outline symbols. Go to Excel Preferences on your Mac, select 'View', and uncheck the option to 'Show outline symbols if an outline is applied'.
What is the keyboard shortcut to ungroup rows or columns in Excel for Mac?
You can quickly ungroup selected rows or columns on a Mac by pressing Command + Shift + K. On Windows, the shortcut is Shift + Alt + Left Arrow.
Will clearing the outline delete any of my cell data?
No. Clearing the outline or ungrouping rows and columns only removes the expandable sidebar groupings. Your actual cell content, formulas, and data remain completely unaffected.
