Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

printing problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
crazymagoo - 06 Jan 2008 06:08 GMT
I currently have an excel 2003 workbook that I set up to keep the old
checkbook current.

set up like this
a                b               c               d            e
date   to whom     chk amt    dep amt    tot

date is formated as full date
to whom Is text
chk amount formatted as currency as well as deposit and total

the workbook is copied over to another workbook for the monthly totals.

I started another year on Jan 01 08...I now have a printing problem.  I have
one single line that is transposed from page 1 to page 2 in the print
preview and prints.

it is in row 8 (which is the 4th calculated row- with the title and all-I
have a title area and headers).

for some reason this row is brought down as the first row in page 2....I
have looked at the printing setup and there is nothing special besides I do
have a header and footer on the pages.   the header consists of title and
footer is of page 1 of ? and so forth...

I have tried to change the header and footer...I even removed them to no
avail.  for some reason this row is brought down only for printing....

any help would be appreciated

dlars80
Barbara Wiseman - 06 Jan 2008 11:13 GMT
Check
file,
page setup,
sheet tab
rows to repeat at top

if it is in there clear the field.
Note you can not change the rows to repeat at top or columns to repeat at
left by accessing the page setup from the print preview, only from the file
menu version

I hope that helps.
Barbara

>I currently have an excel 2003 workbook that I set up to keep the old
>checkbook current.
[quoted text clipped - 27 lines]
>
> dlars80
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.