Spreadsheets: Excel: how to write text across multiple columns

Self-tutoring with Excel: the tutor shares a tip about extending text over multiple columns.

Let’s imagine you want to title a spreadsheet. You probably want to center the title at the top: likely it will run across more than one column, especially if the title font is larger than inside the sheet.

Here’s how I found to do so:

  1. Select the row across the top.
  2. Right-click the selection, then choose Format Cells.
  3. Choose the Alignment tab.
  4. Under Horizontal, click the dropdown menu to reveal Center Across Selection.
  5. Click Center Across Selection, then OK.

Source:

answers.microsoft.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply