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.
No comments:
Post a Comment