How to Make Lined Columns in Microsoft

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
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

Video of the Day

Step 1

Open the Word document.

Video of the Day

Step 2

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

Advertisement

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.

Advertisement

Insert Line Borders for Excel Columns

Step 1

Open the Excel worksheet.

Step 2

Click the "Home" tab on the command ribbon.

Advertisement

Advertisement

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.

Advertisement

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.

Advertisement

Advertisement

references