Join Jess Stratton for an in-depth discussion in this video Setting workbook view options, part of Office for iPad and iPhone Essential Training.
…Tap the view ribbon icon, to customize how your spreadsheet will look.…You can toggle the formula bar and the sheet tabs on and off.…This is useful to clear up visual clutter if you know you don't…plan on using those features.…Once you're done with your sheet completely you can also tidy the view…by turning off the cell letters and the grid lines.…Finally, you can free certain pins so that they won't scroll.…This is useful if I have hundreds of products that would require scrolling but…the heading to stay put so I can keep track of where it is.…
I'll tap Freeze Top Row and now if I scroll.…You'll notice that that top row stays put.…I can also freeze the first column instead of the row.…This is useful.…If I had put all of the months of the year in I would of had to scroll.…However, now I can still keep track of which product I'm looking at.…Up next, let's work with sheets.…
- Installing Office for iPad
- Exploring the interface
- Creating new documents, spreadsheets, and presentations
- Changing the page layout in Word
- Inserting pictures and charts in Excel
- Adding slide transitions in PowerPoint
- Collaborating in Office for iPad and iPhone
Skill Level Beginner
Q: This course was updated on 11/07/2014. What changed?
A: We added new movies and updated existing ones to include the new Word, Excel, and PowerPoint apps for iPhone as well as discuss Dropbox integration. While most of the course was filmed on an iPad, the apps work very similarly on both the iPad and iPhone. Also check out the <a href="http://www.lynda.com/Office-tutorials/Office-iPhone-First-Look/361524-2.html"><em>Office for iPhone First Look</em></a><em></em> course to explore which editing features are available to all users and which require an Office 365 subscription.
1. Word for iPad
2. Excel for iPad
3. PowerPoint for iPad
4. Outlook for iPad
4. Collaborating with Office for iPad
- 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.