Displayed value (result of formula), not formula in fomula bar
Here's the problem:
My table is very large and the column is not wide enough to show all the text in it. Since the text / value is generated by the formula in the cell, if I click on the cell, the formula will be displayed in the formula bar, not the value. Sure.
However, I think it is very useful to quickly find out the cell content generated by the formula. If I expand the column width, not fast and clean every time.
Do you know if there is a way to solve the problem?
source to share
No, there is no way to show it in the formula bar if there is a formula in the cell.
The best I can suggest is to leave line 1 blank and concatenate A1: N1 together, or similarly, if necessary, lock line 1
then put this formula in A1
=INDIRECT(CELL("address"))
When you select a cell in the sheet, press F9 on your keyboard and you can read the full value of the active cell in row 1
With a little VBA in the sheet, you can also automatically update the cell
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Calculate
End Sub
source to share
Here's another solution. Just assign a key to the following macro:
Sub DislayCellValue()
Dim outp As String
outp = "The value in the active cell is:" & Chr(13) & Chr(13) & ActiveCell.Value
MsgBox Prompt:=outp
End Sub
To display the value in a cell, click in the cell and press Ctrl- (key). This might be helpful.
source to share