PC Review


Reply
Thread Tools Rate Thread

Printing highlighted cells

 
 
Shelley
Guest
Posts: n/a
 
      15th Mar 2006
Hi - I'm doing a spreadsheet and am high-lighting certain rows which I need
to emphasise on the printed copy
but although they appear high-lighted (yellow) on my screen, this does not
show on the hard copy. Am I perhaps doing something wrong or is it not
possible to print high-lighted cells in an Excel spreadsheet?

Thanks.
Shelley


 
Reply With Quote
 
 
 
 
Paul B
Guest
Posts: n/a
 
      15th Mar 2006
Shelley, you will need to fill the cells with a color, format, cells,
patterns, pick a color, or click on the button that looks like a paint can
on the tool bar

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Shelley" <(E-Mail Removed)> wrote in message
news:dv7igh$7h2$(E-Mail Removed)...
> Hi - I'm doing a spreadsheet and am high-lighting certain rows which I

need
> to emphasise on the printed copy
> but although they appear high-lighted (yellow) on my screen, this does not
> show on the hard copy. Am I perhaps doing something wrong or is it not
> possible to print high-lighted cells in an Excel spreadsheet?
>
> Thanks.
> Shelley
>
>



 
Reply With Quote
 
New Member
Join Date: Mar 2006
Location: Brisbane, Australia
Posts: 3
 
      15th Mar 2006
Shelley,

If printing in black & white, yellow is probably not the best colour to use. Try a darker shade (Tan or Gold should be ok) or a grey shade

regards,
JimJim
 
Reply With Quote
 
Shelley
Guest
Posts: n/a
 
      15th Mar 2006
Paul, Thanks. I had tried that already (with the little paint can on the
toolbar and again just now the way you suggested) and although the
high-light colour appears on the screen just how I want it to appear on the
hard copy, when I print the spreadsheet out on the printer the background
high-light colour doesn't show. I've tried doing this at work and also on my
home pc in case it was a printer problem but I cant get it to print on
either!

Shelley

"Paul B" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Shelley, you will need to fill the cells with a color, format, cells,
> patterns, pick a color, or click on the button that looks like a paint can
> on the tool bar
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Shelley" <(E-Mail Removed)> wrote in message
> news:dv7igh$7h2$(E-Mail Removed)...
>> Hi - I'm doing a spreadsheet and am high-lighting certain rows which I

> need
>> to emphasise on the printed copy
>> but although they appear high-lighted (yellow) on my screen, this does
>> not
>> show on the hard copy. Am I perhaps doing something wrong or is it not
>> possible to print high-lighted cells in an Excel spreadsheet?
>>
>> Thanks.
>> Shelley
>>
>>

>
>



 
Reply With Quote
 
Paul B
Guest
Posts: n/a
 
      15th Mar 2006
Shelley, try file, page setup, sheet, look under print and see if black and
white is checked, if so uncheck it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Shelley" <(E-Mail Removed)> wrote in message
news:dv8l3h$nie$(E-Mail Removed)...
> Paul, Thanks. I had tried that already (with the little paint can on the
> toolbar and again just now the way you suggested) and although the
> high-light colour appears on the screen just how I want it to appear on

the
> hard copy, when I print the spreadsheet out on the printer the background
> high-light colour doesn't show. I've tried doing this at work and also on

my
> home pc in case it was a printer problem but I cant get it to print on
> either!
>
> Shelley
>
> "Paul B" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Shelley, you will need to fill the cells with a color, format, cells,
> > patterns, pick a color, or click on the button that looks like a paint

can
> > on the tool bar
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Shelley" <(E-Mail Removed)> wrote in message
> > news:dv7igh$7h2$(E-Mail Removed)...
> >> Hi - I'm doing a spreadsheet and am high-lighting certain rows which I

> > need
> >> to emphasise on the printed copy
> >> but although they appear high-lighted (yellow) on my screen, this does
> >> not
> >> show on the hard copy. Am I perhaps doing something wrong or is it not
> >> possible to print high-lighted cells in an Excel spreadsheet?
> >>
> >> Thanks.
> >> Shelley
> >>
> >>

> >
> >

>
>



 
Reply With Quote
 
Shelley
Guest
Posts: n/a
 
      15th Mar 2006
Paul,

Arghhh! I just don't believe it.....................I did what you said and
the black and white box wasn't checked so I thought I'd just "have another
go" and used a different colour and........yep, it worked! The yellow ink
cartridge is empty here at work - and obviously there's a problem with my
home printer yellow ink too, probably a clogged head as I don't use it much.
I feel so foolish. Thank you SO much for your help which I really do
appreciate and I'm so sorry for wasting your time.

Shelley (hanging head in embarrassment)


"Paul B" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Shelley, try file, page setup, sheet, look under print and see if black
> and
> white is checked, if so uncheck it
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Shelley" <(E-Mail Removed)> wrote in message
> news:dv8l3h$nie$(E-Mail Removed)...
>> Paul, Thanks. I had tried that already (with the little paint can on the
>> toolbar and again just now the way you suggested) and although the
>> high-light colour appears on the screen just how I want it to appear on

