Skip to content
Tech Guide Central logo 800px
  • Apple
  • Google
  • Microsoft
  • Other
Tech Guide Central logo 800px
Home / Google Sheets

Google Sheets

How to Convert PDF to Google Sheets: 3 Free Easy Methods
Google | Google Sheets | How-Tos | Microsoft Excel | Software

How to Convert PDF to Google Sheets: 3 Free Easy Methods

ByJohn

We all know the benefits of using a spreadsheet program over simply placing data on a text document. Turning that said data into a spreadsheet…

Read More How to Convert PDF to Google Sheets: 3 Free Easy MethodsContinue

How to add up numbers as long as more than 1 condition is met
Google | Google Sheets | Software

How to add up numbers as long as more than 1 condition is met

ByJohn

With my business, I had an issue on Google Sheets where I wanted to add two numbers automatically. However, the addition operation would only happen…

Read More How to add up numbers as long as more than 1 condition is metContinue

Can Google Sheets automatically color-code cells based on value?
Google | Google Sheets | Software

Can Google Sheets automatically color-code cells based on value?

ByJohn

Do you like to color-code your cells? Most of us do it. It makes it easy to understand what’s going on with just a glance….

Read More Can Google Sheets automatically color-code cells based on value?Continue

Can Google Sheets reference data from a different Google Sheets file?
Google | Google Sheets | Software

Can Google Sheets reference data from a different Google Sheets file?

ByJohn

Referring to data from the same file is a simple task. In fact, if you’re interested, I’ve written an article about that here (How to…

Read More Can Google Sheets reference data from a different Google Sheets file?Continue

Allow only specific people to edit specific cells on Google Sheets
Google | Google Sheets | Software

Allow only specific people to edit specific cells on Google Sheets

ByJohn

When you create a document or a spreadsheet with Google, you can do a lot of what Google likes to call collaboration. This is the…

Read More Allow only specific people to edit specific cells on Google SheetsContinue

How to Categorize and then Filter your Categories with Google Sheets
Google | Google Sheets | Software

How to Categorize and then Filter your Categories with Google Sheets

ByJohn

I have a few rental homes that I own and rent to tenants. When I first started renting them out, I was holding onto a…

Read More How to Categorize and then Filter your Categories with Google SheetsContinue

How to open and edit Microsoft Excel in Google Sheets
Google | Google Sheets | Microsoft | Microsoft Excel | Software

How to open and edit Microsoft Excel in Google Sheets

ByJohn

So you’re asking yourself if you should make the switch over to Google services. Trust me, I’ve been there once and I haven’t really looked…

Read More How to open and edit Microsoft Excel in Google SheetsContinue

How to insert a table into a Gmail message
Gmail | Google | Google Sheets | Software

How to insert a table into a Gmail message

ByJohn

One of the worst kinds of emails is those that have tons of information and data typed into the text that sort of confuses the…

Read More How to insert a table into a Gmail messageContinue

How to stylize your Google Sheet and make it look professional
Google | Google Sheets | Software

How to stylize your Google Sheet and make it look professional

ByJohn

I want to go through with you a short tutorial on how I created the style on one of my Google Sheets spreadsheets. I think…

Read More How to stylize your Google Sheet and make it look professionalContinue

How to make Google sheets add up numbers for you (The right way)
Google | Google Sheets | Software

How to make Google sheets add up numbers for you (The right way)

ByJohn

Most people know that there’s a way to easily add numbers to a spreadsheet. But in case you have never used Google Sheets before or…

Read More How to make Google sheets add up numbers for you (The right way)Continue

Page navigation

1 2 Next PageNext

About Us

We love electronics and technology. This website is everything we’ve picked up, learned, and we’re sharing that with you.

Legal Information

This site participates in the Amazon Services Associates Program which is a means for sites to earn advertising fees by advertising and linking to Amazon.com.

© 2023 Tech Guide Central

  • Terms
  • Privacy
  • Contact
Scroll to top
  • Apple
  • Google
  • Microsoft
  • Other
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok