Is there a way to hide rows in Google Sheets?

How to Sync All Your Calendars with Google Calendar

If you work with multiple calendars, making sure they are in sync is crucial to avoid missed meetings and double bookings. In this guide, we will show you how to sync multiple calendars with Google Calendar, even if they are spread across multiple calendar applications. Many Google Workspace users prefer to sync all their agendas, including Microsoft and Apple calendars with Google Calendar. If your company is using Google Workspace apps, it’s worth considering the switch to Google Calendar. You are not restricted to calendars provided by Google or used by someone with a Google Calendar. Calendars from other apps can be added using iCalendar (also known as iCal or.ics), a long-standing format for storing calendar information. How to add a calendar using iCal URL iCal feeds (also known as ICS or iCalendar) are a calendar-based event exchange standard. Most cloud-based calendar applications will allow you to export events in this format, and the best part is that events stay in sync even if you continue to make changes using the original app. Calendar feeds are automatically updated by Google Calendar every few hours. Please note that deleting your calendar from the original app will also remove it from Google Calendar, so make sure you keep it active even after syncing it with Google Calendar. Normally you can obtain the iCal feed URL from within the settings or export/import section of any calendar app. Once you have the iCal URL, you can import it to Google Calendar. 1. To get started, open Google Calendar on the web and go to Settings (top right corner). 2. From the Add Calendar section, choose From URL. 3. Paste in the iCal URL and click Add Calendar. Your calendar will show up under “Other Calendars,” and events should be visible right away alongside your existing Google Calendar agenda. Remember that deleting the calendar from the original app, also removes it from Google Calendar.

Is there a way to hide rows in Google Sheets?

  • You can easily hide rows in Google Sheets in a few quick steps on a computer or mobile device.
  • You can also unhide rows in Google Sheets using the same method.
  • Visit Business Insider's homepage for more stories.

You can hide rows in Google Sheets just as easily as in Microsoft Excel and it's a quick process on either a computer or mobile device.

Here's how to do it.

Check out the products mentioned in this article: 

iPhone 11 (From $699.99 at Best Buy)

Samsung Galaxy S10 (From $899.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad (From $299.99 at Best Buy)

How to hide rows in Google Sheets on a computer 

1. Open the Google Sheet you want to edit on your Mac or PC.

2. Select the row you want to hide.

3. Right-click the selected row and choose Hide row from the menu that opens. Two arrows will appear in place of the hidden row.

Right click and tap "Hide row." Michelle Greenlee/Business Insider

You can unhide the rows by clicking one of the arrows that appeared in place of the hidden row number. The hidden row then will reappear.

How to hide rows in Google Sheets on a mobile device

1. From the Google Sheets app, open the Google Sheets document you want to edit.

2. If you're using an iPhone, simply select the rows you want to hide and tap on them. On the menu that appears, choose "Hide row." 

Tap "Hide row" on the menu. Michelle Greenlee/Business Insider

3. The process on an Android is similar. Tap and hold the row you want to hide. On the menu that appears above the selected row, tap the three vertical dots and choose "Hide row."

Unhiding rows on an Android is similar to an iPhone. Michelle Greenlee/Business Insider

Unhide the row by repeating the above steps, then choosing Unhide row from the menu.

  • How to make a bar graph on Google Sheets in 5 simple steps, to make your spreadsheet data more digestible

  • How to set a print area in Google Sheets, so you can print selected cells or sheets

  • How to merge cells in Google Sheets on desktop or mobile, to combine multiple cells into one larger cell

  • How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet

  • How to draw in Google Docs using the built-in 'Drawing' tool, to add customized drawings to your documents

Insider Inc. receives a commission when you buy through our links.