Learn Best Google Sheet Tips and Tricks
From longtime best alternative for Microsoft office is Google Docs. This is because Google Docs allows the user to create presentations, Google word Documents and spreadsheets online web and also its free too. Google Sheets are more notable and used in their daily business activities and in some personal tasks. Today we will discuss about Top 6 Google Sheet tips and tricks that will blow everyone mind whoever accessing your Google sheet.
- =Image Function
Everyone knows that they can easily add images to Google sheet but do you how fast you can do this with a small formula =Image (“url”) . Put your image link in this parenthesis and inside the quotes. This will definitely save you more time and no need to download or upload any image.
- Try To Use Google Sheet Templates
Most of the users are using 1000’s of templates in Microsoft Office and also I want to mention here same way like Ms-office you can make use of templates in Google sheet. Here is the simple way to get google sheet templates. GoTo Google Docs, click “Create New” and you have to select “From Template” and choose whatever template you like.
- Google Sheet Keyboard Shortcut List
Keyboard shortcuts are the best way to make your things quick and stay productive. You no need to search online or ask your friend for Google sheet shortcuts. Why Because Google sheet provides it’s shortcuts in a simple way and to access it just press “Ctrl + Forward slash” for Windows users and “Command + Forward slash” for Mac users.
- Keep Focus in Full Screen
You will get easily distracted by other things around you. It always better to work in full-screen mode which will give you complete focus and pleasant looking window. Google Docs has the option to solve this distraction called “Full Screen” mode. Under “View” menu select Full screen.
- Conditional Formatting
Conditional formatting is a highlight feature in any spreadsheet work. Google sheet has no difference when compared to Microsoft Excel sheet. You can set parameters to filter in conditional formatting and user can view the difference instantly.
- Access More Currencies
If you’re working in any MNC Company Accounts Section, then you might be familiar with this option. This currency option in Google sheet makes you to set the currency for particular cell or row or column. Click on “123” button in the menu bar and scroll down to “More currencies”.
I hope you learnt something new with this Top 6 Google Sheet tips and tricks. On upcoming articles, we will try to bring more about google sheet and excel tricks. Keep Visiting our blog and any suggestions don’t hesitate to mention in our comment section below.
You May Also Like: How To Colour Alternate Rows in Google Sheet
Article was very helpful.