Office 2016 For Seniors For Dummies
Book image
Explore Book Buy On Amazon

Many shortcuts are available that can save you time with simple tasks in Excel 2016, such as copying text from one place and pasting it somewhere else in your document. You can use these keyboard shortcuts instead of the Number drop-down list on the Home tab to apply number formatting to cells in Excel 2016.

To apply this number format Use this key combination
General Ctrl+Shift+~
Currency with two decimal places, negative numbers in parentheses Ctrl+Shift+$
Percentage, no decimal places Ctrl+Shift+%
Scientific, two decimal places Ctrl+Shift+^
Date format with day, month, and year Ctrl+Shift+#
Time format with hour and minute, AM or PM Ctrl+Shift+@
Number format, two decimal places, thousands separator, minus sign for negative values Ctrl+Shift+!

About This Article

This article is from the book:

About the book author:

Faithe Wempen a Microsoft Office Master Instructor and the author of over 140 books on computer hardware and software, including Excel 2013 for Dummies eLearning Kit and PowerPoint 2013 Bible. She is also an adjunct instructor of Computer Information Technology at Purdue University and an A+ certified PC technician.

This article can be found in the category: