Join David Rivers for an in-depth discussion in this video Providing input options, part of Numbers 3 Essential Training.
Once we've cleared out all of the data…from our existing spreadsheet,…that's going to be used as a template,…we can make it easier for those that will be…using this template down the road…when it comes to data input.…For example, we have some columns here.…Month, Quarter, Category, Line Item,…where we have repeating data.…In this case we can provide a list of options…so they don't have to type it in,…they simply select it from a list.…That's what we're going to do here…in cell C2 for the category.…There's only two categories to choose from,…"Personnel" and "Operating," so instead of having them…type that out, we can provide those two options…on a pop-up menu, and that's what we're going to do.…
In this cell, we're going to do to the cell,…tab in our inspector, change the data format from automatic,…by clicking this button and choosing "Pop-up menu."…You can see there's some items here by default,…but let's go to item three, click the minus sign.…We only need two.…Now we'll double-click item one, and type in "Personnel."…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.