Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rosemary
 
Posts: n/a
Default Some cells in my spreadsheet are not printing.

Some cells in my spreadsheet are not printing. I can see them on the screen
and in the print preview, but they do not appear on the printout. I've
copied the formatting from cells that are working, but they still do not
print.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Some cells in my spreadsheet are not printing.

Most similar problems are covered on by colors.htm page, under problems, but you've
already indicated problem beyond what I have there and on the colors_print.htm page.

Copying the formats from cells that work on the same sheet should cover text that is not black in color.
as you also said:
Displays -- okay
Print Preview -- okay
Printing -- some cells okay, some don't

Assuming that your files have .xls extension, I can't think of anything. Even if they weren't
I can't think of anything but HTML could offer surprises...

I think you've covered not B&W option in page setup, not disability High Contrast option,
and because you can see in display it is not Conditional Formatting.
I don't see anything different for Format, styls involving printer and would be
surprised if anything changed in Excel 2003, which I wouldn't have read about
in the newsgroups. You covered very well what you'd tried you did miss specifying your version.

The only thing I can think of is cells outside of your print area range do not print,
Since you did not indicate that the nonprinting cells were scattered, that's a possibility
as there can only be one print range...
File, Print Area make sure there is nothing specified

Someone could get creative with Event Macros, and printing.
Check the worksheet, right click on sheet tab, then view code.
Check the workbook, right click on Excel logo to left of your menus, view code.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rosemary" wrote in message ...
Some cells in my spreadsheet are not printing. I can see them on the screen
and in the print preview, but they do not appear on the printout. I've
copied the formatting from cells that are working, but they still do not
print.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Printing Spreadsheet Alex Ackley Setting up and Configuration of Excel 3 October 25th 05 09:32 PM
Can I sort excel spreadsheet data by fill color of cells? Fashionheadhunter Excel Discussion (Misc queries) 2 September 7th 05 01:35 AM
Linking from several cells of 1 spreadsheet to fewer of another? wildsngrny Excel Worksheet Functions 1 June 1st 05 01:54 AM
make my spreadsheet at 10% to all cells jenshakay1972 Excel Worksheet Functions 2 March 22nd 05 10:30 PM
make my spreadsheet at 10% to all cells jenshakay1972 Excel Worksheet Functions 1 March 22nd 05 10:27 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"