How to globally insert $ signs in front of all cell refereces?
This helps to change cell references in what manner?
Gord Dibben MS Excel MVP
On Mon, 10 May 2010 11:46:01 -0700, trip_to_tokyo
wrote:
EXCEL 2007
"If anyone knows of a way to change the entire spreadsheet to insert the $
signs into each cell reference"
1. Click on, "cell" to left of letter A and above the number 1 to highlight
whole Worksheet.
2. Home tab / Font group / click on arrow in lower right hand corner /
Format Cells should launch / Number tab / Currency - in here select the
dollar sign that you want and hit OK.
3. Now type any number into any cell and it will be pre-fixed with the
dollar sign.
If my comments have helped please hit Yes.
Thanks.
|