Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel 97 Bible
Taking an Excel Shortcut
Adapted From: Excel 97 Bible

Here is a handful of helpful shortcut keys you can use to keep your fingers on the keyboard as you work on formatting in Excel.

  • Ctrl+1 — Prepares to format the selected object
  • Ctrl+B — Sets or removes boldface
  • Ctrl+I — Sets or removes italic
  • Ctrl+Shift+~ — Applies the general number format
  • Ctrl+Shift+! — Applies the comma format with two decimal places
  • Ctrl+Shift+@ — Applies the time format (hour, minute, a.m./p.m.)

To find out how to have Dummies eTips delivered to your e-mail inbox every week, visit the Dummies eTip Sign-Up Page.
Related Articles
Creating Interactive Web Pages in Excel
Concatenating Text in Excel 2007
Creating Designer Sheets in Excel 2007
Excel Formulas: Leaving Decimals Behind with INT
Finding the Correct Excel Function
Related Titles
Microsoft Office 97 For Windows For Dummies
Microsoft Office 97 For Windows For Dummies : Quick Reference
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference