Solved

Excel 2016 - Dotted line appears, but it's not a page break

Posted on 2016-11-17
14
832 Views
Last Modified: 2016-11-18
Excel 2016/Win10:

Per the screenshot below: I have a row that displays a dotted line from columns B - F. (The cell in col. B is merged). I Googled this topic, and found references to turning off the display of page breaks; however, I am reasonably sure it's not a page break.

Excel dotted line mystery
Any idea what this dotted line represents and how to get rid of it?

Thanks,
Steve
0
Comment
Question by:Stephen Kairys
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
  • 2
14 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41891853
Is there some conditional formatting in place applying the format?

Or is it just a cell border drawn across, or a physical line drawn on the sheet?

If you upload the sheet we can take a look.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41891861
@Rob - Not conditinoal formatting - I don't even know how to do that. :)
How would I tell if it's a cell border "drawn across" or a physical line?

Give me a few minutes to upload...need to redact something.... Thanks.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41891866
OK, I'm trying to redact the info by removing data from certain cells, but - poof - as I go through this process, the dotted line vanishes.
So, let's try to resolve per my previous question. How would I tell if it's a cell border drawn across, or a physical line? Thanks!
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 33

Expert Comment

by:Rob Henson
ID: 41891875
If it goes when data is deleted would suggest it is Conditional Formatting.

On home ribbon there is dropdown button for CF. Click this and choose Manage Rules. Use the dropdown at the top of the popup to select "This worksheet" rather than Current Selection. Any rules in place will now show.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41891882
@Rob - No rules show. Thanks.
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 250 total points
ID: 41892441
I suspect that the line is where the page break would occur. From your screenshot, you probably have Freeze Panes turned on, and your Print_Area starts in column B.

I was able to reproduce the appearance of your screenshot in the attached workbook set up as I described above.
-PageBreakSpansMergedCell.xlsx
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 250 total points
ID: 41892635
To check if it is a physical line drawn on the sheet, hover the mouse over the line and if it is a drawn line the cursor will change to the 4 pointed cross-hair selection icon. I suspect this is unlikely but not impossible.

For checking if it is cell borders, select cells immediately above and below the line, two rows of cells; right click and choose Format Cells. On the popup choose the Borders tab. The graphic will show the state of the lines of the chosen cells. If there is a border in place between the two rows of cells selected, the graphic will show a line across the middle. If all cells are formatted the same the style of line for all cells will be shown; if formatting differs across the cells the line will be shown as a grey line. If no line then there is no border.

To check if it is actually a page break, it could be an automatic break rather than a manual break; on the View ribbon select "Page Break Preview". This will show the print area of the sheet and beyond the print area will be greyed out. The page breaks will be shown as blue lines; auto breaks will be dashed lines, manually inserted breaks and the edge of the print area will be solid lines. In this view you can hover the mouse over the page breaks and move them around. If it is the first time you have used Page Break Preview mode there will be a popup telling you that breaks can be dragged around.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41892825
@Byundt -
1. My Freeze Panes is set to freeze Row A and Columns 1 and 2.
2. As far as I know, Print Area is the whole sheet. However (in Print Preview), the column heading "A" for the first column is blank. "B", "C", "D" do display.
2. What row contains the dotted line (in your sample)? I don't see it.

@Rob -
1. Page Break Prview shows the dotted line around the point I saw it on the normal view.
2. However, when I opened the workbook this morning, the dotted line was GONE in normal view.

At this point, I'm inclined to Accept Rob's explanation since it seems closest to what was occuring.

Thanks, everyone!
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
ID: 41892847
In Normal view, the dotted line normally appears after you have done a Print Preview. Doing that forces Excel to calculate where the page breaks would be based on the drivers for the chosen printer.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41892849
@Rob - Yup. After print preview, the line I mentioned, and at least one other, came back. I don't recall doing  Print Preview before the original issue occured, however. Still, you've provided enough for me to close this question.

Thank you so much! Have a good weekend.
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41892853
This is all great stuff! Thank you all for your knowledgable help!
0
 
LVL 4

Author Closing Comment

by:Stephen Kairys
ID: 41892854
Great stuff. Thanks, everyone!
0
 
LVL 81

Expert Comment

by:byundt
ID: 41893083
In the workbook I posted, the page break occurs between rows 47 and 48. You can see the dash line go across the merged cells B43:B49. Your default printer may have slightly different page breaks from mine.

To get the dashed line to appear, I did a File...Print followed by Print Preview. After seeing the Print Preview, I Escaped out of the dialog before actually printing the page. The dashed line then appeared at the bottom of B47:F47.
1
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 41893148
@Byundt - Thanks again!
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question