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.

Sharing is caring!

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

• 
  Email Marketing Software
  I’ve used so many email marketing software over the years. I’ve realized that it’s not one size fits all. In fact, I’ve had to make changes based on the business and needs at the time. Take a look at this list of email marketing software and find the one that works for you. Take trials wherever you can.
• 
  What is Airtable
  Airtable, founded in 2012, is a cloud collaboration tool. It combines many of the features of an extensive database with the format of a spreadsheet.
• 
  What is Keap?
  Keap is a database program that you can use to manage your clients. Using Keap, you can track your prospects, customers, and more.
• 
  What is Crowdfire?
  Crowdfire helps you discover and schedule content, and manage all your social accounts from one place. Automatically discover articles and images your audience will love, so you can share them to all your social profiles and keep your timelines buzzing!
• 
  Social Snap
  Social Snap is a Social Media WordPress Plugin. It allows you to install some extra sharing features when adding a new blog post. Before you hit publish, you can add a featured image for Pinterest, For Facebook/LinkedIn/Twitter, add a social video, click to tweet, refresh old posts, and more.

Sharing is caring!