Bordering multiple pages in a sheet?

#1 July 22nd, 2004, 06:34 PM

Is it possible to set a border around all my pages in one of my sheets?
In other words is there some sort of master that would apply to every
page in my worksheet.

---
Message posted from http://www.ExcelForum.com/

#2 July 23rd, 2004, 12:41 AM

Not without using VBA.

This would be complex.......finding page-breaks and adding borders based on
that.

For printing purposes, why don't you print some sheets with the border then
run your print selection through using those sheets with the pre-printed
borders?

Gord Dibben Excel MVP

On Thu, 22 Jul 2004 12:34:53 -0500, jkb724
wrote:

Is it possible to set a border around all my pages in one of my sheets?
In other words is there some sort of master that would apply to every
page in my worksheet.

---
Message posted from http://www.ExcelForum.com/

#3 July 23rd, 2004, 12:48 PM

Thanks for the suggestion Gordon. I hadn't thought of that. I
appreciate it.

---
Message posted from http://www.ExcelForum.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing 2 pages per sheet	Silvio	General Discussion	2	June 26th, 2004 10:02 AM
2 pages per sheet (Page Setup)	SteveW	Tables	11	June 15th, 2004 02:56 PM
Inserting Excel sheets into Texbox/Frame spanning multiple pages	barry1	Formatting Long Documents	1	May 1st, 2004 04:34 AM
Multiple items on the same sheet	Erica	Setting up and Configuration	1	November 27th, 2003 08:39 PM
Multiple charts in one sheet	Shovelman	Charts and Charting	1	October 12th, 2003 03:38 AM