Print multiple tabs on one page
How to print multiple tabs in excel onto one page in one print job? Tab1 and
tab2 have different format and cannot be combined into one tab. Need to
print the two worksheets one on top of each other is the same direction.
Tried Report Manager but printed on two pieces of paper. Any suggestions?
One way to accomplish something like this is to play around with "pictures".
I'm on an XL97 machine now so,
When you hold down <Shift> and hit <Edit>, you get a different dialog box
.... one that contains "picture " options.
So, select an entire sheet, or p...Print report when data changes
I have a form with a subform. If the data in the subform changes, I want to
print a report when the form is closed. If there is no change in data in the
subform, I don't want the report to print. How can I accomplish this?
You could have a command button on the main form that runs the report. On
open, set enabled to false.
then in the subform,
If Me.Dirty Then
Me.Parent!YourCommandbutton.Enabled = True
"Ivor Williams" <email@example.com> wrote in message
>I have a form with a subform. If the da...Print Range Doesn't Display
I have a multi worksheet file which Vie used without incident for five
years. Today, I inserted a page break and also selected a print area. I
found that, although the area and page break shows correctly in Print
Preview, neither the page break nor the print area outline box appear on the
The tools | Options | General shows "Display All"..
Even more curious, if I do the same on one of the other worksheets in the
file, the area displays correctly.
>>The tools | Options | General shows "Display All"..
But more on point, is Tools, Options...Printing header in EXCEL2007
I have a large EXCEL sheet that will print in many pages. At the top of the
entire worksheet I have a line that says " Address Names phone number "
How do I get EXCEL 2007 to reprint this heading on each page it prints
"pcor" <firstname.lastname@example.org> wrote in message
>I have a large EXCEL sheet that will print in many pages. At the top of the
> entire worksheet I have a line that says " Address Names phone
> number "
> How do I get EXCEL 2007 to reprint this...changing default view on print preview of report
How do you change the default zoom level when you click on print
preview button for a report?
100% does not give me enough detail, and when I click on the
magnifying glass icon, it only takes me up to about %125. I would like
it to show me the report at 200% by default.
Also, is there a way to zoom in on the report design view? I am trying
to micro adjust a report that needs to use pretty small font (like 6
points) and it's a real pain.
If you are going to be using the zoom for a while you could just alter the
screen resolution to show more.
With report in previe...Controlling printed records when report bound to multiple tables
I created a report that uses the control from a form to generate a report
based on that record's primary key. This form also has a subform which has
relationships tied to the primary key for record identification and is linked
to the main table. When preview the report the data from the subform either
does not show up in the preview when using the filter
[control]=[form]![control].[value] or makes multiple copies of the report
equal to the number of entries in the subform's table.
Is there any way around this? I have tried queries but have not found a way
to use a f...Printing Option Buttons
I am using options buttons inserted from the Control Toolbar (Excel 2003).
They function correctly and appear fine in the worksheet. When printed, the
button graphic always is displayed in a black square. I have tried changing
the backstyle and backcolor properties to no avail.
What am I missing?
If you don't want the button printed, in Properties uncheck "Orint Object"
If you do want it printed, fiddle about with printer settings for color and
black and white.
Gord Dibben MS Excel MVP
On Thu, 18 Feb 2010 07:22:03 -0800, terri <terri@disc...Print Titles
Hi, I need some help please.
I have a sheet with lists of peoples names and other specific data. I'm
able to sort these and sub-total them into groups of the same name and print
these on separate pages. I've set up a header so it prints at the top of
every page through "print titles". This is fine and I'm happy with this.
What I'm trying to do is to have the name of the person in the "header" that
appears at the top every page. But how?
Are all these groups on the same worksheet?
If so, you are allowed only one &qu...Printing 1/2 page postcards
I am trying to print two similarly designed postcards on one page but with
different addresses. I am using MS Publisher 2003. Is there any way to do
Select custom in page setup, type 5.5 in the height box, Publisher will print
two per sheet. This is the setup you will use for mail merge and two cards per
If each card is an individual piece, you will have to setup a custom size in
your printer. You can use a mail merge or print one card at a time, manually
changing the data each time.
Mary Sauer MSFT MVP
...printed P.O.s have several blank lines
Why do my printed/exported purchase orders have several blank lines between
the items and the subtotal?
Is there a way to get rid of them?
PLEASE Cc me your anser directly.
Bikes, Parts, Repairs
& GREAT Customer Service!
124 State Avenue NE
Olympia, WA 98501
Featuring free bike advocacy and safety materials!
...Z report not printing
All other receipts are printing and I can print a X report but cannot print a
Z report. Have I missed something?
...Book fold won't makes print small to print 4 pages on 1.
I am using 8.5 x 14 paper. I would like to know how to get the print
standard size to fill an 8.5 x 7 page. Using book fold and landscape and
enlarging paper size will not change size of print. I have checked
everything in page setup. Please help!
>I am using 8.5 x 14 paper. I would like to know how to
get the print
>standard size to fill an 8.5 x 7 page. Using book fold
and landscape and
>enlarging paper size will not change size of print. I
>everything in page setup. Please help!
Select the text in question an...Booklet Printing in Publisher
I am trying to print a 12 page booklet in publisher on a printer that is
set-up on signle side printing only? How do I accompish this?
View, clear two-page spread. Starting with page one, in the print dialog tick print
current page, click "no".(This will print 1 and 12)
Turn the printed page over, go to page 2, print current page, click "no". (page 2 and
And so on...
Mary Sauer MS MVP
"debbiev" <email@example.com> wrote in message
news:5F3294C0-812...Printing all of the gridlines
How can I print a spreadsheet with the grid lines appearing where there is no
test. For instance, if there were only a few colums used, how can I print so
that the grid lines are on the rest of the page? I went into the page setup
and checked the box that says gridlines. I also went in and checked the box
that said whole workbook. Any suggestions? Thank you...
I don't know of an option to print gridlines beyond the used range of a
worksheet. You could put in borders, either with the border button on the
Formatting Toolbar, or (better) with Format - Cells - Borders. Mak...E-mail Print Orientation
I can only print e-mails in memo (landscape) format in Outlook 2007. Is
there a way to change this to table (portrait) as a default? I have checked
my printer settings and the default is portrait.
"Greg" <Greg@discussions.microsoft.com> wrote in message
>I can only print e-mails in memo (landscape) format in Outlook 2007. Is
> there a way to change this to table (portrait) as a default? I have checked
> my printer settings and the default is portrait.
Memo is not the equivalent of landscape ...Another Printing Question
I just can't seem to wrap my head around this printing thing.
What I am doing is creating a report that displays text, graphs (using a
third party graph control), list of items and expandable list control / tree
The problem I am facing is number of pages. I can't find a clean way to
find the places where I would need to start a new page. Since what I am
printing is not uniform data, I can't simply find the number of lines of
text , multiply it by the line height, and divide by page height to find the
number of pages. (a graph has no lines of text, a...Printing a selected part of worksheet
I know it's possible to highlight a portion of a
worksheet and print just that part. That works fine, but
I have a super big spreadsheet that has to be broken into
several pieces before I can print it.
I'd like to make the process more efficient by assigning
names to various portions of the spreadsheet. Then, when
I would want to print, I could simply tell Excel to print
those predesignated portions. But how do I do that?
Any help is much appreciated.
> I ...Printing issue for Publisher Newsletter
I am trying to print a newsletter. When I view the printer setup it says that
the newsletter is larger than the paper. When I click on print preview it
has inserted extra blank pages. When I print, it inserts 4 blank pages in
between each page I am trying to print. I am new to Publisher, so I am not
sure how to fix this. HELP!!!!
Are you using a Publisher template? Have you inserted a page? Is the newsletter
letter size or tabloid (11 x 17)?
"Sandy" <Sandy@discussions.microsoft.com> wrote in message
Does Anyone Have A Solution For Printing The Structure Of A Table To The
Printer Or Even Text File...dbase used to just let you list structure to
On Wed, 2 Jun 2010 07:41:01 -0700, dmills
Check out Database Documenter in the menu.
Microsoft Access MVP
>Does Anyone Have A Solution For Printing The Structure Of A Table To The
>Printer Or Even Text File...dbase used to just let you list structure to
...printing a metafile file
Does someone know a link to somemore inforamtion on printing a metafile for
print preview and a printer?
I did some work with emf files some years ago. Are you talking about bring in a .wmf or
..emf file and then displaying/printing it? As far as I know, you just have to play the
metafile in the OnDraw handler to make it work (assuming OnPrepareDC for the printer has
done the right scaling). I probably have some old code I could send you, for whatever
good it might be.
On Sun, 27 Jan 2008 15:17:00 -0800, Al <Al@discussions.microsoft.com> wrote:
>Does someon...Half of flowchart printing at top of page
I just recently got Visio. I created a flowchart. I've printed it in the past
and it printed fine. Now each time I try and print it, no matter what I set
the print setup, it always prints the bottom half of the flowchart at the top
of the page. Can anyone help?
P.S. I'm not really proficient at computers so please give detailed
Thanks so much!!!
That is a symptom of a printing problem in Visio 2003. If you install the
latest service packs, that should correct the problem.
Office Graphics - Visio
This posting is provided &q...printing to XPS and saving XPS "as"
Hi - I have a "save as" macro that I would like to incorporate with my "print
to XPS" macro. Can anybody help?
I have this code:
'' Save to XPS ''''''''''''''''''''''''''''
Application.ActivePrinter = "Microsoft XPS Document Writer on Ne01:"
Sheets("Credit History").PrintOut Copies:=1
Application.ActivePrinter = "HP LaserJet P1505n on Ne02:"
'''''''...Printing in Publisher 2003
I just upgraded to Publisher 2003 and have opened a
document that was created in an earlier version of
Publisher - 97 or 98.
The document looks fine both on the screen and under
print preview, however, when the document prints the text
in a text box down the left hand side of the page is
Almost all of the first letter of each line down the left
hand side is move across to the other side of the text
box somewhere on the same line.
I can't seem to get this to correct itself. I have tried
creating new text boxes and coping the text across but
still the sa...Printing Labels from Marketing List
It is possible to create Mail Merge documents for the members of a
Marketing List through Quick Campaign or Main Campaign. But how about
creating labels for all the members in the Marketing List? It seems
that labels can be created only from the main contact list and not from
the Marketing list.
Don an Advanced find to look for all contacts (or account depending on the
marketing list) who are on a particular marketing list. From the find
results do a mail-merge to labels.
"Onkar" <firstname.lastname@example.org> wrote in message
news:1166056772.911550.14100@8...Print all records on Form
I am having a problem. I created a main form that filters many different
options and then opens another form. From there the user can double click
any record to get more detail, but I would like to also give them the option
to print only the records on the form as well in a report. But everytime I
click the button to print the report all the records from the query print.
Not just my filtered records.
Can anyone help me? Thanks!
You can apply the form's filter to the report by putting code like this in
the Click event procedure of a command button on your form: