Thanks for feeding back - I did warn you that neither of the two
options would give you what you really wanted, but they were
alternative ways of seeing the entries.
Pete
On Dec 12, 12:14 pm, HamRadioResources.com
<HamRadioResources...@discussions.microsoft.com> wrote:
> Thanks for the input. I have tried the wrap text. That's not bad, but it
> does waste paper space thus driving cost. Also, I suspect that a long name
> could be wrapped in the middle of it. Shrink to fit was pretty funny - need
> a spy glass to see it... but it DOES fit!
> --
> Owner
> HamRadioResources.com
>
>
>
> "Pete_UK" wrote:
> > You could format A1 to Wrap text or Shrink to fit on the Alignment tab
> > of the format dialogue. However, neither of these will give you the
> > effect you are looking for.
>
> > Pete
>
> > On Dec 12, 1:27 am, FindMyDates.com
> > <FindMyDates...@discussions.microsoft.com> wrote:
> > > I have, say, cell A1 which has a string of say 25 characters in it. The cell
> > > is say 10 characters wide. I can't change the width of the cell for various
> > > reasons. In cell B1 say is an =IF that says, if there's data in A1, set B1 =
> > > "". Inspite of the fact that this should evaluate to a null, only 10
> > > characters of A1 will display.
>
> > > I'm pretty sure there's no way around this one, but thought that I would
> > > check. What I need to do is display A1 over the top of B1... I think the
> > > issue is there is a formula in B1, so Excel won't let A1 display over the top
> > > of it. I went through all the menu and function options. Anything I missed?
>
> > > --
> > > Thanks in advance!
> > > Owner
> > > HamRadioResources.com- Hide quoted text -
>
> - Show quoted text -
|
