Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Click the drop-down arrow to the right of the Bottom Border button in the Font part of the Ribbon toolbar. Click "All Borders." A border is displayed around all borders of each cell you selected.

Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but it can be helpful in other circumstances as well.