Laptop and spreadsheet

Simple Things That Are Good To Know In Google Spreadsheets

Google Spreadsheet has been with us for a long time. Here are some simple things that might help you in building your next spreadsheet.

From our partners:

cyberpogo

1. The maximum number of characters to name a sheet is 50 

Sheet name max limit is 50 characters
Sheet name max limit is 50 characters

2. Items in the Trash or Bin will be deleted forever after 30 days.

Items moved to the trash will be deleted forever after 30 days
Items moved to the trash will be deleted forever after 30 days

3. Filter Views are an excellent way of creating quick filtered records without having to edit the Filters for everybody else.

Default view:

Sample data of scientists and birth dates
Sample data of scientists and birth dates

Filtered view:

Filter view of January birth dates
Filter view of January birth dates

4. Utilizing conditional formatting provides a faster way to know patterns or status

Conditional formatting example
Conditional formatting example

In this simple example, we just colored the background to green if the value is “January”.

5. Quick calculations can be viewed in the lower right corner.

Including Sum, there are Average, Min, Max, Count and Count numbers.

Quick calculations
Quick calculations
LEARN MORE  Creative Tips That Will Make You More Efficient In Managing Email


For enquiries, product placements, sponsorships, and collaborations, connect with us at [email protected]. We'd love to hear from you!



Our humans need coffee too! Your support is highly appreciated, thank you!
Total
0
Shares
Previous Article
People using on laptop

Increase Productivity With These Simple Tips

Next Article
lahaina-hawaii-wildfires-aftermath-5283

Lahaina Wildfires - Here's How You Can Help

Related Posts
Total
0
Share