How to Use Google Sheets

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.
Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on email

Table of Contents

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!

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!
How To Use Google Sheets

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

How to Make a Graph in Google Sheets
Sample Of A Bar Chart On A Budget Google Sheet
  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

About Lori Ballen

I teach bloggers how to grow their blog, and make money through multiple streams of income. From affiliate marketing, to building courses, I share 7 income stream strategies through blogging.

Categories

Ready, Set, Grow

Hi! I’m Lori Ballen. I help content creators grow and monetize their channels. Are You Ready to Grow? Subscribe to receive my ebooks, video guides, and trainings.

Pipedrive can help you grow sales, track activity, manage teams, and so much more. Using artificial intelligence, pipedrive helps you automate processes, build sales funnels, analyze essential data, work with teams, and increase sales by targeting key opportunities.
CRM

Pipedrive CRM

Pipedrive can help you grow sales, track activity, manage teams, and so much more. Using artificial intelligence, pipedrive helps you automate processes, build sales funnels, analyze essential data, work with teams, and increase sales by targeting key opportunities.

Read More »
WebinarNinja finally built something sleek, easy, and effective for independent coaches, trainers, and other entrepreneurs.
Webinar Platforms

Webinar Ninja

WebinarNinja finally built something sleek, easy, and effective for independent coaches, trainers, and other entrepreneurs.

Read More »
Scroll to Top
Receive the latest news

How to Make 6-Figures As a Blogger

Weekly Marketing Tips, Videos, Event Invites, Software Reviews and Coupons.