how to shade every 5th row in excel for mac 2011

Select Use a formula to determine which cells to format item. Then a New Formatting Rule dialog box will pop out. Select the range that you want to shade, then click Home> Conditional Formatting> New Rule.See screenshot: 2. I *think* that's what you were asking how to do. To shade every other row with Conditional Formatting formula in Excel. Press Ctrl+v to paste the copied range into this area. You will notice that all of your column headings now have an arrow next.

Hold down your Shift key and the press Ctrl+UpArrow to slide all the way back to cell D5, while also selecting the range D5:D5000.Ħ. Go to the Data ribbon, and then click Filter in the Sort & Filter group. 34,062 views This video shows you how to automatically apply shading to every nth row in a worksheet. Press the RightArrow key once to select cell D5000.ĥ.

Press Ctrl+DownArrow to slide all the way down to cell C5000.Ĥ. Copy the range that has your formulas (D5:F5).ģ. Now suppose that you have a column of data in the range C5:C5000, that you have some formulas in the range D5:F5, and that you want to paste those formulas to all the rows from D6 through D5000. If you hold down your Shift key and then press Ctrl+DownArrow, you'll slide down the column, but Excel will select the area that begins where you started and ends where you stopped. If you go to the top of the column and then press Ctrl+DownArrow, you'll slide down that column to the last cell with data in the column. Suppose you have a column of data that's 5000 rows high. Then click OK, two rows at two intervals have been selected alternately, see screenshot: 5. Here's how to do it in Windows Excel I assume it works about the same in Mac Excel. In the Select Interval Rows & Columns dialog, choose the rows or columns that you want to shade from the Select section, and then specify the number of intervals and rows you need, see screenshot: 4.

How to shade every 5th row in excel for mac 2011