In ninety nine percent of circumstances one of these pre-built options will probably suit your requirements (we show you how to customize further a little later in this article).Ĭhoose the styling, from the options provided, that is most appropriate for your needs. When you click on the “Format as Table” button a new set of options appears with some pre defined formats you can quick apply to your selected data. Step one in the process is to click on the “Format as Table” button on the ribbon bar at the top of your Excel worksheet. In our example below we have a simple set of data containing two columns where we would like to make every other row a different colour. Let’s get started.įirst open the Excel workbook and worksheet you want to apply the formatting to. The process for highlighting every other row in Excel is very simple and will take just a few seconds. Although row highlighting is mainly used for presentation purposes, highlighting alternate rows in an Excel worksheet can also help usability and help to highlight important data. In this DataSherpas quick tip we show you how to highlight every other row in excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |