set area in excel not giving me option to set print area?

[J Littlebear]

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,

 

[PlayingToAudienceOfOne]

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]

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

 

[Gord Dibben]

Which version of Excel are you running that opens up more options when you
double-click on "File"?

Any version I have used reacts to only a single left-click to drop down.


Gord Dibben MS Excel MVP