ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting Cells or Text (https://www.excelbanter.com/excel-discussion-misc-queries/67821-formatting-cells-text.html)

Dave Matthews

Formatting Cells or Text
 

I have two sheets, on sheet Two cells A1, A2 and A3 have the formulas
=Sheet1!A1, =Sheet1!A2 and =Sheet1!A3. For all three formula's there
will be only one result. Is it possible if sheet One has a value in
cell A1 that the description on sheet 2 cell A1 is completly displayed
on not cut off because of the formula in cell A2?

Thanks


--
Dave Matthews
------------------------------------------------------------------------
Dave Matthews's Profile: http://www.excelforum.com/member.php...info&userid=17
View this thread: http://www.excelforum.com/showthread...hreadid=505701


Gary''s Student

Formatting Cells or Text
 
The cells in Sheet1 and Sheet2 do not have to be formatted the same:


Format the three cells in Sheet2 with text wrapping on. This is the best
way to insure that all the material will be visible.
--
Gary's Student


"Dave Matthews" wrote:


I have two sheets, on sheet Two cells A1, A2 and A3 have the formulas
=Sheet1!A1, =Sheet1!A2 and =Sheet1!A3. For all three formula's there
will be only one result. Is it possible if sheet One has a value in
cell A1 that the description on sheet 2 cell A1 is completly displayed
on not cut off because of the formula in cell A2?

Thanks


--
Dave Matthews
------------------------------------------------------------------------
Dave Matthews's Profile: http://www.excelforum.com/member.php...info&userid=17
View this thread: http://www.excelforum.com/showthread...hreadid=505701




All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com