Re: excel print ?
- From: "Lenny McHugh" <lmchugh@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 14 Oct 2004 13:11:40 -0400
Sorry, I used alt shift b, alt control b says collecting cells at page break
cells at page break dialog
A54 horizontal
Interesting I did a search on the net for ideas and found the only way to do
this is with word.
I tried that and got some output but not in the format that I want.
It printed cells 4 then 5 then the city state zip then cells 1 2 3 name
information, yuck!
Lenny
----- Original Message -----
From: "Ann Byrne" <annakb@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, October 14, 2004 7:07 AM
Subject: Re: excel print ?
Sorry, Lenny, let me try again. What does JFW says when you hit
shift-control-b?
At 11:21 PM 10/13/2004, you wrote:
>Hi Ann,
>It says surrounding border of active cell thin grid line
>Lenny
>----- Original Message -----
>From: "Ann Byrne" <annakb@xxxxxxxxxxxxx>
>To: <jfw@xxxxxxxxxxxxx>
>Sent: Wednesday, October 13, 2004 8:09 PM
>Subject: Re: excel print ?
>
>
>What does shift-alt-b tell you?
>
>At 06:46 PM 10/13/2004, you wrote:
> >I get a list of each column first a list of first names, then maiden
> >names
> >etc.
> > What I want to print is columns 1-3 on the first line
> >column 4 on the next line
> >5 on the next line
> >6, 7, 8 on the next line and 9 and 10 on the next line
> >Then repeat this pattern for the next and subsequent rows.
> >There are about 300 rows of information.
> >----- Original Message -----
> >From: "Ann Byrne" <annakb@xxxxxxxxxxxxx>
> >To: <jfw@xxxxxxxxxxxxx>
> >Sent: Wednesday, October 13, 2004 7:36 PM
> >Subject: Re: excel print ?
> >
> >
> >what happens when you try to print the document?
> >
> >It sounds like the document may be too wide to print on a single page.
> >Press
> >control-shift-b for JFW to tell you where the page breaks are. If it
> >tells
> >you the page breaks are vertical, go to print sett up--alt-f, then u, to
> >the page tab, and set the document to print as landscape instead of
> >portrait. then check your page breaks again. They should be horizontal,
> >not vertical. Vertical page breaks means that columns 1 through 10 (or
> >there abouts) prints on one page, then column 11 through 20 print on the
> >next page, and so on. This is ugly!
> >
> >
> >
> >
> >--
> >To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >To unsubscribe from this mailing list, send a message to
> >jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> >Archives located at: //www.freelists.org/archives/jfw
> >
> >If you have any concerns about the list, post received from the list, or
> >the
> >way the list is being run, do not post them to the list. Rather contact
> >the
> >list owner at jfw-admins@xxxxxxxxxxxxxx
> >
> >--
> >To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >To unsubscribe from this mailing list, send a message to
> >jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> >Archives located at: //www.freelists.org/archives/jfw
> >
> >If you have any concerns about the list, post received from the list, or
> >the way the list is being run, do not post them to the list. Rather
> >contact the list owner at jfw-admins@xxxxxxxxxxxxxx
>
>
>
>--
>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>To unsubscribe from this mailing list, send a message to
>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
>Archives located at: //www.freelists.org/archives/jfw
>
>If you have any concerns about the list, post received from the list, or
>the
>way the list is being run, do not post them to the list. Rather contact the
>list owner at jfw-admins@xxxxxxxxxxxxxx
>
>--
>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>To unsubscribe from this mailing list, send a message to
>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
>Archives located at: //www.freelists.org/archives/jfw
>
>If you have any concerns about the list, post received from the list, or
>the way the list is being run, do not post them to the list. Rather
>contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
