Today I learned that you can make the formula bar bigger in Google Sheets

Byryan

Formulas can get pretty complex in Google Sheets (or any spreadsheet for that matter), and the one line formula bar raises the annoyance bar. Being able to extend the formula bar is a godsend!

Excel already has the ability, and apparently Google added the ability back in 2016. I just found out about it last week.

Grabbing the bottom of the formula, the cursor turns into an up down arrow, and you can drag down to make the formula bar larger.

You won’t be able to hit return to put line breaks in your formula, but hitting control-enter will.

This is really exciting!!

Similar Posts

Host self contained web sites in a web address

Host self contained web sites in a web address

Byryan

Itty bitty sites are contained entirely within their own link. (Including this one!) This means they’re… ?Portable – you don’t need a server to host them  ?Private – nothing is sent to –or stored on– this  server  ?Easy to share as a link or QR code Itty bitty sites can hold about as much as a printed page, and there is a lot you can do with…

Create timelines with Timetoast

Create timelines with Timetoast

Byryan

Source: Timetoast timeline maker | Timetoast timelines Here’s a pretty cool looking timeline creator app. Timetoast (the free version) allows users to create public timelines. Unfortunately, I didn’t see any mention of an educational discount for the paid tiers, which add collaboration features. Also, there is only a Facebook login, so students will have to…

Coding for kids with Codemoji

Coding for kids with Codemoji

Byryan

Source: Codemoji® – Coding for Kids! I love all of the different takes on getting kids coding, and Codemoji® looks at using emojis to replace a lot of the static code someone would use when learning programming. Without an account, students can use the a few different playgrounds to get their feet wet. Codemoji® also…

Create a searchable library of your classroom books and games with Libib

Create a searchable library of your classroom books and games with Libib

Byryan

Source: Libib.com – Home library management web app Libib is an online catalog for books, movies, music, and video games. The free version allows you to catalog your media, while the Pro version ($75 a year for education) adds features such as lending. If you were struggling with keeping track of materials in your classroom you will…

Do you have an Android phone running Oreo? Use Google Go to read webpages to you

Do you have an Android phone running Oreo? Use Google Go to read webpages to you

Byryan

Today, we’re launching a new feature which will let everyone using Google Go’s browser listen to webpages out loud. Powered by natural language processing and speech synthesis AI, this technology can read aloud billions of webpages in 28 languages smoothly, and in a natural sounding voice, even on 2G connections. It also uses minimal cellular…