Forum Discussion

tcarnahan's avatar
tcarnahan
Copper Contributor
Sep 15, 2021

Is there anyway to determine the formatting used on specific cells

Hi!   I teach Excel to students and have a lot of Excel files to grade.   I can't remember which spreadsheet from times gone by had a feature that was really handy.  You could click on a cell, pr...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Sep 15, 2021

tcarnahan 

Hope in advance that I got it right.
I am not aware of any such keyboard shortcut, but there are keyboard shortcuts to display formulas.

 

Display Excel formulas using keyboard shortcuts
Open Excel and your edited document.
Press the key combination CTRL + Shift + `(Excel 2016) or CTRL + # (Excel 2013).
Now the formulas are displayed in the cells instead of the results. If your cells reference other cells, these will be highlighted in color.
To display the results again, press the same combination again.

 

Or go to Formulas-> Show Formulas.

Individual cell formatting appears in the formula bar.

 

There is also the keyboard shortcut CTRL + 1 for cell formatting.

 

 

I hope that I could help you with this information in your projects.

 

Thank you for your patience and time.

 

NikolinoDE

I know I don't know anything (Socrates)

Resources