Excel 2007 : show formula by value, not by cell name, CAN?

**chiwing** · 02-10-2011, 04:15 AM

d1 cell is a1/b1+c1
but i want to show it by 4500 /2+ 5000,
how to do it?

thx~ ~

**TMS** · 02-10-2011, 05:06 AM

=A1&"/"&B1&"+"&C1

Regards

**chiwing** · 02-11-2011, 05:53 AM

THANKS FOR TMShucks
BUT HOW TO SHOW THE RESULT OF THE FORMULA(=A1&"/"&B1&"+"&C1)
ANY SHORTCUT KEY , LIKE CTRL `
CTRL ` ONLY SHOW THE CELL NAME , NOT VALUE !

I WANT TO DO THIS BECAUSE IT CAN HELP ME DEBUG EASILY , DON'T NEED TO REFER WHAT THE CELL IS ABOUT

MY .XLS IS VERY LARGE, IN COLUMN UP TO DA, IN ROW UP TO 1800
THANKS

**TMS** · 02-11-2011, 07:20 AM

Maybe:

Tools | Formula Auditing | Evaluate Formula.

Regards

**scottylad2** · 02-11-2011, 07:33 AM

Pressing Ctl + Tilda will display the formulas in a spreadsheet, pressing again will restore back to hiding them.

Pressing Alt then TUF is the keyboard shortcut for formula Auditing/evlaluation, which is what I think you want