However, the steps remain identical across all versions of Excel, including 2013, 2016, Excel Online and the latest 2019. The version of Microsoft Excel used in this Youtube tutorial is Excel 2013. Some people prefer Youtube tutorials to understand the process that goes into shading every other row in Excel.įor your further convenience, below is a video tutorial explaining exactly that. Youtube Tutorialįollowing text and picture instructions isn’t for everyone. Apply this formula to all rows and only MOD for odd rows returns as 1, and consequently, they are shaded. Then, sample items are randomly selected within each cluster. Whereas the for the tenth row, MOD is (10,2). The population is not clustered with other similar items. 9 is divided by 2 (5 times) to extract a remainder of 1. You can quickly do this by typing 0 in the first cell and 1 in the second cell, then. The detailed steps follow below: In an empty column next to your original data, enter a sequence of zeros and ones. For example, for the ninth row, the formula MOD is (9,2). In essence, a common way to erase every other row in Excel is this: first, you filter alternate rows, then select them, and delete all at once. The MOD and ROW function deal with the remainder of division and row number respectively. If you’re interested in the science behind the Excel Function: MOD(ROW(),2), here’s a simple explanation. Selecting every other or nth column with formula. Read a Similar Excel Tutorial: How to Create a Pictograph in Excel Understanding the Alternate Row Shading Formula It’s the sixth one.Ħ. Insert formula: MOD(ROW(),2) in the space below Edit this Rule Description.ħ. Tap Format in the same window (adjacent to preview).ĩ. Select the color you want your alternate rows to have and tap OK. Note: Select the entire range, not just alternate rows.ģ. In the home tab, tap Conditional Formatting.Ĥ. Select New Rule… from the drop-down menu.ĥ. Select “use a formula to determine…” as Rule type. Highlight the cells whose rows you wish to select. Shading Every other Row in Excel ( Using Conditional Formatting)ġ. Open the Excel Document containing your data.Ģ. Select the range of cells you wish to shade. You can use Format as Table and filtering to select every other row. In this tutorial, we will discuss how you can use conditional formatting to apply shade alternating lines. A conditional format is the easiest way to apply these color schemes. There are many in-built color patterns and schemes you can use to shade your Excel data. Using CTRL and Mouse Click To Select Every Other Row. To select every nth row, the OFFSET function is used in combination with the ROW function to create a dynamic range that is incremented by n for each row. Shading every other row in Excel can produce a wonderful contrast between these white rows and brighten your Excel experience. The stacks of white rows can dull your senses.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |