# How to Alternate Row Colors in Google Sheets

Viewport: 1920x950 @0.800000011920929x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Alternate Row Colors in Google Sheets
   - body: This guide will walk you through the steps to alternate row colors in a Google Sheets document. Follow these detailed instructions to easily add alternating row colors to your spreadsheet, making it more visually appealing and easier to read.
   - voiceover: This guide provides a detailed walkthrough on how to alternate row colors in Google Sheets to enhance the visual appearance of your data. Follow these steps to easily apply alternating colors to your selected range of cells.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo0zk00000clbhz2r7vg0.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the column you want
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (86, 152), rect: top=142.94921875 left=45.99609375 width=2342.98828125 height=23.984375
   - hotspots: 1
     - hotspot_01 (86, 152), rect: top=142.94921875 left=45.99609375 width=2342.98828125 height=23.984375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Click on the column header (e.g., 'A', 'B', 'C') to highlight the entire column. You can also click and drag to select multiple columns or specific cells within the column.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo5rf00020clb64dsad2u.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmj1ee0000033pgrja1kka.png
2. step_02 [image] - Click on Format tab
   - source type: IMAGE
   - description: Select the Range
   - target: (240.9435210653226, 72.62984681840149), rect: top=33.984375 left=236.11328125 width=62.734375 height=23.984375
   - hotspots: 1
     - hotspot_01 (240.9435210653226, 72.62984681840149), rect: top=33.984375 left=236.11328125 width=62.734375 height=23.984375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Navigate to the top menu bar, and click on 'Format' to open the dropdown menu. This is where you will find formatting options for your sheet.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo5sn00030clbbcmy6uki.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmj35q0001033p1ost3t2a.png
3. step_03 [image] - Click on Alternating colors
   - source type: IMAGE
   - description: Open Format Menu
   - target: (436.45170489465033, 437.4604387915162), rect: top=444.0625 left=275.3515625 width=119.8828125 height=17.5
   - hotspots: 1
     - hotspot_01 (436.45170489465033, 437.4604387915162), rect: top=444.0625 left=275.3515625 width=119.8828125 height=17.5
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: In the 'Format' dropdown menu, select the 'Alternating colors' option. This will open a sidebar on the right side of the screen where you can customize your color scheme.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo5tn00040clbfe09fkeh.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmj4te0002033pj9gizje6.png
4. step_04 [image] - Click here to choose your desired color scheme from the sidebar that appears
   - source type: IMAGE
   - target: (2369.4726281512467, 362.48158600373324), rect: top=284.98158715857323 left=2058.222632789233 width=311.24999536201364 height=154.99999769032004
   - hotspots: 1
     - hotspot_01 (2369.4726281512467, 362.48158600373324), rect: top=284.98158715857323 left=2058.222632789233 width=311.24999536201364 height=154.99999769032004 style=STYLE2
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: In the sidebar that appears, use the provided color options to select your desired color scheme. You can choose from preset styles or create a custom scheme by selecting different colors for the header, odd rows, and even rows.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo5uq00050clbaiqhdt6s.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmj7fe0003033p5rf0l721.png
5. step_05 [image] - Click 'Done' to apply the colors to your selected range.
   - source type: IMAGE
   - description: Apply and Customize
   - target: (2245.7288755808763, 647.3587518233194), rect: top=661.09375 left=2288.10546875 width=85.8984375 height=35.99609375
   - hotspots: 1
     - hotspot_01 (2245.7288755808763, 647.3587518233194), rect: top=661.09375 left=2288.10546875 width=85.8984375 height=35.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Once you have chosen your color scheme, click the 'Done' button at the bottom of the sidebar. This will apply the alternating colors to your selected range of cells.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo5w200060clb8frw82zd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmjab50004033p34wede6p.png
7. [Outro] Next Steps
   - body: You have successfully applied alternating row colors to your Google Sheets document. To further customize your sheet, explore other formatting options in the 'Format' menu.
   - voiceover: You have successfully applied alternating row colors to your selected range in Google Sheets. To further customize your sheet, you may want to explore other formatting options available under the 'Format' tab or add filters and conditional formatting to enhance your data representation.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hmiu9q00logz0c6kjcs57t/cm6hmo2zh00010clb4i6rgs02.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6hmiu9q00logz0c6kjcs57t/tour