Thursday, November 21, 2024

Latest Posts

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.

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


For enquiries, product placements, sponsorships, and collaborations, connect with us at hello@zedista.com. We'd love to hear from you!


Our humans need coffee too! Your support is highly appreciated, thank you!

Latest Posts

A Field Guide To A.I.
Navigate the complexities of Artificial Intelligence and unlock new perspectives in this must-have guide.
Now available in print and ebook.

charity-water

Don't Miss