Tools, Free Download, Word, Office, Tables, Macros, VBA

The Community Blog for Business Analysts

Martin@DocProd
Martin@DocProd

Three Great Tools for Editing Tables

I use Microsoft Word a great deal in my work as a BA, it is my primary tool for formally communicating text based project deliverables. 

Where I can, I like to use tables, so that I can quickly capture information and present it without having to write full, grammatically correct paragraphs.

Over the last few years, I have prepared a number of tools to improve the way Word handles tables. Using these tools makes me much more efficient, and removes some impediments to maximizing the benefits of table use. 

These tools are written in VBA, Office’s macro development tool. Writing quick one-off macros can save a great deal of time in some situations, and something that a good BA should have some exposure to. Using these Tools and checking out how they work is a good way of getting started.

The tools are free to use and modify. They can be downloaded from the link in the signature block at the end of the post.

Number Table Rows

This tool numbers each row in a table. It is great for requirements listings, tasks lists and dozens of other uses.

It includes all the features a BA might look for, including multiple format options using prefixes and separators (e.g. NF.01, NF.02), and the ability break the table into subsections and having the option for these to have their own numbering sequence. It even allows you to carry the numbering from one table to another.

One of the things I like about this routine is that it begins by removing any blank rows. Cleaning up a table like this can be time consuming.

If you need to, you can lock the numbering once it is finalized. This is might be used when a set of requirements has been published.

Word does have some numbering tools, but these are clunky, and I find them frustrating to use. Being able to maintain a list of many entries, move, add, or delete rows, and then renumber the lot with just a quick keypress is are huge win for a busy BA. 

Insert Table Rows

This tool inserts five empty rows at the current location and positions the cursor ready for entry in the first. This is great for capturing lots if information quickly in the right place in the table.

Word does allow you to insert like this but there are a few issues; it takes a few keystrokes and, depending on how you insert, can copy incorrect heading or subheading formats into the new rows. 

With one keypress, this tool ensures that standard rows are inserted every time, and that the cursor is setup in the right place to start entry. The Number Table Rows tool can then be used to delete any unused rows.

Table Cell Formatting 

This tool cleans up table cells by adding punctuation and removing empty paragraphs at the end of the cell. It operates on selected cells or the current cell if no range is selected. 

When I capture information quickly in a table, I find I often forget to punctuate correctly and can leave empty paragraphs and the end of a cell. 

Checking and correct all entries when I’m ready to publish a table is time consuming and mechanical, circumstances ideal for an automated routine.

The tool processes each paragraph in the selected cells. It skips paragraphs that already have some form of punctuation at the end, and for those that don’t, adds a “.” character at the end. If the paragraph is at the end of the cell, and it is empty, it gets deleted.

The tool skips the first column and first row even if you selected them. This is to preserve the numbering and headings. The tool is also a good introduction to the complexities of handling end of cell markers in Word table programming.

Summary

I use these tools every day, and without them, would find my productivity levels dropping, and my frustration levels rising. A good BA has a bag full of useful tools and these are at the top for me.

My next post will describe Three Great Tools for Bulleted Lists.

About the Author

Martin Coomber is a BA based in Wellington, New Zealand. He is a Certified Business Analyst Professional, tutors IIBA study groups, and mentors other BAs. His Document Productivity website provides document editing tools to the BA community. 

This entry was published on Aug 23, 2014 / Martin@DocProd. Posted in Tools. Bookmark the Permalink or E-mail it to a friend.
Like this article:
  1 members liked this article

COMMENTS

Karen222 posted on Wednesday, September 2, 2015 8:36 AM
I used to apply following macros to the tables in a document to delete paragraph marks at the end form cells:

Sub TablesRemovePilcrons()
Dim oTbl As Table
Dim oCll As Cell
For Each oTbl In ActiveDocument.Tables
For Each oCll In oTbl.Range.Cells
While oCll.Range.Characters.Last.Previous = Chr(13)
oCll.Range.Characters.Last.Previous = ""
Wend
Next
Next
End Sub

Nice thing about macros is that it can be easily modified and it is really convenient (source of the code is: writemytermpapernow.com)
Only registered users may post comments.


Blog Information

» What is the Community Blog and what are the Benefits of Contributing?

» Review our Blog Posting Guidelines.

» I am looking for the original Modern Analyst blog posts.



Modern Analyst Blog Latests

Jarett Hailes
Jarett Hailes
As we start a new year many of us will take the time to reflect on our accomplishments from 2012 and plan our goals for 2013. We can set small or large goals. goals that will be accomplished quickly or could take several years. For 2013, I think Business Analysts should look to go beyond our traditional boundaries and set audacious goals. Merriam-...
2 Responses
Howard Podeswa
Howard Podeswa
Recently, I was asked by the IIBA to present a talk at one of their chapter meetings. I am reprinting here my response to that invitation in the hope that it will begin a conversation with fellow EEPs and BAs about an area of great concern to the profession. Hi xx …. Regarding the IIBA talk, there is another issue that I am considering. It's p...
11 Responses
Adrian M.
Adrian M.
Continuing the ABC series for Business Analysts, Howard Podeswa created the next installment titled "BA ABCs: “C” is for Class Diagram" as an article rather than a blog post. You can find the article here: BA ABCs: “C” is for Class Diagram Here are the previous two posts: BA ABCs: “A” is for Activity Diagram BA ABCs: “B” is for BPMN
1 Responses
Featured Digital Library Resources 
Copyright 2006-2015 by Modern Analyst Media LLC