Google Sheet is most popular todays for the offices and business purposes. As Google sheet is online so it is more useful. Google sheet makes the life easier and simple of the business mans. They can easily manage their office works on Google Sheet from every place. Even they can use Google sheets on their mobile phones. That is a big advantage for them. Google owns the Google sheet. Google also provides the Google Doc facility that is same like Microsoft Word. If you want to start your own business, you can find business ideas on the Info Rise Hub. check out new business ideas here that can be start with low investment.
In this article we will talk about Google sheets, that how Google sheet works. Following is the table of content where you can find main topics of the Google sheet article.
Table of Content
What is Google Sheet?
A Google Sheet is same like Microsoft Excel Sheet. It is simple and easy to use online. Google sheet has rows and columns interface. Those users who have Microsoft excel skills can easily be use Google sheet. The formulas and formatting is same as Microsoft Excel.
What are the benefits of Google Sheet?
Many users want to know, that what are the benefits of Google sheet? As you know Google sheet is an online application or tool. And Google provides the Google sheet application. So we can easily use Google sheet anywhere at any time. Even you created your Google Sheet in your office, you can manage it from your home.
The one more benefit of Google sheet is you can share your Google sheet with different users as you want. You can authorize options like view sheet and edit etc. according to your needs. The attached users can see live changings or updates in the Google sheet.
How to Create Google Sheet?
How to Sign in Google Sheet?
Creating a Google sheet is very simple and easy way. You need to login on your Gmail account. If you do not have any Gmail account, first create your Gmail ID. After login on the Gmail, click on Google apps (nine dots button) appears on the top right side. Scroll down and click on Sheets icon. Your Google sheet successfully created. Now you can work in your Google sheet easily.
How to Search in Google Sheet?
You can search on Google sheet by using CTRL + F button. OR you can use Edit option in the menu bar. Click on Edit in the menu bar. Click on the Find and Replace option. Find dialogue box will be open. There you can search any data you want in your Google sheet.
How to Share Google Sheet with Others?
Google Sheet can be share with others. There are two methods to share your Google sheet with others. The first is simple you can see share button on top right side of your Google sheet. And the second one is you can find Google sheet share option in the File menu bar.
- Click on the File option in the menu bar.
- There you can find share option. Click or mouse hover on the Share option.
- Click on share with others
- Give a suitable name to your Google sheet
- Here you will find share with people and groups.
- Enter the Gmail address of individuals or enter the name of any group if you have circle group.
- After completing the share with people process, click on the “Done” button.
- You can also send the link to your group members.
- You can copy the link from Get Link option below in the share with people and groups.
How to add Superscript in Google Sheet?
Superscript function is not available in the Google sheet. Anyway you can use copy paste option for superscript. Simple copy superscript from MS Word and paste it in the Google sheet.
Or if you have knowledge about CHAR function, you can use CHAR function for writing superscript in the Google sheet. For example if you want to write a2 in the Google sheet. You can write =”a”&CHAR(178). This will write a2 in reply.
How to Use Google Sheets on Mobile Phone?
If you want to use Google sheet on your mobile phone, you need to get Google sheet app from Google Play Store. There you can create or open already created Google sheets easily. Google sheet is also mobile friendly. So it’s easy in use on mobile phone.
How to Add Drop Down List in Google Sheets?
You can find drop down list item in Data option in the menu bar.
- Click on the cell where you want to create drop down list.
- Then click on the Data option in the menu bar.
- Click on Data Validation
- A Data validation box appears on the screen.
- Choose criteria (List from a range, list of items etc.) according to your needs.
- Enter the range of items that you want to show in drop down list.
- Click on the Save button
That’s it, your drop down list created successfully.
Leave your feedback for Info Rise Hub posts in the comment section. Don’t forget to share Google sheet article with your friends. And also share this article on social media websites like Facebook, Twitter, Whatsapp, Instagram, Pinterest etc. If you want to read more informative articles follow the link please.