How to Make Lined Columns in Microsoft

By Kathryn Hatashita-Lee

Microsoft Office can format columns in a Word document or an Excel worksheet. Word's 'Page Layout" tab on the command ribbon includes a list of column formats. A vertical separator line can insert between the columns for a newsletter, for example. Excel's "Home" tab contains "Font" commands that format the worksheet cells for a custom look. Excel can insert a pre-set border or a custom border to outline a column or every cell in the column.

Insert a Separator Line Between Columns in Word

Step 1

Open the Word document.

Step 2

Click the "Page Layout" tab on the command ribbon.

Step 3

Click the down-arrow for the "Column's button in the "Page Setup" group. A list of column formats appears.

Step 4

Click the "More columns" button. A "Columns" dialog window displays a list of column formats.

Step 5

Click the preferred format or type a value in the text box. For example, type "3" to set three columns.

Step 6

Select the check box for "Line Between."

Step 7

Click "OK." A vertical separator line appears between the columns.

Insert Line Borders for Excel Columns

Step 1

Open the Excel worksheet.

Step 2

Click the "Home" tab on the command ribbon.

Step 3

Click and drag the mouse to select a range of cells or a column. The column and row headers change color.

Step 4

Click the down-arrow on the "Borders" button in the "Font" group. This button is located between the "U" and paint can symbols. A list of border styles appears.

Step 5

Click the preferred border style. For example, "All Borders" outlines every cell. You can opt to draw borders for certain cells or columns.

Tips & Warnings

  • The Excel program contains a variety of line styles, such as a dotted line or a heavy solid line. Right-click the range of cells. Click "Format Cells." The "Border" tab lists line styles and border positions.