Keyboard Shortcuts: Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
Keyboard Shortcuts: Excel
which includes comma separators and two decimal places (10,000.000), by tapping Ctrl+! (or Ctrl+Shift+1). Change the cell format to Number, Put the cell value in Currency style by pressing Ctrl+$ or Ctrl+Shift+4. Note: This is not the Account format that keeps the dollar sign flush with the left margin. Place the cell value in Percent style with Ctrl+% or Ctrl+Shift+5. Example: To see 45%, type .45. Typing 45 will yield 4500%.
Get weekly updates on breaking news and business advice to help you advance your career! The week's top stories and resources will be sent right to your inbox. Choose the topics you're interested in: