How to Make Lined Columns in Microsoft

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.

...
Excel and Word 2010 can insert lines between columns of data.

Insert a Separator Line Between Columns in Word

Step

Open the Word document.

Step

Click the “Page Layout” tab on the command ribbon.

Step

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

Step

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

Step

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

Step

Select the check box for “Line Between.”

Step

Click “OK.” A vertical separator line appears between the columns.

Insert Line Borders for Excel Columns

Step

Open the Excel worksheet.

Step

Click the “Home” tab on the command ribbon.

Step

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

Step

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

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