All Questions
Tagged with border microsoft-excel
13
questions
5
votes
2
answers
2k
views
Create PDF from an Excel file without margins in Windows 7
This question is kind of answered, but that solution doesn't work for Windows 7.
I've set margins to 0, no scaling and put colored shape all over printable area (few columns and rows from A1), for ...
3
votes
1
answer
667
views
How to properly set left and top border of a range in Excel when the range is at the top left corner?
I have a range A1:B3 in Excel and I've given a border to it. However, the top and left border look a little bit thinner than the right and bottom border. See below image, I set them all to have the ...
2
votes
3
answers
23k
views
EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]
Possible Duplicate:
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I have the following rows...
1 AA 12 13 4 7
1 A 12 ...
2
votes
13
answers
245k
views
Excel borders are there but not shown on print preview and won't be printed
I want to print my excel document, it has box border, but I can't see them on print preview and when I print the document, borders are not printed.
Page margins are narrow enough, Page Layout tab > ...
1
vote
1
answer
2k
views
Change color existing irregular borders - Excel
I would like to change the existing border color of multiple cells -some of them have only a border at the top/ left or none at all etc- in Excel.
Is there a standard option for this, or is can this ...
1
vote
2
answers
13k
views
Putting borders around the Headers and Footers sections
I want to put borders around the three sections of the Headers and Footers
when I print an Excel workbook.
Does anyone have any suggestions on how to do this?
Update
As an example for the result, ...
0
votes
1
answer
474
views
VBA - Setting Side Borders in Varying Columns and Rows
Everyday I run a list, it is always different. It will have different amounts of rows with different values in them every day.
I have coded it so I have horizontal borders exactly as I want, but now ...
0
votes
2
answers
5k
views
Why won't my Excel borders print to PDF but they print just fine on regular printer?
I'm entering this as a question even though I found the solution in the hopes that it helps the next person.
Using Excel on a Windows PC, I tried printing a document to PDF that I'd previously had no ...
0
votes
0
answers
732
views
Excel: My target cells aren't keeping their borders after Paste...Unless I manually drew (clicked on) each border
So this one is rather weird.
Say I am copying the value from Cell A into Cells B & C:
Cell A (my Copied cell) doesn't have any border formatting.
Cell B has a border that I drew by dragging out ...
0
votes
1
answer
936
views
Leftmost border on Excel doc doesn't show in print preview / won't print
I have had the issue where the leftmost or topmost border on my Excel sheet doesn't show in print preview & also doesn't print for some time, and I'm pretty sick of it!
I've tried fitting columns /...
0
votes
1
answer
638
views
Conditional formatting - Borders over Multiple Rows
I have Cells formatted like this:
If the first cell of a triplet contains the word "baz" I want them formatted so there is a border around the triplet as well as some color adjustments.
However, in ...
0
votes
1
answer
42k
views
Remove outline/page border in Microsoft Excel
How do I hide the outside grid lines (at the edges of my data header) in Microsoft Excel?
I need to have gridlines print/view ON for the rest of the data. I can hide some gridlines in my header, by ...
-1
votes
1
answer
6k
views
Automatic borders in Excel 2010
I have a worksheet that automatically colors a row when column A is filled with certain text. What I want is to also have a thick black border appear above each colored cell, and not appear above any ...