ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Boarders in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/144696-boarders-excel.html)

Pat[_2_]

Boarders in Excel
 
Is it possible to create a boarder in excel as you do in word?
I don't mean boarders around a Cell or area of Cells, but as in the entire
printed page, but still be able to use excel as needed.
--
Thanks, Pat

Earl Kiosterud

Boarders in Excel
 
Pat,

In a word -- no. In another word -- yes. Excel won't border pages automatically as Word
does. But you could do it manually after the sheet has been paginated (the dotted lines
that appear after a print or print preview). You'd use cell borders (Format - Cells -
Borders tab). You wouldn't be able to get the little cherries, etc., that Word provides --
just lines. But there are some somewhat fancy lines available in the borders. If you need
to do this frequently, a macro would be the way to go, if you're interested and willing.
That's what macros are good for -- nonstandard tasks that need to be automated.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Pat" .(donotspam) wrote in message
...
Is it possible to create a boarder in excel as you do in word?
I don't mean boarders around a Cell or area of Cells, but as in the entire
printed page, but still be able to use excel as needed.
--
Thanks, Pat





All times are GMT +1. The time now is 05:33 PM.

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