Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Print titles across multiple sheets of a workbook
925 views
Skip to first unread message
Subodh
Oct 25, 2009, 3:11:10 AM10/25/09
to
I want to repeat the same text in the titles across multiple sheets
of a workbook. I want to print titles by repeating the same text
on the top of all sheets of the workbook. ie. i need to repeat the
Rows 1:3 of Sheet 1
on all pages printed of sheet1 as well as other sheets in the
workbook.
Any help would be appreciated.
Thanks in advance.
of a workbook. I want to print titles by repeating the same text
on the top of all sheets of the workbook. ie. i need to repeat the
Rows 1:3 of Sheet 1
on all pages printed of sheet1 as well as other sheets in the
workbook.
Any help would be appreciated.
Thanks in advance.
Gord Dibben
Oct 25, 2009, 3:35:06 PM10/25/09
to
You cannot do this.
Pagesetup.printtitlerows is sheet-only.
You would have to copy the three rows to each sheet before printing all
sheets.
Each sheet must then be setup to print those title rows either manually
sheet by sheet or by using VBA since you cannot simply group the sheets and
set up rows to repeat at top.
Gord Dibben MS Excel MVP
On Sun, 25 Oct 2009 00:11:10 -0700 (PDT), Subodh <gets...@gmail.com>
wrote:
Ranjan Nayak@discussions.microsoft.com Alok Ranjan Nayak
Nov 4, 2009, 8:15:01 AM11/4/09
to
Hi Subodh,
You can do Same as u like, Go Page Setup>Customise>Set name Of Repot , but
befor you silect all work sheet Like Ctrl+A all Requre Sheet then page Setup
.
"Gord Dibben" wrote:
> .
>
0 new messages