make fit to page 1 by 1 default for every sheet in an xls

  • Thread starter Thread starter john lawlor
  • Start date Start date
J

john lawlor

Also, display sheet tab at top of the printed page and in preview

Thank you,
John
 
Group the sheets, print setup for 1x1.

Enter &[Tab] in custom header.


Gord Dibben MS Excel MVP
 
please explain "group the sheets"

Gord Dibben said:
Group the sheets, print setup for 1x1.

Enter &[Tab] in custom header.


Gord Dibben MS Excel MVP

Also, display sheet tab at top of the printed page and in preview

Thank you,
John
Click to expand...
Click to expand...
 
A trip to the help section of Excel would have gotten you an answer quite
quickly.

Right-click on a sheet tab and "select all sheets".

Or CTRL + click on sheet tabs if just want some sheets to be included.

Whatever you do to one sheet in the group will be done to all sheets in the
group.


Gord

please explain "group the sheets"

Gord Dibben said:
Group the sheets, print setup for 1x1.

Enter &[Tab] in custom header.


Gord Dibben MS Excel MVP

Also, display sheet tab at top of the printed page and in preview

Thank you,
John
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print entire workbook with each sheet starting at page 1 8
Resize to last entry in row and copy to sheet 1 3
Controlling Page Break Preview 7
Method to automate page numbers on single worksheet 1
Make the same titles repeated in multiple sheets of a workbook 1
Excel Fit to page print options in Excel 1
Access How to prevent subReport from breaking across pages? 1
All pages to open in page break mode 4

Back
Top