|
Excel needs to interact heavily with the 3rd
party print driver at this point, making any
options under page setup slow, particularly when
using VBA code.
This option invokes the page
setup dialog with four tabs (Below)
-
Page
-
Margins
-
Header/Footer
-
Sheet
Page contains options
for the paper
size, orientation and zoom. Tip: to make
your print fit to one page wide and then use as
many pages deep as it needs, you can mess around
with the 'scaling %', instead just clear the
'tall' box and Excel will calculate it for you.
The 'first page number' box allows you to enter
a number for the number in the header/footer of
the first page. This will normally be '1'
(auto), but the Excel sheet may be part of a
larger document in which you want to keep
sequential numbering.
Margins contains all the option to
adjust page margins. Unless you know the exact
measurement you wish to achieve, you are
probably better to click the 'Print preview'
button and then the 'Margins' button here where
you can drag and drop them graphically. (Note
that many page setup options are not available
from the print preview screen). 'Centre on page'
horizontally and vertically allows you to
easily, with two clicks, get the print centred
on the page.
Header/Footer contains all the options
to set titles, dates, times, filenames, etc in
the header or footer. Excel ships with
some common ones in dropdowns for both headers
and footers. (These cannot be changed). You can
'roll your own' by selecting custom header (or
footer) and clicking the various buttons to
insert variables such as file name (full path
only available from Excel 2002 (XP) and up),
tab name, date, time, etc.
You can also type your own
text in here or add it to variables. For example
Page &[Page] of &[Pages], the 'Page' and 'of'
are 'hard-coded', the other words
pre-fixed with & are variables which can be
typed or placed by clicking the relevant
buttons. If there were 20 total pages in a
printout and you were printing page 1, this
would result in 'Page 1 of 20'. If you need to
enter an & in the txt you will need to enter it
twice. e.g. Bodgitt & Scarper would need to be
entered as Bodgitt && Scarper
(For versions of
Excel before XP to enter the full path in the
footer you could put the following code in your
personal.xls file and link it to a toolbar
button)
Sub FullPathInFooter()
Dim mySheet As Worksheet
Set mySheet = ActiveSheet
mySheet.PageSetup.LeftFooter =
mySheet.Parent.FullName
End Sub
Sheet has the all the worksheet setup
commands, for example if you want to see the
titles in row 1 at the top of each page you
would type 1:1 on the 'rows to repeat at top'
box. (You can also click on the refedit control
on the far right of this box and then select row
1 if you can't remember how to type it.
You can set the 'print area' which selects the
area you want to print, irrespective of other
data that may be on the worksheet. (Excel
selects all data by default). You can set
gridlines to print or not. (If you have a colour
background to a cell(s), this setting has no
effect. If you want gridlines in this
case, you will need to set up borders
(Format>Cells...>Borders). You can set comments
to printout in various ways and errors to be
shown in certain ways. Lastly, you can decide
whether on multiple column worksheets, you want
excel to print down then across (Default) or
across then down. |
