Hiding A Sheet In Google Sheets Workbook

Hiding A Sheet In Google Sheets WorkbookA spreadsheet in Google Sheets like most spreadsheet applications. It’s actually a document that can contain several spreadsheets. This document is called a workbook. Each spreadsheet in this document can be accessed from a tab at the bottom. We can have several spreadsheets in a document. According to Google, we can have up to 200 sheets in a workbook. With so many sheets in a workbook, we might have […]

Continue reading

Hiding Columns or Rows In Google Sheets

Hiding Columns or Rows In Google SheetsWe can hide columns or rows in a spreadsheet to help focus on some of the specific information. Hiding columns or rows collapses the information so we can shorten the distance between values and information. In this example, we have columns we don’t currently need to see. To hide these columns we will click once on the column heading to select the entire column.   There are a couple […]

Continue reading

Setting Edit Permissions To A Range of Cells In Google Sheets

Setting Edit Permissions To A Range of Cells In Google SheetsSharing and collaborating on worksheets is one of the benefits of using Google Sheets. At the most basic level we can grant permission for someone to edit a spreadsheet. This permission allows access to the complete workbook and all the spreadsheets. There may be times when we don’t want to grant access to edit some part of a spreadsheet. In this case, we can grant […]

Continue reading

Protecting A Sheet In Google Sheets Workbook

Protecting A Sheet In Google Sheets WorkbookWhen working with Google Sheets we might often work with others collaboratively. When collaborating on spreadsheets we might need to make sure that some information isn’t editable by others. We can set restrictions on spreadsheets or on a range of cells. Restrictions are set using tools similar to sharing documents. We want to restrict any editing of the sheet labeled “District Level”.   To restrict edit access to this […]

Continue reading

Coloring A Sheet In A Google Sheet Workbook

Coloring A Sheet In A Google Sheet WorkbookDividing information into sheets can be a useful way of organizing vast amounts of information. The workbook in this example has several sheets.   We can add color to these spreadsheet tabs. The color can be used to liven things up or to help organize important information. To change the color of a spreadsheet tab, click on the triangle to the right of the sheet name. Hover over […]

Continue reading

Deleting Columns and Rows In Google Sheets

Deleting Columns and Rows In Google SheetsThere are times when we collect data in a spreadsheet that isn’t relevant or necessary for our needs. This can happen when we receive data from another source. In this example, we have some data received from an online database which includes extra information and columns with headings and no data.   Click once on the column heading. In this example, we’ll click column H. There are several ways […]

Continue reading

Deleting Sheets In Google Sheets Workbook

Deleting Sheets In Google Sheets WorkbookA Google Sheet is a document that may contain several spreadsheets. The document is called a workbook. We can create several spreadsheets in a workbook. We can also remove unwanted spreadsheets from the workbook. To remove a spreadsheet, click on the triangle to the right of the sheet name. In this example, we want to remove a duplicate version of student responses we created in an earlier lesson. Click the […]

Continue reading

Freezing Multiple Columns and Rows In Google Sheets

Freezing Multiple Columns and Rows In Google SheetsSpreadsheets can get a little complicated and cumbersome. To get a better view of information across a spreadsheet we often need to scroll through lots of information. The headings for information may not always be at the top of the sheet in the first or second row. That happens to be the case in this example. We have some data collected in a survey. The information I would […]

Continue reading

Freezing Header Rows and Columns In Google Sheets

Freezing Header Rows and Columns In Google SheetsWhen working with spreadsheets, we often have headers in the first row that are titles for the data in the columns. This often means that we have lots of data that flows down the column. When we scroll down to look at this data, we may loose the headings that identify the data. These headings can be frozen so they remain visible. In this example, there is a […]

Continue reading

Duplicating A Sheet In Google Sheets Workbook

Duplicating A Sheet In Google Sheets WorkbookA Google sheet is a document that can contain several spreadsheets. Each spreadsheet is represented by a tab at the bottom of the workbook. More than one spreadsheet in a Sheet document is referred to as a workbook. We can add up to two hundred spreadsheets to a workbook. We can create new spreadsheets in this workbook and we can duplicate existing spreadsheets. Duplicating spreadsheets can be a useful […]

Continue reading