Hovering over the Theme’s Tools in the Themes Group will give you a preview of how they will look on your worksheet. To add Themes to your workbook, ensure that the data is in a table and the style is ...

The Theme option will be greyed out if the worksheet is password-protected. So, you should unprotect the worksheet to allow the theme option to be displayed. If the worksheet contains conditional ...