This is the 7th part of shortcuts explanation series used in Microsoft Excel 2016. I will be explaining shortcuts for different Styles in this post. I hope this will help you become more efficient user in Excel. Like before I have tested all of these shortcuts in latest version of MS Excel 2016.
Note; If you are following my posts you don’t need to re-read the following points.
Points to consider:
Some of these shortcuts might not work in all versions of Microsoft Excel.
Device without function keys (F1-F12) on its keyboard i.e. Chromebook, certain shortcuts will not work for you.
The plus sign means you have to press both mentioned keys together.
Alt+’ Cell Style
This shortcut will bring Format Style dialog box like below.
- This dialogue box tells you about the cell style it is using as in the above name the Style name is “Normal”.
The generic shortcut for changing cell style is “Alt Then H Then J” ,Pressing the shortcut will bring following window.
- Here you have plenty of cell styles to choose from each with slightly different format settings.
- Use these style to quickly format a cell or create a new style you often use to greatly reduce cell formatting time.
Ctr+T Table Format
Use this shortcut to quickly create a table.
- If your selected data has headers, then use the option “My table has headers” otherwise untick the option.
This trick will quickly create the table by the default style which you can always change from the provided styles or create your own.
- You can always remove the table format from your data by simply converting it to simple range without losing any of your data.
- Use Alt then JT Then G or click on Tables tools design and select convert to range in tools section.
- However, if you remove the table then you will lose table capabilities although the formatting will be remained.
- You can use this feature just to format your data in table style and then simply convert t range to use this formatting style.
Also you can always use the generic shortcut “Alt then H Then T” to convert data into table too here like in following screenshot.
- Here you have many styles to choose from and of course you can create your own Table Style.
In new style creation you will have following window.
- Here you can set different formatting style for each element of your table i.e. First column Header Total row etc.
- Also you can make this style your default table style by ticking the box highlighted in Red box in above screenshot.
Conditional Formatting “Alt Then H Then L”
- Select a range of data and use the above generic shortcut to open conditional formatting options.
Perhaps the most used conditional formatting is highlighting cells with duplicate values.
- You can either use the existing rules create new one or even use a formula for your new conditional formatting.
- This tool helps in i.e. finding duplicates in any given range.
- This formatting helps in visually identifying any shortcomings like identifying a person with less sales in a given range.
For Example looking at following screen shot you can quickly identify which sales person has brought more revenue without looking at actual figures.