View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
J Littlebear[_2_] J Littlebear[_2_] is offline
external usenet poster
 
Posts: 1
Default set area in excel not giving me option to set print area?

Thanks, at wouldn't let me click on Clear Print Area either, neither of the
two normal options were highlighted, so they weren't an option.

I got frustrated, took it to a friend more knowledgeable than I -- and I
learned.... in my "Minutes" column I had entered numbers and got the little
triangle indicating I had left a note (but I hadn't). Apparently not having
"told" my computer what kinds of numbers I was using, it (the computer) got
confused and wouldn't let me move on until I'd cleared up all of the little
triangles.

So we went through them 1 by 1 (we could do contiguous cells, but not "those
not connected"...in one swoop. After ignoring all errors, it would again let
me set the print area.

Learn something new every day. Thank you very much. This is my first time
using this service, and it was so helpful knowing I had some of you out there
to assist.

Thanks, thanks, thanks,
Jan

"PlayingToAudienceOfOne" wrote:

Double click on the "File" menu... it will open up more options. You may
want to click on "Clear Print Area" and then reset your new "Set Print Area"

"J Littlebear" wrote:

Been working with excels for several years; today it's not letting me set
print area. File drop-down menu doesn't highlight that as an option so I
can't change print area. Help?
Thanks,