Most noteworthy, this “1” key also has the Exclamation Symbol “!” with it, above the letter “Q” key. Above all, the another important Shortcut Key for the Format Cells Dialog Box is the “Ctrl+1” keys. And, finally are the three tabs from the Border till the Protection tabs. Format Cells dialog box Microsoft Excel 2016 So, apart from these, the other tabs of the Format-Cell dialog box are the Border settings tab, the Fill settings tab and the Protection settings tab. Thirdly, the Number group opens up the Number Format dialog box. And, no shortcut is assigned for this box. Secondly, the Alignment group launches Alignment Settings dialog box. And the Shortcut Key for this is ( Ctrl+Shift+F). Firstly, as the Font group opens the Font Settings dialog box.

It means, w hen each one of the group’s Dialog box launcher buttons’re clicked they open the tabs which have the options related to that group only, in the Format-Cells dialog box. Format Cells dialog box Microsoft Excel – continued Except the Clipboard group’s Dialog box launcher button all other group’s show the associated tab related to the group in the Format Cells dialog box. And, they are located at the very bottom right side corner in each one of the groups.Īlso, the buttons are very small in size. So, the second, third and the fourth groups of the Home tab have the Dialog box launcher buttons. Also, the rest others are the Number group, Styles group, Cells group and the Editing group.

They are the Clipboard group, Font group, and the Alignment group etc.

Also, it has been in this software program from the earlier versions as well. In Microsoft Excel, the Format Cells Dialog Box plays a very important & vital role. See Previous Post: Merge Center buttons Alignment group Microsoft Excel 2016

What is a dialog box launcher in excel