Cell borders are incomplete on print preview
up vote
0
down vote
favorite
Something super odd is happening with a spreadsheet I inherited from a colleague. I have borders all around numerical values, but not all of it shows up on print preview:
Everything prints properly, though! I'm just really curious why it's doing that.
Also, there are grid lines that appear on a second page when printing.
Phantom grid lines here:
I've tried clearing, deleting, etc., (which worked on some lines on the first page), but it refuses to go away. Is there a way to get rid of it?
microsoft-excel printing
edited Aug 30 at 21:31
robinCTS
3,83241527
asked Aug 30 at 19:08
funkydodel
11
add a comment |
up vote
0
down vote
favorite
Something super odd is happening with a spreadsheet I inherited from a colleague. I have borders all around numerical values, but not all of it shows up on print preview:
Everything prints properly, though! I'm just really curious why it's doing that.
Also, there are grid lines that appear on a second page when printing.
Phantom grid lines here:
I've tried clearing, deleting, etc., (which worked on some lines on the first page), but it refuses to go away. Is there a way to get rid of it?
microsoft-excel printing
edited Aug 30 at 21:31
robinCTS
3,83241527
asked Aug 30 at 19:08
funkydodel
11
2
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, ClickPage Layout, inSheet OptionfindGrid LinescheckPrintoption. You find Grid lines appears during Print Preview also. ☺
– Rajesh S
Aug 31 at 9:21
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Something super odd is happening with a spreadsheet I inherited from a colleague. I have borders all around numerical values, but not all of it shows up on print preview:
Everything prints properly, though! I'm just really curious why it's doing that.
Also, there are grid lines that appear on a second page when printing.
Phantom grid lines here:
I've tried clearing, deleting, etc., (which worked on some lines on the first page), but it refuses to go away. Is there a way to get rid of it?
microsoft-excel printing
edited Aug 30 at 21:31
robinCTS
3,83241527
asked Aug 30 at 19:08
funkydodel
11
Something super odd is happening with a spreadsheet I inherited from a colleague. I have borders all around numerical values, but not all of it shows up on print preview:
Everything prints properly, though! I'm just really curious why it's doing that.
Also, there are grid lines that appear on a second page when printing.
Phantom grid lines here:
I've tried clearing, deleting, etc., (which worked on some lines on the first page), but it refuses to go away. Is there a way to get rid of it?
microsoft-excel printing
microsoft-excel printing
edited Aug 30 at 21:31
robinCTS
3,83241527
asked Aug 30 at 19:08
funkydodel
11
edited Aug 30 at 21:31
robinCTS
3,83241527
asked Aug 30 at 19:08
funkydodel
11
edited Aug 30 at 21:31
robinCTS
3,83241527
edited Aug 30 at 21:31
robinCTS
3,83241527
edited Aug 30 at 21:31
robinCTS
3,83241527
3,83241527
asked Aug 30 at 19:08
funkydodel
11
asked Aug 30 at 19:08
funkydodel
11
asked Aug 30 at 19:08
funkydodel
11
11
2
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, ClickPage Layout, inSheet OptionfindGrid LinescheckPrintoption. You find Grid lines appears during Print Preview also. ☺
– Rajesh S
Aug 31 at 9:21
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20
add a comment |
2
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, ClickPage Layout, inSheet OptionfindGrid LinescheckPrintoption. You find Grid lines appears during Print Preview also. ☺
– Rajesh S
Aug 31 at 9:21
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20
2
2
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, Click
Page Layout, in Sheet Option find Grid Lines check Print option. You find Grid lines appears during Print Preview also. ☺– Rajesh S
Aug 31 at 9:21
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, Click
Page Layout, in Sheet Option find Grid Lines check Print option. You find Grid lines appears during Print Preview also. ☺– Rajesh S
Aug 31 at 9:21
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
this is what I do, and its settled my problem
- hightlight the missing line area
- right click --> format cells --> tab border
- then at border -- click text -- then the line will appear
enter image description here
enter image description here
there yo go.
answered Nov 29 at 4:02
imma
1
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
this is what I do, and its settled my problem
- hightlight the missing line area
- right click --> format cells --> tab border
- then at border -- click text -- then the line will appear
enter image description here
enter image description here
there yo go.
answered Nov 29 at 4:02
imma
1
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
add a comment |
up vote
0
down vote
this is what I do, and its settled my problem
- hightlight the missing line area
- right click --> format cells --> tab border
- then at border -- click text -- then the line will appear
enter image description here
enter image description here
there yo go.
answered Nov 29 at 4:02
imma
1
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
add a comment |
up vote
0
down vote
up vote
0
down vote
this is what I do, and its settled my problem
- hightlight the missing line area
- right click --> format cells --> tab border
- then at border -- click text -- then the line will appear
enter image description here
enter image description here
there yo go.
answered Nov 29 at 4:02
imma
1
this is what I do, and its settled my problem
- hightlight the missing line area
- right click --> format cells --> tab border
- then at border -- click text -- then the line will appear
enter image description here
enter image description here
there yo go.
answered Nov 29 at 4:02
imma
1
answered Nov 29 at 4:02
imma
1
answered Nov 29 at 4:02
imma
1
answered Nov 29 at 4:02
imma
1
1
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
add a comment |
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
I think the OP's problem is that lines that are really there don't show in the shrunken print preview (pixel rounding).
– fixer1234
Nov 29 at 5:32
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1353892%2fcell-borders-are-incomplete-on-print-preview%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
The print preview render often doesn't display the gridlines correctly. I've found zooming in on the print preview will often make them show up.
– wysiwyg
Aug 30 at 19:45
If you are struggling with Grid Lines, (Bcoz in the attached Screen Shot I can see the BORDERS around) then do this,, Click
Page Layout, inSheet OptionfindGrid LinescheckPrintoption. You find Grid lines appears during Print Preview also. ☺– Rajesh S
Aug 31 at 9:21
Wow, I never knew one can zoom in on the print preview--thanks for that tidbit! Most of the borders do render when I zoom in on print preview, but some of them still don't. Oh well, as long as it prints properly! Also, I figured out how to get rid of the phantom borders (they were just on a different pane, haha), but the 2nd blank page still wants to print.
– funkydodel
Aug 31 at 15:09
You probably have something in a cell below. It could be just a space in one cell. You can try deleting unused rows below or set the Print Area in Page Setup::Sheet.
– Rey Juna
Aug 31 at 18:20