How to Use Google Sheets

Lori Ballen is a member of the Amazon Associates Program and earns money from qualifying purchases. Posts contain affiliate links that benefit Lori as well.

I love Google sheets. It’s so much more than just a spreadsheet maker. Once you learn how to use Google Sheets, which is a free tool, you’ll find yourself more organized than ever!

Use the following tutorials to learn how to use Google Sheets in your business, for budgets, credit card debt tracker, shopping lists and so much more.

How to Freeze a Row in Google Sheets

1. On your computer, open a spreadsheet in Google Sheets.
2. Choose a row or column you want to freeze or unfreeze.
3. At the top, find ‘View‘ and click ‘Freeze’.
4. Select how many rows or columns to freeze.

How To Merge Cells in Google Sheets

1. Open your spreadsheet in Google Sheets in a web browser.
2. Select the cells you want to merge (2 or more).
3. Choose “Format” from the menu bar.
4. In the drop-down menu, click “Merge,” and then select the cell merge type you want: Horizontally, Vertically, or All.

How to Lock Cells in Google Sheets

1. Open your Gooogle spreadsheet
2. Find the cell you want to lock and Right-click
3. Select the ‘Protect range’ option.
4. When the pane opens, select ‘Add a sheet or range’
5. You can enter a description for that locked cell if you like

How to Alphabetize Google Sheets

1. Open your Google Sheet
2. Select the column
3. Click the Letter at the Top to sort A-Z or tap again for Z-A

How to Make a Graph in Google Sheets

1. Open your Google Spreadsheet
2. Click Insert.
3. Select ‘Chart’.
4. Choose a kind of chart such as bar, pie, etc
5. Click Chart Types to change what appears in the rows and other graphs choices

• 
  ProWritingAid vs. Grammarly – Are They Worth It?
  Grammarly and ProWritingAid are both excellent writing software, but which one is better?
• 
  Online Course Platforms: Thinkific vs. Teachable [2021]
  If you are looking to build a course to sell online, finding a platform that works for you is essential. In this guide, we will compare several platforms and show Teachable vs. Kajabi vs. Thinkific, and Ontraport course platforms.
• 
  Best CRM’s For Bloggers in 2021
  A CRM is a Contact Relationship Management System. It’s more than a database as it usually emcompasses a communication aspect within the system such as email drip, sms text messaging, social media, and so forth.
• 
  What is Systeme.io?
  Marketing has changed significantly during the past few years, and one of the most popular platforms today is Systeme.io.
• 
  15 Content Marketing Tools For Every Blogger
  Here are some tools to guide you through your content creation and marketing process, from coming up with ideas for distributing your message to your target audience.