ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I border an entire Excel worksheet page? (https://www.excelbanter.com/excel-discussion-misc-queries/74952-how-do-i-border-entire-excel-worksheet-page.html)

MariaK

How do I border an entire Excel worksheet page?
 
I have a very long Excel document and I want all the pages to have exactly
the same size border even if they differ in size. Can I set a border for all
the pages at once?


Debra Dalgleish

How do I border an entire Excel worksheet page?
 
Excel doesn't have page borders. You could preprint the borders in Word,
then print the workbook on that paper.

Or, you could use cell border in Excel, to create an outside border
around groups of cells. However, the size of this border could fluctuate
if the row height or column width automatically adjusted.

MariaK wrote:
I have a very long Excel document and I want all the pages to have exactly
the same size border even if they differ in size. Can I set a border for all
the pages at once?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com