Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Working With Alignment and Wrap Text

This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.

VIDEO

Excel offers the option not only to align text left, center, and right but also top, middle, and bottom. Using alignment, the look of a spreadsheet can be customized in-depth.

Horizontal Alignment                  

  1. Select the cells which should be aligned in the desired manner.
  2. Select the alignment desired by left-clicking any of these three buttons on the toolbar.
             1
    • These options can also be reached by selecting Format > Cells > Alignment from the menu bar on Macs.

Text Wrap

If the amount of characters is too large in a cell, it will be hidden from view. This can be fixed by things such as smaller text size or dragging the column header to expand the column size. Wrap Text is a feature that allows text to be wrapped around in a cell thus creating a larger cell vertically.
  1. Select the cells which should have the Wrap Text feature applied.
  2. Select the Wrap Text Tool from the toolbar. 2
    • These options can also be reached by selecting Format > Cells > Alignment from the menu bar on Macs.

Vertical Alignment

If Text Wrap has been applied then there will now be multiple rows of text in the cell. This allows the text to be aligned vertically.
  1. Select the cells which should be aligned in the desired manner.
  2. Select the alignment desired by left-clicking any of these three buttons on the toolbar.  
              3         
    • These options can also be reached by selecting Format > Cells > Alignment from the menu bar on Macs.



If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or helpdesk@uwosh.edu




Keywords:Horizontal, Vertical, text wrap, "Formatting & Layout"   Doc ID:65922
Owner:William W.Group:UW Oshkosh
Created:2016-08-09 14:51 CDTUpdated:2016-08-09 14:54 CDT
Sites:UW Oshkosh
Feedback:  0   0