A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing Excel Colmns& Rows / Left To Right 1st across, then nxt l



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 01:21 AM posted to microsoft.public.excel.newusers
Syrahound
external usenet poster
 
Posts: 1
Default Printing Excel Colmns& Rows / Left To Right 1st across, then nxt l

Using Excel, I created an A to Z list of Authors I have read with their
books (Authors ~ Column A/ Books ~ Column B) I was printing with no
difficulty the complete lists (Author #1 w/ Books next to name, then Author
#2 w/ Books and so on..) .
A family member came in and said that the authors/books could be put in
alpha order (either ascending or descending - both authors and their books),
not that I really needed that.
I was told to go to DATA and use that to do the job, which I tried, but
it did not do what was mentioned it would do. Everything looked the same, but
I know I did click on some different things under DATA. Today when I went to
print the lists of the next letters "O" & "P", I got one complete list of the
authors (as they should have looked,) then the names of the respective books
that belonged to them. Not one complete list of author with book(s) but two
seperate lists, authors then book(s).
Please help me to undo what I did last Saturday. I am about to lose it
as I tried to simply open a new Excel Document and make another "O" & "P"
(which would be very tiring and unpleasant but necessary) but when I wrote up
a sample Document with authors and books, the same thing happened... so I
know the Tool Bar settings must be changed somewhere, but I don't know where
or how to change them ( I tried, but am confused) and I do NOT want to ask
this family member again for advice.
How can I get the computer to recognize when printing my documents that
1st it should Print what's in line #1,Column A, then Line #1 Column B, then
go to Line #2 Column A (print if there is something there), then go to Line
#2 Column B, and Print that information etc.....? What do I do to reverse
the things that got changed when I clicked on the Tool Bar? Especially when I
am not sure what was changed?
Any help would be appreciated. Thank You ... Hank M.
  #2  
Old April 17th, 2010, 12:58 AM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Printing Excel Colmns& Rows / Left To Right 1st across, then nxt l

Look at the File -- Page Setup dialogs and on the [Sheet] tab in that
dialog. There is a setting for "Page order" that says to either print
Down (top to bottom, then over and down)
or
Over (left to right, then down)

I'm betting you changed that setting.

"Syrahound" wrote:

Using Excel, I created an A to Z list of Authors I have read with their
books (Authors ~ Column A/ Books ~ Column B) I was printing with no
difficulty the complete lists (Author #1 w/ Books next to name, then Author
#2 w/ Books and so on..) .
A family member came in and said that the authors/books could be put in
alpha order (either ascending or descending - both authors and their books),
not that I really needed that.
I was told to go to DATA and use that to do the job, which I tried, but
it did not do what was mentioned it would do. Everything looked the same, but
I know I did click on some different things under DATA. Today when I went to
print the lists of the next letters "O" & "P", I got one complete list of the
authors (as they should have looked,) then the names of the respective books
that belonged to them. Not one complete list of author with book(s) but two
seperate lists, authors then book(s).
Please help me to undo what I did last Saturday. I am about to lose it
as I tried to simply open a new Excel Document and make another "O" & "P"
(which would be very tiring and unpleasant but necessary) but when I wrote up
a sample Document with authors and books, the same thing happened... so I
know the Tool Bar settings must be changed somewhere, but I don't know where
or how to change them ( I tried, but am confused) and I do NOT want to ask
this family member again for advice.
How can I get the computer to recognize when printing my documents that
1st it should Print what's in line #1,Column A, then Line #1 Column B, then
go to Line #2 Column A (print if there is something there), then go to Line
#2 Column B, and Print that information etc.....? What do I do to reverse
the things that got changed when I clicked on the Tool Bar? Especially when I
am not sure what was changed?
Any help would be appreciated. Thank You ... Hank M.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.