Format Cells Dialog Box Options. The Format Cells dialog box is launched by one of the following several methods. Number Alignment Font Border Patterns and Protection.
In the dialog box type the text and select desired formatting. Press Ctrl 1 Right-click on a cell or press Shift F10 then select Format Cells from the list Home tab à Cells group à Format button à Format Cells. When it comes to changing date format of a given cell or range of cells the easiest way is to open the Format Cells dialog and choose one of the predefined formats.
Number Alignment Font Border Fill and Protection.
Format Cells Dialogue Box. You can open it by selecting the More Borders option from the border buttons dropdown menu. Since Excel protects all the locked cells only having the linked cell unlocked still makes it work. The dialog box includes six tabs.