Google sheets
Caps to lowercase
How to change uppercase and lowercase text in Google Docs Updated: 09/03/2019 by Computer Hope Uppercase text example Google Docs does not include the ability to change case by default. However, there are add-ons that provide this functionality. To enable this feature in Google Docs, follow the steps below. How to find an add-on Open a Google Doc document. Click Add-ons at the top of the window and then Get Add-ons... In the search box, type Case and press Enter. To select an add-on, click the Button to download an app from the Google app store. button on the right side. Tip Although many add-on options are available, we suggest the "Change Case" add-on by Alec Tutin. How to use the add-on The steps below were written using the aforementioned "Change Case" add-on. If you made a different choice, the instructions should be similar. Highlight the text you want to change. Click Add-ons and then Change Case. Select All uppercase, All lowercase, First letter capitals, Invert case, Sentence case, or Title case, depending on your needs.
Date
How to make google sheets show a date.
Right-click the selection you want to have the date picker show up for (i.e. single cell, entire row, entire column) and then open data validation. Set Criteria: Date is a valid date and click Save. Now just double-click the cell!
Upload files
URL how to find
