Join Jess Stratton for an in-depth discussion in this video Formatting cells, part of Office for iPad and iPhone Essential Training.
…I'm going to show you some things that you can do within cells directly.…The first thing that you might want to do is merge a cell with another one.…This can stop potential problems with overlapping.…Tap and drag and select your cells that you want to merge.…Then, on the home ribbon tab, select the merge button.…Tapping the merge button will merge those three cells.…Notice how the text is centered now within the cells that I merge.…Something else you might want to do is have Excel for iPad take over…sizing the cells for you based on the data that's in there, that's called auto fit.…
To auto fit, tap the column letter, and…then tap the two vertical lines to bring up the menu.…After that, tap AutoFit.…You'll notice that it automatically resized itself so…that you can now read all the words clearly.…I've shown you already how you can change the data type of a cell.…You can do it when an entire column is selected, and…change all the cells at once.…These are similar to the choices that you have in the desktop version of Excel,…
- 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 Office for iPhone First Look 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.