1. Open an excel table and click the "Cell Style" button in the home tab style group to expand the cell style drop-down menu.
2. In the "Custom" area of the drop-down menu, right-click the cell style to be modified to pop up the right-click shortcut menu.
3. Click Modify on the shortcut menu to open the Style dialog box.
4. In the Style dialog box, click the Format button to open the Cell Format dialog box.
5. In the Format Cell dialog box, modify the format contained in the cell style, such as adding a background color, and then click OK to return to the Style dialog box.
6. Click OK in the Style dialog box to close the dialog box.
After reading my method, have you learned to adjust the excel table format now? If you learn it, share this method quickly, so that more people know how to adjust the excel table format. These are the steps to adjust the format of excel tables.
This paper is based on Dell brand, Windows 10 system and Excel20 10 version.