You now have a nicely formatted table of data that makes analysing different rows easier. If your range of cells includes headers (or titles) for each column in your data, be sure to check the “My table has headers” checkbox too.Īfter you have selected the range of cells click OK on the dialogue box and the selected cells will have the chosen formatting applied. Simply click your mouse in the top left cell of the range of cells you want to apply the styling to and then, with your left mouse button held down, drag your mouse across and down to select all the cells to be formatted. When you click on the style you wish to apply, a new dialogue box will appear asking you to choose the range of cells you wish to apply the styling to. In our example we will choose a style that highlights every other row in our data with a blue background. Note that some of the pre-defined styles do not highlight every other row by default.
EXCEL HIGHLIGHT EVERY OTHER ROW HOW TO
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 kommentar(er)
