| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| A challenge: referencing cell contents in nested function formula | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| showing the contents of a consolidated cell | Excel Worksheet Functions | |||
Linear Mode
