How to Make Lined Columns in Microsoft

Techwalla may earn compensation through affiliate links in this story.
Excel and Word 2010 can insert lines between columns of data.

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.

Advertisement

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.

Advertisement

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.

Advertisement

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.

Tip

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.

Advertisement

references