ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when displaying formulas, how to start a new line in the same cel. (https://www.excelbanter.com/excel-discussion-misc-queries/1381-when-displaying-formulas-how-start-new-line-same-cel.html)

EL

when displaying formulas, how to start a new line in the same cel.
 
In the displaying formulas mode, if the formula is too long, how to start a
new line in the same cell so that the formulas can be printed in one page.
(Alt + enter won't work in formula mode)

Frank Kabel

Hi
AFAIK the only thing you could do is copy the formula as 'Text' (e.g.
put an apostrophe in front of the formula) and then use aLT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"EL" schrieb im Newsbeitrag
...
In the displaying formulas mode, if the formula is too long, how to

start a
new line in the same cell so that the formulas can be printed in one

page.
(Alt + enter won't work in formula mode)




All times are GMT +1. The time now is 01:11 AM.

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