How to Quickly Shade Alternate Rows in Excel

Tags:
Excel Tip, Format Painter, Shade Alternate Rows, Microsoft Excel, Color Alternate Rows

Add video views to your Facebook Timeline:

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

  1. By: Trapezoid
  2. Categories How To, Science & Tech
  3. Views 3,827
  4. Added :16-Aug-08
  5. Related Link: EngineersExcel.com
Comments on How to Quickly Shade Alternate Rows in Excel
Other comments on this video
  • 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
    • 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
2 Comments
 

Up Next: Exclusive - Playback Clip - You'll Be Sorry You Were Late