Make the best of Google Sheets with these four hacks

When working in a team, you often need to perform specific tasks over the same document. Hence, platforms such as Google Sheets come in handy.

Google Sheets is popular for being a detailed yet simple and collaborative option for users worldwide. If you are someone who uses it frequently, here are some tips to stay at the top of your game;

1. Change the format for numbers

Sheets are widely used for data entry. Numbers might need formatting as per need. Select the numbers, move the cursor to the main toolbox, and opt for either the dollar, percentage, or decimal symbol and change accordingly.

2. Change themes

Based on the task, you can choose a theme if you want to add specific colours to the text or the graphics on the sheet. To do so, click on Format and select Themes from the menu. You can customise your chosen theme as well.

3. Limit choices with a drop-down list

If the sheet requires different entries, but you don’t want any random or varied texts, you can give the choice of entries to the users. To do so, click Data on the main menu, then select Data validation. Now set the list of items that should be chosen.

4. Adding heatmaps through conditional formatting

You may miss out on essential things when working with a lot of data. Opt for conditional formatting to highlight specific data based on their high or low values. To do so, right-click the cells and choose view more cell actions and opt for conditional formatting.

For more such tips, click here and have fun working on Sheets!

Source link

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker