| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make fit to page 1 by 1 default for every sheet in an xls
Also, display sheet tab at top of the printed page and in preview
Thank you, John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make fit to page 1 by 1 default for every sheet in an xls
Group the sheets, print setup for 1x1.
Enter &[Tab] in custom header. Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:15 -0800, john lawlor wrote: Also, display sheet tab at top of the printed page and in preview Thank you, John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make fit to page 1 by 1 default for every sheet in an xls
please explain "group the sheets" "Gord Dibben" wrote: Group the sheets, print setup for 1x1. Enter &[Tab] in custom header. Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:15 -0800, john lawlor wrote: Also, display sheet tab at top of the printed page and in preview Thank you, John |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make fit to page 1 by 1 default for every sheet in an xls
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 On Wed, 4 Feb 2009 18:40:55 -0800, john lawlor wrote: please explain "group the sheets" "Gord Dibben" wrote: Group the sheets, print setup for 1x1. Enter &[Tab] in custom header. Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:15 -0800, john lawlor wrote: Also, display sheet tab at top of the printed page and in preview Thank you, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make url link to sheet in Excel web page ??? | Excel Discussion (Misc queries) | |||
| How to make default page size as A4? | Excel Discussion (Misc queries) | |||
| set default page setups for insert sheet in workbook | Excel Discussion (Misc queries) | |||
| how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
| Make default insert sheet to have grid lines | New Users to Excel | |||
Linear Mode
