Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Wide Data/Data Next To It
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Wide Data/Data Next To It
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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Wide Data/Data Next To It
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 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Wide Data/Data Next To It
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 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 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to change view so that column widths are all wide enough to show all data? | Excel Discussion (Misc queries) | |||
Wide data range | Charts and Charting in Excel | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Data display | New Users to Excel | |||
format cell data to display stacked data | Excel Discussion (Misc queries) |