Re: excel print ?
- From: "Lenny McHugh" <lmchugh@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 14 Oct 2004 15:42:46 -0400
No I don't want to reorder.
Word did it
what I want to do is to print each row as if it were an address in a master
list.
----- Original Message -----
From: "Ann Byrne" <annakb@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, October 14, 2004 2:08 PM
Subject: Re: excel print ?
There is a feature in the print dialog to print only selected columns; but
if you want them in a different order than they are, that won't work. If
the order is the same as the spread sheet, but you just want to skip some
columns along the way, try hiding the ones you want to skip. Select the
column(s) you don't want to display, go to format, column, arrow to hide
and press enter. To unhide them again, select the columns on either side
of the hidden columns, go to format, columns, unhide. It is my belief that
hiddne columns don't print. Just try a page, though, because it is
possible--although of course highly unlikely (smile)--that I am wrong.
Another way to do it, without changing the order of the columns, is to
select only the columns you want to print, and print them.
Or you can create a second spread sheet, tying the columns in that one to
the original sheet (so that column a in the second sheet is identical to
column f in the first sheet, for example) and print the second sheet
instead of the first. That way you could reorder the columns if you chose,
and the data would be consistent on the two sheets.
Good luck!
At 12:11 PM 10/14/2004, you wrote:
>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
--
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:
