How to use Google Sheets a Beginners Guide

In this post, we will see how to use google sheets. This is a beginner’s guide to google sheets in which we will start from the absolute basics of spreadsheet concepts and continue to cover all the major functions of the google sheet. So let us start.

YouTube player

10 Basic Spreadsheet Concept/Terms

1. Cell
A Cell in Google Sheet
A Cell in Google Sheet

The basic building block of the spreadsheet. The cell stores all the data present in a spreadsheet.

2. Cell Address
Cell Address in Google Sheet
Cell Address in Google Sheet

The unique identifier of a cell which allows it to be referenced in a formula.

3. Active Cell
An Active Cell in Google Sheets
An Active Cell in Google Sheets

The currently selected cell in which the all the data that is typed will be stored.

4. Rows and Column
Row and Column in a Google Sheet
Row and Column in a Google Sheet

Groups of horizontally and vertically stacked cells in a spreadsheet are know as rows and columns respectively.

5. Rows and Column Name
Row Name and Column Name
Row Name and Column Name

A unique identifier assigned to each row and column.

6. Sheet
A Sheet
A Sheet

The entire table consisting of all the rows and columns form one sheet. A spreadsheet can have multiple sheets in a single file.

7. Range
Range in a Google Sheet
Range in a Google Sheet

A subsection of a row or column or both.

8. Range Address
Range Address
Range Address

The unique identifier of a range defined by the cell address of the top left cell and bottom right cell.

9. Formula Bar
Formula Bar in Google Sheet
Formula Bar in Google Sheet

The location where the value of the active cell is shown. In case the active cell has a formula it shows the formula instead.

10. Explore Feature
Explore in Google Sheet
Explore in Google Sheet

A unique feature of google sheet which on analyzing data shows ways of improving the sheet.

Sheet Operations

Open a new sheet from Google Drive
  1. Go to google.com/drive
  2. Click on Go To Google Drive
  3. Click on New
  4. Click on New Google Sheet
Open a new sheet from Google Sheet
  1. Go to google.com/sheets
  2. Click on Go To Google Sheets
  3. Select a Template or Click Blank Option
Open an Excel File from Google Drive
  1. Go to google.com/drive
  2. Click Go To Google Drive
  3. Click on New
  4. Click on File Upload
  5. Upload the Excel File
  6. Click on Open with Google Sheet
Open an Excel File from Gmail Email
  1. Open the Gmail Email with the attachment
  2. Hover Mouse over Attachment
  3. Click on pencil Icon
Rename Sheet
  1. Click on the sheet name at the top
Insert New Sheet
  1. Click on plus icon at the bottom left corner
Delete Sheet
  1. Select the sheet at the bottom left corner
  2. Right click and select Delete
Redo and Undo any operation
  1. Press Ctrl + Y to Redo
  2. Press Ctrl + Z to Undo
Rename Sheet Name
  1. Double click on the sheet name at the bottom left corner
Clear Entire Sheet
  1. Press Ctrl + A
  2. Press Delete
Add Chart from Explore
  1. Click on bottom right corner to open explore
  2. Select the chart you want to add
  3. Drag and drop it on the sheet using the mouse pointer.
Download as Excel File
  1. Click on File
  2. Click on Download As
  3. Select Excel
Share Google Sheet
  1. Click on the top right corner share button
  2. Type the email address of the person
  3. Select the permission
  4.  Click on Send
Sheet Copy
  1. Click on File
  2. Click on Make a Copy
  3. Enter the new document name and drive location for saving the document
Print Sheet
  1. Press Ctrl + P or Click on File
  2. Click on Print
  3. Select suitable print options

Cell Operations

Change Active Cell
  1. Using tab change it to the next horizontal cell
  2. Or using enter change it to the next vertical cell
  3. Or left click on a cell to make it the active cell
Cut Cell Value
  1. Select the Cell
  2. Press Ctrl + X
Copy Cell Value
  1. Select the Cell
  2. Press Ctrl + C
Paste Cell Value
  1. Copy/Cut the Value
  2. Press Ctrl + V
Edit Cell Value
  1. Double click on the cell
  2. Make changes
  3. Press enter to save changes
  4. Or Esc to cancel the changes
Insert Formula
  1. Select the cell
  2. Type “= Your Formula” in the formula bar
Auto Complete
  1. Hover mouse pointer on the right bottom corner of the cell.
  2. When the mouse pointer turns into a double-sided arrow.
  3. Drag to auto complete.
Find Sum, Max, Min, Count and Avg
  1. Select the cells.
  2. View the bottom right corner for the sum.
  3. Click on that to reveal Max, Min, Count, and Avg.
Bold Cell Value
  1. Select the cell
  2. Press the bold icon on the toolbar
  3. Or press Ctrl + B
Change Cell Font Size
  1. Select the cell
  2. Change the font size from the font size icon in the toolbar.
Merge Cells
  1. Select the cells to be merged
  2. Then click on the merge cell icon in the toolbar.
Add Cell border
  1. Select the cell
  2. Click on the arrow icon next to the border icon in the toolbar
  3. Select from a list of different borders to be added
Change Text Alignment
  1. Select the cell
  2. Click on alignment icon in the toolbar.
  3. Select the desired cell alignment.
Add Comment
  1. Select the cell
  2. Click on the top right-hand corner button comment

Row & Column Operation

Select Row
  1. Left click on the row number at the left side of the screen
Select Column
  1. Left click on the column name at the top side of the screen
Insert Row
  1. Select row
  2. Right click and select insert row above / below
Insert Column
  1. Select column
  2. Right click and select insert row left / right
Delete Row/Column
  1. Select row/column
  2. Right click and select delete
Auto Resize Column Width
  1. Select the column
  2. Hover the mouse near the column border at the top.
  3. Double click when the mouse pointer turns into a double-sided arrow.
Auto Resize All Column Width
  1. Press Ctrl + A
  2. Hover the mouse near any one of the column borders at the top.
  3. Double click when the mouse pointer turns into a double-sided arrow.
Add row/ column color formatting from explore
  1. Open the explore tab.
  2. Click on the table color formatting options shown to apply it

I hope this beginners guide to google sheets helped you. If yes, consider supporting us. If you are facing some problem following this guide share it below in the comment section.  You can help others by sharing this guide with your friends whom you think could benefit from it.Here this a bonus content for you.

Download Revision Sheet

Download Free Revision Sheet

At howisolve.com we provide you the with latest updates on technology, tutorials, tips and tricks, troubleshooting guides and much more. Subscribe to our newsletters to get regular updates straight to your inbox. Thanks for reading friends see you later bye.

Neil Mahaseth

Hello, friends welcome to HowISolve.com, a community founded by me in June 2015. With the aim to help you solve your everyday tech problems. The motivation for starting this community was instilled from my love for technology and my nature to help others in need. By qualification, I am a technocrat with an M.B.A. and B.Tech. from Narsee Monjee, Mumbai. I have experienced both worlds: corporate and startup. I am currently honing my entrepreneurial skills and trying to add value to people's lives. You can also join us by subscribing to our Newsletters & YouTube channel to be a part of this growing community.

View all posts by Neil Mahaseth →