HOW TO HIGHLIGHT THE FORMULA'S USED IN AN EXCEL SHEET
We can find out all the formulas used in a spreadsheet by clicking "CTRL+~" .But inorder to highlight all the formulas as well as constants used in a spreadsheet by the following method
click any single cell in the spreadsheet .
Click on "HOME" tab -goto the extreme rightcorner "EDITING" Ribbon -Click On "FIND & SELECT"
Click on either "GoTo" or "Formulas" .All the fomulas used cell will be get selected .Then you can Bold the formulas by clicking CTRL+B or Fill Color
We can find out all the formulas used in a spreadsheet by clicking "CTRL+~" .But inorder to highlight all the formulas as well as constants used in a spreadsheet by the following method
click any single cell in the spreadsheet .
Click on "HOME" tab -goto the extreme rightcorner "EDITING" Ribbon -Click On "FIND & SELECT"
Click on either "GoTo" or "Formulas" .All the fomulas used cell will be get selected .Then you can Bold the formulas by clicking CTRL+B or Fill Color
No comments:
Post a Comment