In the previous version Microsoft Excel 2007, we will do formatting cells by right-clicking the selected cell and choosing Format Cells…
The steps above still working in Microsoft Excel 2007, but do you know there is an easy way to format the cells in Excel 2007?, you can save your time from manual steps to format the cells just for one click.
You can format the cells by clicking shortcut in the ribbon
1. Open your Microsoft Excel 2007
2. Click dropdown “General” Box in Home Tab (see the picture below)
3. Now you can select format cells from the list
If you want to format cells using keyboard shortcuts, you can apply the following keyboard shortcuts to format the cells:
Apply Currency format [Ctrl][Shift] $
Apply Percentage format [Ctrl][Shift] %
Apply Date format [Ctrl][Shift] #
Apply Time format [Ctrl][Shift] @
Apply Number format [Ctrl][Shift] !
Apply Exponential number format [Ctrl][Shift] ^
Related Topics :
How to configure Word, Excel 2007 options to save file into 97-2003 format?
Easy way to copy one cell to a lot of cells in Excel
How to set, change or remove password a document, workbook or presentation in Microsoft Office
How to Formatting Cells Values in Microsoft Excel 2007
Minimize the Ribbon for wider work area in Microsoft Office
Customizing a Quick Access Toolbar in Word 2007
How to preview the word documents without opening?
How to Change Saving Default File Location in MS Word 2007
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
No comments:
Post a Comment