This shortcut provides a fast and easy way to manipulate your data with a predetermined format. This predetermined format is one of many that are built into Excel but few users know about it. In the following steps you will learn how to add two decimal places, a thousands separator, and a minus sign for negative values to a specific cells, or range of cells, without opening up the Format Cells dialog box.
Step 1: Select the cells we want to manipulate.
Step 2: This shortcut is found on the “1” key and is labeled “#,###.00”. Looking at our Excel Skin we can see that the text for this shortcut is in white, so we take a look at our modifier keys. The “Control” and “Shift” keys have white text as well. Execute the shortcut by pressing the following keys:
Our data has now been manipulated to have two decimal places, a thousands separator, and a minus sign if a negative value is present.
This shortcut shows one of the many ways to increase efficiency in Excel for Mac. By simply pressing three keys we avoid opening the Format Cells dialog box and the inevitable mouse movement needed to format the cells. Now you can easily reformat your cells to this predetermined format of two decimal places, a thousands separator, and a minus sign if necessary. Enjoy all the free time you just saved!
Comments will be approved before showing up.