You can set the text in horizontal or vertical alignment, change the degree of orientation, wrap, merge or shrink cells, or even modify the direction of the texts. The Alignment tab gives you diverse options to align the texts from the worksheet in different ways. You can click on the options from the category list to apply your preferred format. For instance, you can customize the numbers, currency, date, accounting, time, fraction, percentage, text, etc. The Number tab allows customizing multiple numeric formats with the Format Cells dialog box in Excel. The Format Cells dialog box has six tabs: from the Context Menu, click on the Format Cells command to access the Format Cells dialog box. Press CTRL+1 to open the Format Cells dialog box. Only Use the Dialog Box Launcher button from Font, Alignment, or Number groups. But that button does not open the Format Cells dialog box. 🔖 Note: You will notice a Dialog Box Launcher inside the Clipboard group also. Step_3: Click on the small icon on the right bottom corner of any of the three mentioned groups.Įach of the Dialog Box Launchers allows opening the Format Cells dialog box according to their group relevant tabs. Step_2: Take the cursor on either Font, Alignment, or Number group. You can also click on the Dialog Box Launcher beside the three groups of the Home tab to open the Format Cells dialog box.
The Format Cells dialog box will pop up on the screen.Ģ. Step_3: Now select the Format Cells command from the bottom of the list. Step_2: Then from the Cells group, hit on the Format Drop-down list. You can access the Format Cells dialog box in four ways.