|
Formatting changes when I Print
I have some borders on my spreadsheet that, when I try to print the sheet
the formatting for some of my columns, and Rows, winds up being thicker than
the formatting on the screen. The lines show up thicker in print preview as
well. I believe this is probably caused old formatting I may have had on
this sheet at one time or another but am not sure. I have even tried to
erase the old f...
|
1 |
14.02.2006 19:11:51 |
|
|
Excel Print Quality not set results in poor image
When we print a spreadsheet in Excel to our Unidrv-based printer, it appears
that it is printing at a strange (high?) resolution.
I believe the lines in the spreadsheet are only 1 pixel wide despite the
resolution because of what happens, although I have not confirmed this.
Whatever occurs, it messes up some image processing we do when the image
arrives back at our application from the ...
|
2 |
09.03.2006 04:45:15 |
|
|
Print preview doesn't match printer output
I got an Excel workbook as an email attachment. When printing it out, the
print output cuts off column "A" and half of column "B". Print preview shows
the entire sheet. I've adjusted the margins, selected center horizontally
and vertically, and even "fit to one page wide by 2 pages tall" (which is
what print preview shows". I've adjusted the page breaks as well. Still, the
first colum...
|
3 |
06.03.2006 19:01:27 |
|
|
Printing Worksheets with Underling in wrong position
For several months now any cell I underline prints in the correct
location, but the unline print several rows down and one or two columns
to the right.
Recently I replaced my hard drive and installed MSWorks Suite 2006.
Everything works fine except I still have the same printing problem
underlining.
If I insert a Border, the border prints properly, but any underlining
stills prints serveral...
|
1 |
05.03.2006 08:34:37 |
|
|
Underlines print in wrong cell
For several months now any cell I underline prints in the correct
location, but the unline print several rows down and one or two columns
to the right.
Recently I replaced my hard drive and installed MSWorks Suite 2006.
Everything works fine except I still have the same printing problem
underlining.
If I insert a Border, the border prints properly, but any underlining
stills prints serveral...
|
1 |
01.03.2006 21:36:36 |
|
|
Print titles
I need to use 3 rows as Print titles - however the first single cell on top
row is wider than col widh giving the result that the content is cut on the
right page sections. I suppose this is determined by the col width.
Any suggestions how to get around this problem would be much appreciated.
Lasse
...
|
1 |
01.03.2006 15:50:00 |
|
|
Reduced Print
When I view my print preview all is fine but when I print the doicument it is
rewduced in Height and Width.
Am printing from Laptop to a HP PSC1350 all-in-onr printer using WINXP Home.
When I print from my Desktop to the same printer the print is fine.
Using WIN98SE on the desktop.
Settings are the same on both systems.
Any comments/advise would be appreciated.
sparetom ...
|
2 |
01.03.2006 12:21:31 |
|
|
EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>YOU COULD BE EARNING OVER $3K A DAY , $100K A
MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P>
<P><A href="http://www.vosar.net">www.vosar.net</A></P>
<P>Tel: 775-333-11...
|
1 |
01.03.2006 07:14:08 |
|
|
"Line Creep"
When I go to print an excel document, the print preview looks fine, but when
I print, with grid lines of course, the data seems to slowly creep up until
you get to the end of the sheet and it looks like the last line has moved up
one complete line. I am using office xp with sp3. Any ideas?
Thanks
Al
...
|
1 |
28.02.2006 13:53:35 |
|
|
Print only certain rows
Help please.
I have a listing, 000's of rows, ~ 20 columns and I only want to print those
that match certain criteria and I am looking for a VBA solution.
Details are:
I have indicated the rows to print by inserting a txt character [can be
changed to value] in each row, in a spare column.
I know my problem can be solved with filtering but that method is not
appropriate here.
I am usin...
|
6 |
27.02.2006 23:01:43 |
|
|
Print watermark
Hi,
I have a problem in Excel when printing with a watermark.
I want to print multiple worksheets from one workbook at once, with a
watermark. So I select all the worksheets, press Ctrl-P for the printer
dialog. Then I select in the printer settings the watermark and print the
document.
But only the pages of the first worksheet get the watermark. All the next
worksheets are printed wi...
|
2 |
26.02.2006 16:43:26 |
|
|
Printing worksheets in an alphabetical order
Hi,
I need some help. I have several excel files and I need to print all
the worksheets in an alphabetical order (based on the worksheet name).
Please help.
Thanks
Fari
...
|
4 |
23.02.2006 23:12:44 |
|
|
I want Excel Gridlines to show up when printing
I do have at least one worksheet in my workbook where I want the gridlines
of the cells to print. Can you remind me where to set it so these prints?
Thanks in advance.
...
|
2 |
22.02.2006 11:44:18 |
|
|
Forcing Page numbers to print outside of normal sequence
Hi. Looking for a way to print an Excel spreadsheet that is approx. 3 pages
- but not with the typical 1,2,3 page number sequence. These 3 pages from
this one spreadsheet have to be included in a presentation and inserted after
page 24. Therefore, I need my spreadsheet to print with the page numbers
25, 26 and 27.
If I add "25" to the custom footer, all 3 pages print out the page ...
|
2 |
21.02.2006 20:19:28 |
|
|
Print to PDF using a Macro.
I am trying to create a macro to print out each sheet to a different file
name. Only is that It wont let me specify file. I have tried several
different choice and it will stiil not work.
See Below
Range("A2").Select
Selection.Copy
Application.Goto Reference:="test"
Application.CutCopyMode = False
ActiveSheet.PageSetup.PrintArea = "$A$1:$L$62"
ActiveWindow.Sele...
|
1 |
21.02.2006 19:23:15 |
|
|
Automatic Best Fit For Chart
Hi There,
I create a lot of charts, and I always manually have to change the settings
to get the best fit onto A4 paper. Is there a method of automating this
process??
tia BigH
...
|
1 |
20.02.2006 22:02:32 |
|
|
Print all sheets one below?
Hi
I have more than 12 sheets in my workbook. I group tham and print all
sheets. But in some sheets i have not more than 15 to 20 rows and than new
sheets start in new page, is there any way can i print all sheets one below
other.
Thanks
Tiya Shah ...
|
1 |
20.02.2006 12:02:27 |
|
|
Excel Does Not Print
I saw that there was an older thread with the same problem, but decided
to start a new one because there was no solution posted. I have a user
here that has a HP3700DN ColorLaser Jet attached to her machine. Excel
will not print anything. When she clicks to print the printer icon
shows up in the system tray, acts as if it is spooling, then disappears
with no output from the printer at all....
|
4 |
17.02.2006 23:35:32 |
|
|
Spreadsheet with autofilters print multiple choices
I have inherited a horrible spreadsheet which has a number of autofilters and
macros. The data is a list of rounds and pickup days e.g. Day: Monday
Round: North 1.
I select Day and round from the drop down list and then click a button which
starts a macro 'View round sheet'. The round sheet data show the roads
filtered out according to the selections I made.
I would like to write ...
|
6 |
14.02.2006 12:55:28 |
|
|
Q.EXCEL2000,Howtoremove margin wholly
Subject : Q. EXCEL2000 - How to remove page margin wholly at the print
preview ?
Page Margin(A4) was set all zero(0) at Excel 2000 (not XP or 2002),
but it still remains AT 'PRINT PREVIEW'.
Please advise me "how to remove margin completely at the Print PREVIEW".
I want to fill with Black color(or deep, dark color) for a background
(filling cell) on the whole AT THE PRINT PREVIE...
|
1 |
14.02.2006 05:00:58 |
|
|
Q.EXCEL2000,Howtoremove margin wholly
Subject : Q. EXCEL2000 - How to remove margin wholly ?
Page Margin(A4) was set all zero(0) at Excel 2000 (not XP or 2002),
but it still remains at 'print preview'.
Please advise me how to remove margin completely.
I want to fill with Black color(or deep, dark color) for a background on
the whole A4 Paper (Characters are white or another color).
Thank you !
Linda
FE...
|
1 |
14.02.2006 04:15:30 |
|
|
Print only pages have data
I don't want to print out blank pages, how do I tell Excel to stop printing
when there is no more data on a worksheet?
...
|
2 |
13.02.2006 02:59:37 |
|
|
Why the extra white space?
Quick question here from a reasonably experienced Excel user. I routinely
use page setup options based on 1 page wide and no limit to the number of
pages long. I like this because it typically optimizes printouts.
Frequently, however, I get excessive white space on the right side or the
bottom. I check the Page Preview mode to ensure the print area is not
incorrectly set (I nearly al...
|
2 |
11.02.2006 15:06:25 |
|
|
How to set default footer to "none"
I've tried creating templates (book.xlt and sheet.xlt) that reside in
my XLStart folder; I used Page Setup to set headers and footers to
none, but only the header instruction sticks. Every time I create a
spreadsheet and go to Print Preview, there is a footer present and I
have to go to the dropdown to change it to none. I'm using Excel2003.
...
|
1 |
09.02.2006 19:56:10 |
|
|
PrintOut Pdf Sendkeys
Hi,
I'm desperately trying to automate clicking on the save button of PDFWriter
v5 dialog box.
Do you know how to use these sendKeys ?
I never did it, It seems damned simple, but I still can't get it to work !
This is one of the lines i've tried :
SendKeys "{ENTER}", False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat
PDFWriter"
Thanks in advance for an...
|
1 |
07.02.2006 16:04:27 |