Display complete merge cells

TRS · May 14th, 2002, 06:58 PM

I use templates that I made for entering text in a cell that contains several rows and colums, which are merged. I protected the sheet except for the merged cells that I want to enter text. I use the tab key to go from cell to cell. The problem I have is, only the top part of the merged cell displays. I want to display the complete cell so I can see what I am entering. I am sure this has an easy fix, but so far it has been beyond me.Thanks for any help

[ This Message was edited by: TRS on 2002-05-14 17:59 ]

Brian from Maui · May 14th, 2002, 07:09 PM

Have you tried View/Formula Bar

WayneTN · May 14th, 2002, 07:09 PM

If I understand your situation, you may not have the Word Wrap format selected for the cell where the text is being entered. If this is not the problem, can you give a more specific example? Thanks.

TRS · May 14th, 2002, 07:14 PM

Wayne TN
Yes, word wrap is on and text will wrap to next line, but the merged cell box will not scroll up to display what I am typing.
Thanks

Yogi Anand · May 14th, 2002, 07:17 PM

Wayne is right -- you have to select the 'Wrap text' in FORMAT|CELLS|ALIGNMENT|Text Control
... and you will see more than just one line of text.

Regards!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 06:58 PM	#1
TRS New Member Join Date: May 2002 Posts: 2	I use templates that I made for entering text in a cell that contains several rows and colums, which are merged. I protected the sheet except for the merged cells that I want to enter text. I use the tab key to go from cell to cell. The problem I have is, only the top part of the merged cell displays. I want to display the complete cell so I can see what I am entering. I am sure this has an easy fix, but so far it has been beyond me.Thanks for any help [ This Message was edited by: TRS on 2002-05-14 17:59 ]

May 14th, 2002, 07:09 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Have you tried View/Formula Bar

May 14th, 2002, 07:09 PM	#3
WayneTN Board Regular Join Date: May 2002 Location: Tennessee, USA Posts: 72	If I understand your situation, you may not have the Word Wrap format selected for the cell where the text is being entered. If this is not the problem, can you give a more specific example? Thanks.

May 14th, 2002, 07:14 PM	#4
TRS New Member Join Date: May 2002 Posts: 2	Wayne TN Yes, word wrap is on and text will wrap to next line, but the merged cell box will not scroll up to display what I am typing. Thanks

May 14th, 2002, 07:17 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Wayne is right -- you have to select the 'Wrap text' in FORMAT\|CELLS\|ALIGNMENT\|Text Control ... and you will see more than just one line of text. Regards!