Last Modified Date: 04 Jan 2018
ResolutionMake sure the reference line has not been turned off, or set to "None" in one of the other sections' formatting.
- Right-click in the View > Format > Lines (In 10.0 and newer versions, three lines. In earlier versions, a paintbrush icon.)
- Check under Sheet, Rows and Columns to ensure that Ref Lines is not set to "None".
- Format > Reference Lines
- Make sure Line is not set to "None".
CauseThe formatting for reference line was set to None at the Workbook or Format menu level.
Formatting options set through the "Format" menu on the tool bar, or right-clicking on the view override the formatting options set by right-clicking and editing the reference line itself.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials