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”


Press ENTER


Click “Sign in”


Enter your Google Email address


Enter your Gmail Password


Click “Sign In”


Click the icon


Click “Even more from Google”


Click “Sheets”


Click the “Go to Google Sheets”


CREATING NEW SPREADSHEET


Click (+) to start a new spreadsheet


New and untitled spreadsheet will open


Click “Untitled Spreadsheet”


Rename to “Sample_Spreadsheet_Tutorial”


SHARING SPREADSHEET

TO TEAM MEMBERS


Click at upper right corner


Enter email address of team member


Choose access type


ACCESS TYPES


SHARING SPREADSHEET

THROUGH FACEBOOK


Click “Advanced”


Click the Facebook logo


Click “On-Anyone with the Link”


Choose “Can View”


Choose “Share to Facebook”


Say something about the post


Click post to facebook


SHARING SPREADSHEET THROUGH GOOGLE MAIL


Click the Google Mail logo


Enter email address of recipient


Enter subject of email


Click “Send”


ADDING SHEETS


Click at the lower left corner


RENAMING SHEETS


Click beside the Sheet Title Bar


Click “Rename”


Type name of sheet


ENTERING DATA


Click on the cell


Type data you want to put


INSERTING LINKS


Copy link of destination website


Click on the cell


Click the “Insert Link” icon


Right Click on the Link Box


Click “Paste”


Click on Text Box


Type text to be displayed


Click “Apply”


Blue text will appear on the cell


USING FUNCTIONS FOR

GOOGLE SHEETS


Click the target Cell


Click on Function Box


Type equal sign (=)


Type Function name


Highlight cells included in Function


Complete Function syntax


Press “Enter”


ACCESSING ALL FUNCTIONS OF

GOOGLE SHEETS


Click “Help”


Click “Function List”


“Google spreadsheets function list” will open


CHANGING FONTS AND

FONT SIZE


Highlight Cells


Click “Font List”


Select font type


Click Font Size list


Select desired size


MERGING CELLS


Highlight Cells


Click “Format”


Click “Merge Cells”


Select Merging Type


Highlighted Cells will merge


PROTECTING SHEETS


Click the arrow beside Sheet name


Click “Protect Sheet”


Click “Enter a Description” box


Enter description


Click “Set permissions”


Choose “Restrict who can edit this range”


Select “Custom”


Type Email Address


Click Done


Click more options


Select “The people the people or groups added”


Click “share with edit permissions”


Protected Sheet will appear in the list


Protected Sheet will have “padlock” icon


DOWNLOADING GOOGLE SHEETS AS

MICROSOFT EXCEL FILE


Click “File”


Click “Download as”


Select “Microsoft Excel (.xlsx)”


Wait until download is complete


Click the file


The file will be opened in Excel format


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


how to use google sheets

Business