Choose the range of cells you’d want to format. Go to Home, then Format as Table. Select table style having alternate rows of shading. Select the table, click Design, and then uncheck the Banded Rows box and check the Banded Columns box to change the shading from rows to columns.