Excel Questions 10Points in Cash ;)?

Question

Hi I have two questions about Excel:
1) suppose we selected WRAP TEXT and are writeing...now is it possible for us to press ENTER and NOT go to the next CELL and remain in the same cell but go to the NEXT LINE? just like a notepad or sth? ...so to press enter in a cell and instea of going to the next cell, stay at the same cell but go the next line
2) suppose we need to write a detailed formula in a cell eg 2*2 + 3 = 7, is it possible to make excel write the answer in the end of the equation and display the whole equation? NOT like = 6+3 and the excel will say 9 but like THIS >>> we write 6+3= and excel writes 9 in the end...
THANKS ALOT

Answer 1

1) Yes, just press left alt+enter instead of just enter. (The right alt won't work).



2) Not really. You can fake it by filling cells with the arguments and adding them up in a different cell and display the operators as text in between.

There is a tool called Solver, but that is way way too complicated for what you're trying to achieve. I've added a tutorial link in case you want to get dirty with Solver.

Answer 2

1) Try Alt Enter

Keep in mind the older versions of Excel has a 1024 character limit in the display and pretty sure in the printing of a single cell. 32k of characters will display in the formula bar on the top. Not sure if that was fixed in 2007 or 2010 Excels.



2) Formula would need to be text string in one cell ending with equal sign and the cell to the right would need the real formula starting with the equal sign. So in like A1 have

2*2 + 3 =

and that is formatted as a text string and in A2 have

=2*2+3

and probably have that left justified for alignment.

Answer 3

Well!!!!!!



Sighting your Question after a long time!!!!!!!!



#1 : Use Alt + Enter



#2: I think you meant as below..



We have two cells A and B containing numbers and one more cell C containing the formula



Then,



to display so in another Cell D:



You have to type as follows:



= A1 & "(Fun)" & "B" & "=" & (A1 Fun B)



For instance,



6+ 3 = 9



To get it, formula in D:



= A & "+" & B & "=" & A+B



==> 6 + 3 = 9



Similarly,



= A & "x" & B& "+" & C & "=" & A*B+C



==> 2 x 2 + 3 = 7



Note:

I have left spaces intentionally to make you know the method correct..

Dont leave so in Excel!!

But, if you want a space, have one space in brackets " "