Need to SHARE your GOOGLE CALENDAR with staff or a LARGE GROUP of people? Here's a little trick! Don't type all of those emails!
GOOGLE SHEETS - DROPDOWN LIST
If you want consistent information in your GOOGLE SHEET, control what's entered in your Sheet by using a DROPDOWN LIST.
EXCEL - INSERT DROPDOWN LIST
INSERT a DROPDOWN LIST in EXCEL to control what's entered in your spreadsheet. I'm all about control - except in real life!
Inserting a dropdown list in Excel works best if you create your list ahead of time. I type the list on another sheet within the spreadsheet so that it's easy to access. If you need to edit your dropdown list, you can just edit the list on the other sheet and it will update the dropdown. You can even have multiple lists on the sheet if you have other questions that need a dropdown list. I also hide the sheet with the list so that it can't be accessed by other people. To do this, right click over the sheet tab and select Hide.
TECH TREAT of the MONTH - NOVEMBER 2017
You'll be THANKFUL that you learned in EXCEL how to INSERT A DROPDOWN LIST!
Subscribe to:
Posts (Atom)