Format an Excel table by applying different table styles or colors.
To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing …