Can't see what in the first row, it's filled up

[kevs1]

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

The difficulty of this software never ceases to amaze me.
I have a row that has gotten a bit thick, nothing too crazy.
But as I pull down the row to make new room, plenty of white space goes above the text, (where I don't need it), but none below.
Format, row, height, increasing size - same thing.
I finally fixed it somehow, but When it prints it cuts off last two lines even though, they are visible on workbook and on formula bar. Totally bizarre.
auto fit does not help either. I'm frazzled, very weird.

 

[Bob Greenblatt]

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

The difficulty of this software never ceases to amaze me.
I have a row that has gotten a bit thick, nothing too crazy.
But as I pull down the row to make new room, plenty of white space goes above
the text, (where I don't need it), but none below.
Format, row, height, increasing size - same thing.
I finally fixed it somehow, but When it prints it cuts off last two lines even
though, they are visible on workbook and on formula bar. Totally bizarre.
auto fit does not help either. I'm frazzled, very weird.

Well, I guess we're even. The difficulties you are having with this program
never ceases to amaze me either.

The text is bottom aligned. Highlight the row and align the text at the top.
Why it does not print as it appears is most likely an issue with your
printer/print driver. Make sure you have the latest driver from the
manufacturer.

 

[kevs1]

Thanks, Bob, well what still bizarre, is that even if I change it to center or Top aligned, the text I see in the cell -- the last two lines are gone -- you seem them in formula bar but not in cell -- even though now there is plenty of white space at the end!

 

[Bob Greenblatt]

Thanks, Bob, well what still bizarre, is that even if I change it to center or
Top aligned, the text I see in the cell -- the last two lines are gone -- you
seem them in formula bar but not in cell -- even though now there is plenty of
white space at the end!

How much text is in the cell? Excel will only display the first 1024
characters.

 

[kevs1]

Charaters with space is 1204.

So that's it?

Admittley, this is the biggest cell I've had, but what a silly rule?

Why the limitation? Very bizarre.

 

[CyberTaz]

Hi kevs;

I truly sympathize with your difficulties & am not being snide or sarcastic,
but based on the nature of your problems & your descriptions of what's
contributing to them I can't help but think that it may be time to approach
from a more global direction Perhaps Excel just *isn't* the right
program for the type of use you're attempting to challenge it with. In fact,
you seem to have a unique situation for which there may be no commercially
packaged or "boxed" solution. A different program may be more appropriate &
you may even need to enlist the assistance of a consultant to help you
customize whatever program most closely meets your requirements.

No matter how good a program is for its designed purposes it has
limitations. If you attempt to use it for projects that fall outside that
program's constraints there will be obstacles - and the further beyond what
the program is designed to do the more customization is required & the more
insurmountable those obstacles become. I get the impression that your intent
may be completely off Excel's radar or at the very least needs the direct
efforts of a professional who knows the software & understands your needs in
order to develop a customized solution.

I also get the impression that a large part of your frustration comes from
the likelihood that you're attempting to design your application "on the
fly". Doing so is always a haphazard approach because each new challenge you
attempt to resolve may very well contradict something that's previously been
done... Or perhaps what's already been done complicates or even prevents
what you want to do further down the line. You - or someone else - needs to
step back, analyze your overall requirements & design an application that
works for you.

Please don't be offended or insulted by my suggestions. We all have areas in
which we have expertise & areas in which we have varying levels of
"competency". When we get in over our heads in those peripheral areas it may
be time to call in a pro It's extremely difficult to develop expertise
in another field while we're attempting to simultaneously integrate that new
expertise into our Day Job.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

BOB, just becuase I'm frustrated often with Excel does not mean I don't love it. It's a singular application.
That said it very stubborn and has a lot of bizaarre irrational things in it.