how to use google sheets

HOW TO USE

1 dennissaren.wordpress.com

Click the Google Chrome icon in your desktop

dennissaren.wordpress.com 2

Type “google.com”

dennissaren.wordpress.com 3

Press ENTER

dennissaren.wordpress.com 4

Click “Sign in”

dennissaren.wordpress.com 5

Enter your Google Email address

dennissaren.wordpress.com 6

Enter your Gmail Password

dennissaren.wordpress.com 7

Click “Sign In”

dennissaren.wordpress.com 8

Click the icon

dennissaren.wordpress.com 9

Click “Even more from Google”

dennissaren.wordpress.com 10

Click “Sheets”

dennissaren.wordpress.com 11

Click the “Go to Google Sheets”

dennissaren.wordpress.com 12

CREATING NEW SPREADSHEET

dennissaren.wordpress.com 13

Click (+) to start a new spreadsheet

dennissaren.wordpress.com 14

New and untitled spreadsheet will open

dennissaren.wordpress.com 15

Click “Untitled Spreadsheet”

dennissaren.wordpress.com 16

Rename to “Sample_Spreadsheet_Tutorial”

dennissaren.wordpress.com 17

SHARING SPREADSHEET

TO TEAM MEMBERS

dennissaren.wordpress.com 18

Click at upper right corner

dennissaren.wordpress.com 19

Enter email address of team member

dennissaren.wordpress.com 20

Choose access type

dennissaren.wordpress.com 21

ACCESS TYPES

dennissaren.wordpress.com 22

SHARING SPREADSHEET

THROUGH FACEBOOK

dennissaren.wordpress.com 23

Click “Advanced”

dennissaren.wordpress.com 24

Click the Facebook logo

dennissaren.wordpress.com 25

Click “On-Anyone with the Link”

dennissaren.wordpress.com 26

Choose “Can View”

dennissaren.wordpress.com 27

Choose “Share to Facebook”

dennissaren.wordpress.com 28

Say something about the post

dennissaren.wordpress.com 29

Click post to facebook

dennissaren.wordpress.com 30

SHARING SPREADSHEET THROUGH GOOGLE MAIL

dennissaren.wordpress.com 31

Click the Google Mail logo

dennissaren.wordpress.com 32

Enter email address of recipient

dennissaren.wordpress.com 33

Enter subject of email

dennissaren.wordpress.com 34

Click “Send”

dennissaren.wordpress.com 35

ADDING SHEETS

dennissaren.wordpress.com 36

Click at the lower left corner

dennissaren.wordpress.com 37

RENAMING SHEETS

dennissaren.wordpress.com 38

Click beside the Sheet Title Bar

dennissaren.wordpress.com 39

Click “Rename”

dennissaren.wordpress.com 40

Type name of sheet

dennissaren.wordpress.com 41

ENTERING DATA

dennissaren.wordpress.com 42

Click on the cell

dennissaren.wordpress.com 43

Type data you want to put

dennissaren.wordpress.com 44

INSERTING LINKS

dennissaren.wordpress.com 45

Copy link of destination website

dennissaren.wordpress.com 46

Click on the cell

dennissaren.wordpress.com 47

Click the “Insert Link” icon

dennissaren.wordpress.com 48

Right Click on the Link Box

dennissaren.wordpress.com 49

Click “Paste”

dennissaren.wordpress.com 50

Click on Text Box

dennissaren.wordpress.com 51

Type text to be displayed

dennissaren.wordpress.com 52

Click “Apply”

dennissaren.wordpress.com 53

Blue text will appear on the cell

dennissaren.wordpress.com 54

USING FUNCTIONS FOR

GOOGLE SHEETS

dennissaren.wordpress.com 55

Click the target Cell

dennissaren.wordpress.com 56

Click on Function Box

dennissaren.wordpress.com 57

Type equal sign (=)

dennissaren.wordpress.com 58

Type Function name

dennissaren.wordpress.com 59

Highlight cells included in Function

dennissaren.wordpress.com 60

Complete Function syntax

dennissaren.wordpress.com 61

Press “Enter”

dennissaren.wordpress.com 62

ACCESSING ALL FUNCTIONS OF

GOOGLE SHEETS

dennissaren.wordpress.com 63

Click “Help”

dennissaren.wordpress.com 64

Click “Function List”

dennissaren.wordpress.com 65

“Google spreadsheets function list” will open

dennissaren.wordpress.com 66

CHANGING FONTS AND

FONT SIZE

dennissaren.wordpress.com 67

Highlight Cells

dennissaren.wordpress.com 68

Click “Font List”

dennissaren.wordpress.com 69

Select font type

dennissaren.wordpress.com 70

Click Font Size list

dennissaren.wordpress.com 71

Select desired size

dennissaren.wordpress.com 72

MERGING CELLS

dennissaren.wordpress.com 73

Highlight Cells

dennissaren.wordpress.com 74

Click “Format”

dennissaren.wordpress.com 75

Click “Merge Cells”

dennissaren.wordpress.com 76

Select Merging Type

dennissaren.wordpress.com 77

Highlighted Cells will merge

dennissaren.wordpress.com 78

PROTECTING SHEETS

dennissaren.wordpress.com 79

Click the arrow beside Sheet name

dennissaren.wordpress.com 80

Click “Protect Sheet”

dennissaren.wordpress.com 81

Click “Enter a Description” box

dennissaren.wordpress.com 82

Enter description

dennissaren.wordpress.com 83

Click “Set permissions”

dennissaren.wordpress.com 84

Choose “Restrict who can edit this range”

dennissaren.wordpress.com 85

Select “Custom”

dennissaren.wordpress.com 86

Type Email Address

dennissaren.wordpress.com 87

Click Done

dennissaren.wordpress.com 88

Click more options

dennissaren.wordpress.com 89

Select “The people the people or groups added”

dennissaren.wordpress.com 90

Click “share with edit permissions”

dennissaren.wordpress.com 91

Protected Sheet will appear in the list

dennissaren.wordpress.com 92

Protected Sheet will have “padlock” icon

dennissaren.wordpress.com 93

DOWNLOADING GOOGLE SHEETS AS

MICROSOFT EXCEL FILE

dennissaren.wordpress.com 94

Click “File”

dennissaren.wordpress.com 95

Click “Download as”

dennissaren.wordpress.com 96

Select “Microsoft Excel (.xlsx)”

dennissaren.wordpress.com 97

Wait until download is complete

dennissaren.wordpress.com 98

Click the file

dennissaren.wordpress.com 99

The file will be opened in Excel format

dennissaren.wordpress.com 100

SUCCESS is the continuing achievement of

becoming the person God wants you to be and accomplishing the goals God

has helped you set

CHARLES STANLEY

dennissaren.wordpress.com 101