Keeping contents of cell A1 showing when scrolling.
 

I have frozen my row and column panes. But when I scroll right, the entire
contents of cell A1 are not shown.

I only see as much text as is equals the cell width. I have a long text
string as a title for the worksheet and would like it all shown as I scroll.

Ideas anyone? Thanks

Keeping contents of cell A1 showing when scrolling.
 

Widen column A?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"GarnetFlare" wrote in message
...
I have frozen my row and column panes. But when I scroll right, the entire
contents of cell A1 are not shown.

I only see as much text as is equals the cell width. I have a long text
string as a title for the worksheet and would like it all shown as I
scroll.

Ideas anyone? Thanks

Keeping contents of cell A1 showing when scrolling.
 

Format/ Cells/ Alignment/ Wrap text ?
--
David Biddulph

"GarnetFlare" wrote in message
...
I have frozen my row and column panes. But when I scroll right, the entire
contents of cell A1 are not shown.

I only see as much text as is equals the cell width. I have a long text
string as a title for the worksheet and would like it all shown as I
scroll.

Ideas anyone? Thanks

Keeping contents of cell A1 showing when scrolling.
 

Hello David,

I tried it out but all it did was wrap the text within the A1 cell and made
that row quite large.

What I'm trying to do is have about 60 characters displayed and to stay
visiable when navigating the worksheet. I have already locked both panes but
cell A1 will only show what's in it's column width.

The result is an unprofessional looking worksheet. The title slowly
disappears when you scroll to the right.

Increasing the cell width is not a viable option either.

This is really baffling me. But thanks for your suggestion.

Garnetflare
"David Biddulph" wrote:

Format/ Cells/ Alignment/ Wrap text ?
--
David Biddulph

"GarnetFlare" wrote in message
...
I have frozen my row and column panes. But when I scroll right, the entire
contents of cell A1 are not shown.

I only see as much text as is equals the cell width. I have a long text
string as a title for the worksheet and would like it all shown as I
scroll.

Ideas anyone? Thanks

Keeping contents of cell A1 showing when scrolling.
 

Hi Garnet, .

The only thing I know that will float over a worksheet is a toolbar.
Maybe if you try in the customisation group someone will know
how to reformat the appearence of a toolbar to emulate a text box.

Just a passing thought
Martin