The google sheet has been one of the best tools available out there. One can achieve amazing things by using this cloud-based tool. This post is all about the top 10 things google sheets can do. Let’s take a look at it in more detail.
1. Shortcut Trick
If you want to create a new spreadsheet, then no need to open the main Google Sheets website and click the new sheet option. Rather, simply type “sheet.new” straight away in the browser’s address bar. This will create a new spreadsheet. You can also type “sheets.new” or “spreadsheet.new,” if you like.)
2. Fast-formatting
Google Sheets’ fast-formatting shortcuts are also extremely important. With the correct blend of keys, you can structure and format any cell or group of cells however you like. No need to explore menus. These keys are:
- Ctrl-Shift-1: You can format it as decimal
- Ctrl-Shift-2: You can format it as time
- Ctrl-Shift-3: You can format it as a date
- Ctrl-Shift-4: You can format it as currency
- Ctrl-Shift-5: You can format it as a percentage
- Ctrl-Shift-6: You can format it as an exponent
3. Personalized Shortcut
Users can also create their own personalized shortcuts within Google Sheets to execute a complicated sequence of configured steps with one command. To execute this,
- Open the Tools menu and select Macros.
- Next, select Record macro.
- If you like the shortcut to forever be executed on the exact particular cells, choose “Use absolute references”; else, choose “Use relative references.” Then execute whatever activities you like to record.
4. Freeze Your Rows
To freeze the selected rows simply hover the mouse over the base of the cell in any google sheet’s upper-left intersection—that first cell instantly above “1” and to the left of “A.” When you notice the hand sign occurs, click it and pull it down for as many rows as you like to freeze. The rows you choose will invariably stay in place and observable at the top of your spreadsheet. In this way, the rows can be frozen to work on the huge volume of data.
5. Google Forms Survey Style
Google Sheets has an effortlessly forgotten feature named Google Forms that allows users to gather data in a survey-type form on the web and then collect the outcomes in a spreadsheet. You can build a form by going to the Form option inside Sheets’ Insert menu, and then utilizing the website that comes up to build any group of questions and variables you like. When the form is prepared, click the Send button in the upper-right intersection of the page to email it to other users, implant it on a web page, or obtain a link for transmitting it however you want. As replies arrive, they’ll implicitly arise in your spreadsheet as their rows.
6. Upper and Lower Case
Sheets can normalize case structure for you with some easy functions: For example,
- =Upper(A1) will transform the entered text into uppercase
- =Lower(A1) will transform all the text into lowercase
- =Proper(A1) will simply capitalize the first letter of each word.
7. Translate
If you want to translate any text in Google sheets then no need to go to the browser. Simply, navigate to Google Translate, and paste the desired text in. For example, just use the =GOOGLETRANSLATE function, and the entered text will be translated efficiently.
8. Add Special Characters
You can enter special characters such as the right arrow, trademark symbol, and thumbs-up emoji into any spreadsheet. To accomplish this, simply use the Char command and place the numerical values of characters you often depend on. For example:
- =CHAR(8594) will create a right-facing arrow.
- =CHAR(169) will create the copyright symbol
- =CHAR(8482) will give the trademark symbol
- =CHAR(128077) will give the thumbs-up emoji.
9. Google’s Artificial Intelligence
You can use Google’s artificial intelligence in the sheets to execute various kinds of data analysis and complete various charts for you. to do this, simply hover the mouse on the starburst-shaped icon in the right corner of the screen, and you’ll notice the term Explore occur. Click that button, and Sheets will show you a board of data connected to your data. You can emphasize distinct rows in your spreadsheet to adjust its priority, and you can glide over any object it offers to discover alternatives for modifying it or entering it instantly into your sheet.
10. QR Codes
By using third-party applications, Google sheets can produce QR codes that’ll utilize whatever URLs when they’re scanned. To accomplish this, simply type the desired URL into a cell (with http:// or https://it), then utilize the below function with the necessary cell number:
=image(“https://pic-qrcharts.com/chart?chs=250×250&cht=qr&choe=UTF-8&chl=”&ENCODEURL(D4))
