# how to unhide 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 Unhide Rows in Google Sheets
   - body: This guide will walk you step by step through the process of unhiding rows in Google Sheets. Whether you've accidentally hidden rows or need to access hidden data, follow these instructions to make your rows visible again.
   - voiceover: This guide provides step-by-step instructions on how to unhide rows in Google Sheets. Follow these simple steps to make the hidden rows visible again.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re8a7000000cl8c5gyfh03.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Open Google Sheets. First, locate the rows around the hidden rows. 
   - source type: IMAGE
   - description: Select the Hidden Rows
   - target: (274, 409), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (274, 409), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Open Google Sheets. First, locate the rows around the hidden rows.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re8e0g00020cl8f5g3hv49.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re0j5e000003hu8i74pn1c.png
2. step_02 [image] - Look for small up/down arrows between row numbers and then Click on it then row will be Visible.
   - source type: IMAGE
   - description: Right-click the Selection
   - target: (39.77488240417105, 241.13382032248975), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (39.77488240417105, 241.13382032248975), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Look for small up/down arrows between row numbers. These arrows indicate hidden rows.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re8e1700030cl842xgbuda.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re0nu1000403huflte1rhq.png
3. step_03 [image] - Click on the arrows to unhide the rows.
   - source type: IMAGE
   - description: Choose 'Unhide Rows'
   - target: (32.514915035535275, 289.8160476704842), rect: top=165.7777862548828 left=0 width=46 height=604
   - hotspots: 1
     - hotspot_01 (32.514915035535275, 289.8160476704842), rect: top=165.7777862548828 left=0 width=46 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click on the up/down arrows to unhide the rows. The hidden rows will become visible.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re8e1y00040cl86yzp6rts.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re0q3m000503hublfqq43k.png
5. [Outro] Congrats
   - body: You have successfully unhidden the rows in your Google Sheets document. If you need to unhide columns or perform other actions, refer to additional help docs for further guidance.
   - voiceover: Now that you've unhidden the rows, you can continue editing your Google Sheets as needed. If you need to hide rows again, follow the reverse process.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8re0duw00bdld0cgx35sg60/cm8re8chc00010cl8hg2rb6hd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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