Hints and tips home » Excel hints and tips » Apply currency format quickly in Excel
Apply currency format quickly in Excel
To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $
This will apply a pounds symbol even though the $ key is pressed.
Added by Amanda on 23rd November 2006
More Excel hints and tips, like:
- Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines
- How to select certain data in an Excel 2010 workbook
- editing a formula quickly
|
» Forum post: Excel 2003 and Excel 2007 |



Course updates

