Google Sheet Class 1
Before using Google Sheets, you need to create a Gmail account. Since this course is from beginner to advanced level, we will cover everything from the beginning.
It’s important to understand what Gmail is and what email means. Gmail is a service name, and email is a method of sending and receiving electronic messages over the internet.
Creating a Gmail Account
To use Google Sheets, you first need to create a Gmail account. Follow these steps:
- Go to gmail.com.
- Click on “Create Account.”
- Fill in your details (name, username, password, etc.).
Copying and Pasting Data into Google Sheets for Lead Generation
In Google Sheets, you can copy and paste data in various ways. For lead generation, it’s best to use “Values Only” paste to avoid formatting or formulas, ensuring a clean sheet design when copying data from multiple sources.
Here are the shortcuts for Copy-Paste and Values Only Paste in Google Sheets. These shortcuts allow for faster data handling in Google Sheets!
Copy:
- Windows: Ctrl + C
- Mac: Cmd + C
Paste (Standard):
- Windows: Ctrl + V
- Mac: Cmd + V
Paste Values Only:
- Windows: Ctrl + Shift + V
- Mac: Cmd + Shift + V
Freezing and Unfreezing Columns & Rows
Freezing rows or columns keeps them visible while scrolling through large datasets.
To freeze a row or column:
- Open your Google Sheet.
- Click on View > Freeze.
- Select 1 row, 2 rows, or 1 column, etc.
To unfreeze a row or column:
- Click on View > Freeze > No rows or No columns.