TOOL OF THE MONTH

Microsoft Excel 2003 – Formatting Shortcuts

Action

Shortcut

Display the Format Cells dialog box

[Ctrl] 1

Add an outline border

[Ctrl][Shift] &

Remove the outline border

[Ctrl][Shift]

Apply or remove bold formatting

[Ctrl] B

Apply or remove italic formatting

[Ctrl] I

Apply or remove underlining

[Ctrl] U

Assign the general format

[Ctrl][Shift] ~

Assign the currency format

[Ctrl][Shift] $

Assign the percentage format

[Ctrl][Shift] %

Assign the exponential format

[Ctrl][Shift] ^

Assign the date format

[Ctrl][Shift] #

Assign the time format

[Ctrl][Shift] @

Insert the current date

[Ctrl] ;

Insert the current time

[Ctrl][Shift] :

This entry was posted in August 2006, Newsletter and tagged . Bookmark the permalink.

Leave a Reply