Hello lovely people!
In this blog post, I am going to show you how to do five quick and easy things to your Google Sheets that will make people think you are a professional spreadsheeter with a degree in spreadsheets.
No but seriously – they’re pretty cool and can help you organise your spreadsheet. At least visually!
1. HORIZONTAL TEXT WITHIN GOOGLE SHEETS
This is one I use with my progress trackers because it makes the tracker more compact and fit nicely on the screen where I can see everyone on the same screen. All you have to do is click the cell with the text you want to alter and click on one of the A (with an arrow) buttons to change up your text. Pretty snazzy.
2. SEPARATE YOUR TEXT
I don’t think I have ever personally used this as I am honestly unsure where it would be effective but I know that some educators do like to use this so I thought I would include it. It is pretty cool after all.
3. CHANGING THE CURRENCY WITHIN GOOGLE SHEETS
One of my colleagues taught me this because we a member of staff asked about it and we were like ‘ooooh, investigations!’ so we found out that although Google Sheets are default in Dollars, you can change it to pounds!
Type in a number of your choice. Alternatively, if you’re actually doing this on a sheet where you’d like to change currency, click on that cell!
4. EMBEDDING A CALENDAR INTO YOUR GOOGLE SHEETS
I find this one super duper useful with my progress trackers as it allows me to embed submission dates into the sheet. It was also beneficial for our digital leaders tracking table when they tracked their hours as they were able to put the date they completed the work. I love it. I want you to love it. Let me show you how to do it.
All you need to do is go to the top navigational bar to ‘Data’, click on it.
From there, find ‘Data Validation’ from the drop-down menu.
For criteria, select ‘Date’ and press ‘Save’
5. ADDING BORDERS
I wouldn’t say this was a trick – more of a tip. Borders, for me, are incredibly important as it can really make or break a spreadsheet and really helps with visualisation. There are a couple of different borders you can do, but I am more towards putting borders around each cells!
I really hope these helped with your spreadsheet mastery! Please let me know if you need any help, I am always available here or on Twitter @CharlieLecuyer9
Thank you for reading!
Adventures in Learning Technology 🐝 