If you just start to use Google Sheet,
or if you are also looking to get started with Google Sheets, then you are at
the right place. In this blog, we’ll cover how to use google sheet and also
walk you through some of the basic things. This blog will help you to
understand the complete guide of Google Sheet.
Google Sheet!!
Google Sheets is a free cloud-based
spreadsheet application. You can directly open the Google Sheet in your browser
window like regular webpage. It looks and works like any other spreadsheet
tool, but since it is an online application it offers much more than most
spreadsheet tools.
Why use Google Sheet?
How is this to start?
Ø It’s free!!
Ø It has enough features to perform complex
analysis, but it is also very easy to use
Ø It's collaborative, so all teams can see and
work with the same spreadsheet in real time.
Wnna more convincing?
Here are five more reasons from Google themselves.
Can you still do advanced things?
Off course!! You can
create a dashboards, write head-spinning formulas and even create apps to
automate your work. The sky is the limit!!
Okay, I get it from where? How to Create Your
First Google Sheet?
As of 2021, it looks like this the
screenshot I shared below. If this is your first time to work with sheet, then
you must go through this link https://www.google.com/sheets/about/
To
know how to create your first Google sheet, then follow the steps given below:
Step1:
Click on the “Go to Google Sheets” option.
Step 2:
After that, you will be asked to “login” with Google.
Step3: You can directly jump on the Google Sheets home screen, and click on the “Plus Button” that is clearly shown in the picture given below.
Step 4:
After this, your “Blank
Google Sheet” is open and sheet will look like this
Step 5:
There is an option to rename your sheet in the very top left corner. Click on “Untitled Spreadsheet” and type whatever you want to give name to your sheet, it would be anything, For Example: Name of yours or anything (x, y, z)
So let's introduce some key terms and the fundamental concept that spreadsheets work on.
The main window consist of a grid of cells. An individual
cell is a single rectangle at the intersection of one column and one row, and
it’ll hold a single piece of data
The columns are vertical ranges of cell, labelled by letters
running across the top of the sheet
The fundamental concept of
spreadsheets:
Column J and Row 19 intersect at one cell, and one cell
only. Thus, we can combine letter and row number to create a unique reference
to this cell, E19. Now when we want to refer to this cell.
Understand this and you understand spreadsheets. The rest is
just details.
Deleting,
Selecting, Entering and Moving Data:
Now the fun begins! Let's start using this new blank sheet
we have created.
1:
Tab on Cell A1 (you can clearly see on the top left corner of the sheet) and you can see the blue box in the outline of the cell that indicates A1 box clearly.
2:
Now, you can simply typing anything on the blue box and you
will see the data you entered in A1.
Click on enter button and you have finished entered data
after that you have to click on enter button and you automatically moved down
to the next cell.
If you click on tab button then you will move across the one
cell to the right!!
Opps!! I Made a Mistake
Calm Down!! Don’t panic...
Google Sheet saves every step of your work, there is nothing
to worry about it you can always go back if needed!!
Note: If you are a Mac user then press Cmd+Z, or
if you are using PC then tab Ctrl+Z and then you’ll undo your previous step.
Or, if you want to
redo your last step then press Cmd+Y on Mac, and Ctrl+Y on PC.
Also, you can use the Undo Arrow on the menu bar:
Google Sheet: How to Use
Resize, insert, delete, hide / show
columns and rows
Select a Row and
Column
Click on the number (Row) or letter (Columns) which you want
to select. The whole row and column automatically selected also highlighted
with a blue color
Change the width of the column, or
height of the row
Hover over the gray line that indicates the border of the
column or row, until your cursor changes to look like this:
Then click and drag the cursor left or right to change the
width of this column.
After that, click and drag the cursor left or right to
change the width the size of the column. And the same process goes with rows
also to change the height.
Pro Tip: To
quickly change the width of the column to fit the contents of your cell,
double-click when it is above the gray line.
How to add columns in Google Sheet
To insert additional columns or rows, click the existing column or row next to where you want to insert a new column or row, then right click and select “Insert 1 above” for column or if you want to insert row below the existing column then click on “Insert 1 below” for row.
When I Insert a row or column above to the existing data, you can see on the picture it will be added on it.