Microsoft Excel
--
Questions
--
Followers
Top Experts
Excel 2016 - Dotted line appears, but it's not a page break
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.
Any idea what this dotted line represents and how to get rid of it?
Thanks,
Steve
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.
Any idea what this dotted line represents and how to get rid of it?
Thanks,
Steve
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
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.
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.
@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.
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.
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!
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!
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
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.
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.
@Rob - No rules show. Thanks.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
@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!
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!
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
@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.
Thank you so much! Have a good weekend.
This is all great stuff! Thank you all for your knowledgable help!
Great stuff. Thanks, everyone!
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
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.
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.
@Byundt - Thanks again!
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.