Tuesday, December 1, 2009
MS Excel Quick Formatting Tips
3:59 AM | 
Posted by
Sushil
Formatting Data in Excel take hell lot of time. It is therefore necessary for every one to know the quick key sequences. The table below lists such short cut to enable you with some quick data formatting key sequences.
| Task / Objective | Shortcut / Key Sequence |
| Cell Format Cell Dialog (Gives option for various formatting options including fonts, border, color, protection, data type etc.) | [Ctrl] + [1] |
| Bold / Normal (Toggle Key) | [Ctrl] + [2] / [Ctrl] + B |
| Italic / Normal (Toggle Key) | [Ctrl] + [3] / [Ctrl] + I |
| Underline / Normal (Toggle Key) | [Ctrl] + [4] / [Ctrl] + U |
| Strike Out / Normal (Toggle Key) | [Ctrl] + [5] |
| Box the Current Selection | [Ctrl] + [Shift] + [7] or [Ctrl] + [&] |
I hope you found the information useful and Thank you for reading.
Labels:
Auto Complete,
Excel,
Excel 2003,
Excel 2007,
Excel 2010,
Excel Functions,
Grouping Sheets,
MS Excel,
Row Column,
Secret,
shortcuts,
Tips,
Tricks,
workbook,
Worksheet
Subscribe to:
Post Comments (Atom)
0 comments: