Bordering issue- master or apply all?

J

jkb724

Hi

I am working on one large spreadsheet so I was wondering if there was
way to create a border around each page without having to do i
manually for every page?? Is their some sort of master view o
something along those lines?

Thanks
 
R

RagDyer

If you "Group" the sheets, what you do to one, you do to *all* the sheets in
the group.

Click on the first sheet tab, hold <Shift>, and click on the last sheet tab.
All the tabs are now white, and you'll see "Group" appended to the sheet
names in the title bar.

Now, simply format your borders.
When complete, right click in a tab, and choose "UngroupSheets".
If you forget this last step, you can make one heck of a mess out of your
WB.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi

I am working on one large spreadsheet so I was wondering if there was a
way to create a border around each page without having to do it
manually for every page?? Is their some sort of master view or
something along those lines?

Thanks.
 
Top