Setting print area

[Kevin Nelson]

ok, here is the problem. i am new to macs and the one at work is the first
that i have used. i dove in and tried to create a spreadsheet in excel for
mac. when i went to set the print area the program turned each cell into
it's own page. luckily it was a small worksheet so i cleared the whole thing
and did it again. once more it turned each cell into a page. good thing that
there are pc's that i can use in the office. can anyone help me as to why
the same command that works on a pc goes totally off the wall with a mac?

kevin nelson

 

[Bernard Rey]

Kevin Nelson wrote :

ok, here is the problem. i am new to macs and the one at work is the first
that i have used. i dove in and tried to create a spreadsheet in excel for
mac. when i went to set the print area the program turned each cell into
it's own page. luckily it was a small worksheet so i cleared the whole thing
and did it again. once more it turned each cell into a page. good thing that
there are pc's that i can use in the office. can anyone help me as to why
the same command that works on a pc goes totally off the wall with a mac?

Could you mention which version of Excel (and Mac OS) you are running? And
if you have applied the updates? I never came across a situation like the
one you describe... What version of Excel are the PC running, and is there
some specific content (macros, "ActiveX" controls) in that sheet (and how
about other workbooks/sheets)?

 

[Kevin Nelson]

Kevin Nelson wrote :


Could you mention which version of Excel (and Mac OS) you are running? And
if you have applied the updates? I never came across a situation like the
one you describe... What version of Excel are the PC running, and is there
some specific content (macros, "ActiveX" controls) in that sheet (and how
about other workbooks/sheets)?

With much digging I find that the os is 9.1 us. And it is Excel 98 for mac.
There are no fancy macros, activex or huge formulae. I was simly trying to
workout my timesheet. How many hours, how much per hour, days worked, that
sort of thing. There were no functions or hidden sheets. Just numbers. And
there was only one worksheet as I got rid of the other two.

As for updates, they are quite strict and any updating is done by the IT
department so I have no idea no inclination to start playing around with the
inner workings.

The Excel version on the pc is 2000. I use 2000 at home and 98 at the school
where I do part-time work. The 98 at school does not do this and the 2000 I
have at home works fine too.

Hope you figure it out, because I will be using the pc for excel.

Kevin Nelson

 

[Jan Leijenhorst]

Kevin,

Sorry to be a bit basic:
Did you use 'print one copy'
or did you use 'Print...' and get a job set up and so on?
Excel stores some info of the printer settings in the file,
so a file from PC has no Mac printer settings.
Print one copy uses the last setting.
The margins are relative to the page size.
If there is no valid page size what should it take?
Have you set up the printer?
There should be a default printer.
Then do a page setup and select the size available on the printer.
In the page setup is a button 'Options', click open and do review /alter the
settings.
Then do a Print... Fill Copies: 1 and so on
(Do NOT yet use the Print One Copy)

Hope this helps,
Jan

 

[Kevin Nelson]

Kevin,

Sorry to be a bit basic:
Did you use 'print one copy'
or did you use 'Print...' and get a job set up and so on?
Excel stores some info of the printer settings in the file,
so a file from PC has no Mac printer settings.
Print one copy uses the last setting.
The margins are relative to the page size.
If there is no valid page size what should it take?
Have you set up the printer?
There should be a default printer.
Then do a page setup and select the size available on the printer.
In the page setup is a button 'Options', click open and do review /alter the
settings.
Then do a Print... Fill Copies: 1 and so on
(Do NOT yet use the Print One Copy)

Hope this helps,
Jan

I did not print anything. What I did was to set the print area (file-print
area-set print area) and then a print preview (file-print preview). That is
how I ended up with each cell as it's own page. TWICE! it was not a pc excel
file and there was a printer already installed as a default.

Anyway thanks for all the replies, I will still be using the pc for excel
work.

kevin

 

[Bernard REY]

Hello Kevin (if you're still around),

Well I tried and tried and never ever could re-create the case you describe.
In fact the only case when I get more sheets printed than expected is when I
set the printing area combining multiple disjointed selections (holding down
the Command Key). But I suppose this is not what you did (you would have
noticed...)

If the content isn't too confidential, would you send the sheet over so I
could have a look at it?


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.

--
Bernard Rey - Toulouse / France
MVP - Macintosh



Kevin Nelson wrote :