Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Hiding Outline Symbols.
Written by Allen Wyatt (last updated May 25, 2019)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
Once you go through the process of outlining your data, you may want to hide the outline symbols that Excel normally displays at the left of the worksheet area. These symbols are helpful as you are working with the data but may be distracting if you are presenting the data to others. To turn off the symbols, follow these steps:
Figure 1. The Advanced options of the Excel Options dialog box.
To again display the symbols, follow the same steps, but make sure the Show Outline Symbols check box is selected.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9269) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Hiding Outline Symbols.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Outlining, a feature built into Excel, can be a great way to help organize large amounts of data. This tip provides an ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.