Keep those names flowing

BY J. CARLTON COLLINS

Q: We have 170 hourly employees and, as part of my job, I prepare job assignment reports in Microsoft Word that contain several lists, sorted by name. As you can see in the attached example report, I use a three-column table in Word to list these names. The problem arises when I make small changes to these lists, such as deleting a name in column one. This forces me to readjust each subsequent column using the cut and paste commands multiple times. There has to be an easier way to do this, and I’ll bet you are going to suggest an Excel solution, but I don’t know how to use Excel. Is there an easier way to accomplish this in Word?

 

A: Your best solution might be to use Word’s Column tool to display multiple columns. The key to using the Column tool is to insert continuous section breaks before and after the columns to prevent the remainder of the Word document from also displaying multiple columns.

 

To use this feature, insert a section break where you want the columns to start, as follows: From the Page Layout tab, select Breaks, Continuous (under Section Breaks). Next, from the Page Layout tab, select Columns, Three. Thereafter, your three-column list of names flows seamlessly from one column to the next.

 

This allows you to insert or delete names anywhere in the list, and the columns adjust accordingly. Once you have completed this process, insert another section break at the end of your last column, then set the formatting back to a single column to prevent any text or data below from displaying a multiple column format, as follows: Position your cursor after the last column entry, then from the Page Layout tab, select Breaks, Continuous (under Section Breaks). With your cursor positioned after the second section break, from the Page Layout tab, select Columns, One. The results appear as follows:

 

 

Note: If necessary, you also can sort your Word list as follows: Highlight the list and, from the Home tab, click the Sort icon from the Paragraph group. You also can force a column break at any point in your list by positioning your cursor where you want the column break to occur and then, from the Page Layout tab, selecting Breaks, Column.

 

More from the JofA:

 

 Find us on Facebook  |   Follow us on Twitter  |   View JofA videos

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.