# how to hide rows in google sheets

Viewport: 1910x922 @1.125x

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

1. [Intro] How to Hide Rows in Google Sheets
   - body: This guide will take you through the steps to hide rows in Google Sheets. Hiding rows can help you focus on specific data and make your spreadsheet easier to read and navigate. Follow the steps below to learn how to hide rows effectively.
   - voiceover: This guide will walk you through the steps to hide rows in Google Sheets. Hiding rows can be useful when you want to focus on specific data or create a cleaner view of your spreadsheet. Follow these steps to hide the rows you don't need to see.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot75oo000d0cjl6afrh90i.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click and drag over the row numbers on the left to select the rows you wish to hide. You can select multiple rows by holding the 'Shift' key while clicking on the row numbers.
   - source type: IMAGE
   - description: Select the Rows
   - target: (300, 490), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (300, 490), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click and drag over the row numbers on the left to select the rows you wish to hide. You can select multiple rows by holding the 'Shift' key while clicking on the row numbers.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot79hb000f0cjl1rdchlr3.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8osvde1000403hu2o4tphi8.png
2. step_02 [image] - Once the desired rows are selected, right-click anywhere on the selected row numbers. This will open a context menu with various options.
   - source type: IMAGE
   - description: Right-Click on Selected Rows
   - target: (23, 473), rect: top=165.7777862548828 left=0 width=46 height=604
   - hotspots: 1
     - hotspot_01 (23, 473), rect: top=165.7777862548828 left=0 width=46 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Once the desired rows are selected, right-click anywhere on the selected row numbers. This will open a context menu with various options.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot79hw000g0cjl3vwp3xfs.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8osvfun000503huuiu77kty.png
3. step_03 [image] - In the context menu, find and click on the 'Hide rows' option. This will immediately hide the selected rows from your view. 
   - source type: IMAGE
   - description: Confirm Hidden Rows
   - target: (241, 596), rect: top=570.7777709960938 left=27.88888931274414 width=320 height=32
   - hotspots: 1
     - hotspot_01 (241, 596), rect: top=570.7777709960938 left=27.88888931274414 width=320 height=32
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: In the context menu, find and click on the 'Hide rows' option. This will immediately hide the selected rows from your view.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot79ii000h0cjl0z329w9s.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8osvipr000703huiz17fptl.png
4. step_04 [image] - Once the rows are hidden, you will notice a small icon or indication where the rows used to be, showing that rows are hidden in that section.
   - source type: IMAGE
   - description: Unhide Rows
   - target: (41.62232712082218, 456.1037264546346), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (41.62232712082218, 456.1037264546346), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Once the rows are hidden, you will notice a small icon or indication where the rows used to be, showing that rows are hidden in that section.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot79j0000i0cjlddn5e7mz.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8osvju7000803hu5uymd8a2.png
6. [Outro] Row Hided Successfully
   - body: Now that you know how to hide and unhide rows in Google Sheets, you can manage your data more efficiently. Explore other features like filtering and sorting to further enhance your data organization.
   - voiceover: Now that you've successfully hidden the rows, you can focus on the visible data or perform additional actions such as unhiding rows or further organizing your spreadsheet.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8osv74t001wl50cqsd00qvd/cm8ot77n2000e0cjl3qbi41d3.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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