This shortcut will apply or remove the bold formatting from the selected cell(s). This shortcut will implement the Number format to the selected cell(s) with two decimal places, thousands separator, and minus sign (-) for negative values. This shortcut will apply the Date format with the dd/mm/yyyy (day, month, and shortcut will apply the Time format to the selected cell(s) with the hour and minute, and AM or PM. This shortcut will apply the Exponential number format to the selected cell(s) with two decimal places. This shortcut will apply the Percentage format to the specified cell(s) with no decimal places. This shortcut will apply the Currency format to your specified cell(s) with two decimal places (negative value are put in parentheses). This shortcut will apply the General number format to the specified cell(s). This shortcut will open the Format Cells dialog window. This shortcut will open the formatting Style dialog window. To make it easy Excel has provided some shortcuts that are listed below: S.NO Shortcut keys to format your Excel dataįormatting in Excel is used to change your data's appearance and make it look more visually pleasing. In this tutorial, we will take a deeper look at all the shortcut keys that will help us quickly work with different advanced topics.

Advanced Excel tools and features are widely used in analysis statistical and data manipulation tasks. But Excel is very vast, and so are their shortcuts. In the previous section, we covered the generic Excel shortcut keys. Next → ← prev Advanced Excel Shortcut keys

Microsoft 2007 excel shortcut keys