Print Preview is blank when it comes up

P

poetessa

Version: Older version
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I typed a spreadsheet of five columns and 103 rows 104 counting the header row. All it is are names and addresses that I was going to merge into labels.

'Print Preview' comes up blank. In 'Page Setup' all of the options have been checked and look fine. I just wanted to print the worksheets to have on hand, but it won't even print, just pulls a blank sheet through the printer.

I've used Excel for years both at work and here at home and have never had this problem before. Any suggestions?
 
B

Bob Greenblatt

Version: Older version
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I typed a spreadsheet of five columns and 103 rows 104 counting the header
row. All it is are names and addresses that I was going to merge into labels.

'Print Preview' comes up blank. In 'Page Setup' all of the options have been
checked and look fine. I just wanted to print the worksheets to have on hand,
but it won't even print, just pulls a blank sheet through the printer.

I've used Excel for years both at work and here at home and have never had
this problem before. Any suggestions?
Is your print area defined to a blank area on the sheet? Check in
Insert-Names-Define to see. Look for the name Print_area. Change the
reference, or delete the name.
 
P

poetessa

Thank you Bob, for the reply. I accessed Insert/Name/Define and deleted everything. I then went back to the worksheet and accessed File/Print/Area and clicked on Clear Print Area.

My worksheet header row is: A - Last Name,, B - First Name, C - Address and D - City, State,Zip. There are 103 rows.

I highlighted A through D and down to row 103, set the print area and then viewed Insert/Name/Define. Under "Names in Workbook it had the header for my A column 'Last_Name; Print area was Sheet 1. In the Refers to box it had the formula: =Sheet1!$A$1:$D$103

I clicked the Print Preview button and there was noting in it? It does not show in Print Preview and it won't print directly from the screen. Any other suggestions?
 
P

poetessa

Thank you Bob, for the reply. I accessed Insert/Name/Define and deleted everything. I then went back to the worksheet and accessed File/Print/Area and clicked on Clear Print Area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top