Most beginners would love the second method as it’s easy and fast.
Sorting and filtering will not affect your spreadsheet in any way when using a table style format.
To do so, all you have to do is click on the ‘Format as Table’ button and select your table style of choice.
You will then be asked about the range of your table and whether or not your table has headers.
By default, all the rows and columns that have data will be selected.
Click on the ‘OK’ button to proceed.
Immediately, every other row on your table will be highlighted.
If you check on the table design, you will see that the header row and banded rows are checked. The banded rows represent the highlight on every other row of your table.
To check the table style, click on the ‘Design’ tab while the table is selected.
That’s it! With this method, your table highlight will not be affected by sorting and/or filtering. 😊