> the
>> hard copy, when I print the spreadsheet out on the printer the
>> background
>> high-light colour doesn't show. I've tried doing this at work and also on

> my
>> home pc in case it was a printer problem but I cant get it to print on
>> either!
>>
>> Shelley
>>
>> "Paul B" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > Shelley, you will need to fill the cells with a color, format, cells,
>> > patterns, pick a color, or click on the button that looks like a paint

> can
>> > on the tool bar
>> >
>> > --
>> > Paul B
>> > Always backup your data before trying something new
>> > Please post any response to the newsgroups so others can benefit from
>> > it
>> > Feedback on answers is always appreciated!
>> > Using Excel 2002 & 2003
>> >
>> > "Shelley" <(E-Mail Removed)> wrote in message
>> > news:dv7igh$7h2$(E-Mail Removed)...
>> >> Hi - I'm doing a spreadsheet and am high-lighting certain rows which I
>> > need
>> >> to emphasise on the printed copy
>> >> but although they appear high-lighted (yellow) on my screen, this does
>> >> not
>> >> show on the hard copy. Am I perhaps doing something wrong or is it
>> >> not
>> >> possible to print high-lighted cells in an Excel spreadsheet?
>> >>
>> >> Thanks.
>> >> Shelley
>> >>
>> >>
>> >
>> >

>>
>>

>
>



 
Reply With Quote
 
Paul B
Guest
Posts: n/a
 
      15th Mar 2006
Shelley, your welcome, if it happens again you will know what to check

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Shelley" <(E-Mail Removed)> wrote in message
news:dv938t$gu1$(E-Mail Removed)...
> Paul,
>
> Arghhh! I just don't believe it.....................I did what you said

and
> the black and white box wasn't checked so I thought I'd just "have another
> go" and used a different colour and........yep, it worked! The yellow ink
> cartridge is empty here at work - and obviously there's a problem with my
> home printer yellow ink too, probably a clogged head as I don't use it

much.
> I feel so foolish. Thank you SO much for your help which I really do
> appreciate and I'm so sorry for wasting your time.
>
> Shelley (hanging head in embarrassment)
>
>
> "Paul B" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Shelley, try file, page setup, sheet, look under print and see if black
> > and
> > white is checked, if so uncheck it
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Shelley" <(E-Mail Removed)> wrote in message
> > news:dv8l3h$nie$(E-Mail Removed)...
> >> Paul, Thanks. I had tried that already (with the little paint can on

the
> >> toolbar and again just now the way you suggested) and although the
> >> high-light colour appears on the screen just how I want it to appear on

> > the
> >> hard copy, when I print the spreadsheet out on the printer the
> >> background
> >> high-light colour doesn't show. I've tried doing this at work and also

on
> > my
> >> home pc in case it was a printer problem but I cant get it to print on
> >> either!
> >>
> >> Shelley
> >>
> >> "Paul B" <(E-Mail Removed)> wrote in message
> >> news:%(E-Mail Removed)...
> >> > Shelley, you will need to fill the cells with a color, format, cells,
> >> > patterns, pick a color, or click on the button that looks like a

paint
> > can
> >> > on the tool bar
> >> >
> >> > --
> >> > Paul B
> >> > Always backup your data before trying something new
> >> > Please post any response to the newsgroups so others can benefit from
> >> > it
> >> > Feedback on answers is always appreciated!
> >> > Using Excel 2002 & 2003
> >> >
> >> > "Shelley" <(E-Mail Removed)> wrote in message
> >> > news:dv7igh$7h2$(E-Mail Removed)...
> >> >> Hi - I'm doing a spreadsheet and am high-lighting certain rows which

I
> >> > need
> >> >> to emphasise on the printed copy
> >> >> but although they appear high-lighted (yellow) on my screen, this

does
> >> >> not
> >> >> show on the hard copy. Am I perhaps doing something wrong or is it
> >> >> not
> >> >> possible to print high-lighted cells in an Excel spreadsheet?
> >> >>
> >> >> Thanks.
> >> >> Shelley
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>

> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting highlighted cells or font color cells Tired Dan Microsoft Excel Discussion 0 10th Dec 2007 11:50 PM
counting highlighted cells or font color cells Tired Dan Microsoft Excel Discussion 0 10th Dec 2007 11:41 PM
Highlighted Cells and Printing - Excel 2000 =?Utf-8?B?RGFybGVuZQ==?= Microsoft Excel Misc 2 6th Sep 2007 08:32 PM
cells highlighted and unable to remove highlighted debbie Microsoft Excel Worksheet Functions 1 3rd Oct 2004 06:48 AM
Re: Printing Highlighted cells Ron de Bruin Microsoft Excel Misc 0 24th May 2004 05:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:58 PM.