How to Quickly Shade Alternate Rows in Excel

Tags:
Excel Tip Format Painter Shade Alternate Rows Microsoft Excel Color Alternate Rows
Trapezoid
  • By: Trapezoid
  • Subscribers: 4
  • Updated: 19-Oct-09
  • Videos: 6
  • International International
  • Comments: 2
  • Views: 2,151
  • Added: 16-Aug-08

Use the Format Painter (Brush icon) to quickly shade alternate rows in Excel. The Format Painter is a useful but underutilized feature.

  1. Categories: How To, Science & Tech
  2. Related Link: EngineersExcel.com
Comments on

How to Quickly Shade Alternate Rows in Excel

2 Comments | Add Comment
  • u were so fast,

    atlis u would explain in Zoom, and u were too fast i need to see it again and again.to understand it. as i am not so well verse with this programmes,but i like to learn more.thans for posting it.

    By starsonearth 1218872449 Reply Spam Moderate Up Moderate Down
    • Noted

      Thanks for you comment, I will keep this in mind for future videos.

      Fyi, the procedure shown in this video is :
      colour the first row manually;
      select the first and second rows;
      click the format painter (brush icon); and
      select the rows you wish to shade.

      The rows will be shaded as desired.

      By Trapezoid 1218902194 Reply Spam Moderate Up Moderate Down
2 Comments | Add Comment