Tabulating office documents is a critical skill for office administration professionals, ensuring that data is presented clearly and efficiently for decision-making and communication. In Kenya’s dynamic workplaces, ranging from county government offices to financial institutions like SACCOs, well-formatted tables enhance reports, minutes, and correspondence. This chapter focuses on the principles and techniques of formatting and displaying tabulated information in office documents, improving readability and professionalism.

1.1 Formatting of office document tabulations

Tabulation is the arrangement of information in rows and columns so that it can be read and compared at a glance. Offices tabulate figures, lists and comparisons in letters, reports, minutes and notices. Formatting a tabulation means giving it a clear title and headings, aligning its columns, sizing its rows and placing it neatly on the page. Today tabulations are produced with the Table tools of a word processor (Insert, Table in Microsoft Word), which add the Table Design and Layout tabs, or in a spreadsheet when many calculations are needed.

Parts of a table

• Title (main heading): says what the table shows, typed above the table.
• Column headings: name the contents of each column, sometimes with units (Ksh, kg).
• Stub (first column): names each row, such as months, items or names.
• Body: the data in the cells.
• Totals row: sums of the figure columns, where needed.
• Footnotes or source line: explanations and the source of the data, below the table.

The first four sub-topics below are kinds of information commonly tabulated in an office; the rest are the formatting skills used to produce them.

1.1.1 Statistical information

Statistical information is numerical data collected and summarised, such as counts, percentages and averages: staff numbers per department, customer enquiries per month, or attendance at training sessions. A table lets the reader compare the figures quickly. Statistical tables need a clear title stating what was counted and when, units in the column headings, figures aligned on the right or on the decimal point, and totals or averages where helpful.

1.1.2 Reports

Reports often contain tables that summarise their findings so the reader does not have to pick figures out of paragraphs. The table is numbered and titled (Table 1: ...) and referred to in the text.

Sales

A sales report table shows sales by period, product, branch or salesperson, often with a total and a comparison with target or the previous period. The stub lists the products or periods and the columns hold the amounts in Ksh.

Weather

A weather report table shows readings such as rainfall (mm) and maximum and minimum temperature (°C) by day, week or month. An organisation planning field work, events or deliveries may tabulate weather data to support its decisions.

1.1.3 Financial statements

Financial statements such as a statement of financial position (balance sheet), an income statement, a budget or a cash summary are presented in tabular form. They need right-aligned figures with the same number of decimal places, thousands separators (12,500.00), clear sub-totals and totals (often with a single rule above and a double rule below the final total), and the period or date in the title, for example "Budget for the year ending 30 June 2026".

1.1.4 Academic settings

Tables are used to present academic information such as timetables, class lists, examination results, course schedules and training records. A training office may tabulate staff training attendance, or a department may tabulate the results of an internal test. These tables are usually sorted (by name or by score) and need column headings that state the subject and the maximum mark.

1.1.5 Office documents tabulations formatting

Formatting gives the whole table a consistent and professional appearance. Good practice:

• Use one font and size, the same as the document's body or one point smaller.
• Make the title and column headings bold; the title may be in capitals.
• Use borders lightly (or a simple built-in Table Style); avoid heavy shading that photocopies badly.
• Leave enough space in cells (cell margins) so the text does not touch the borders.
• Keep the table width within the margins and consistent with the page.
• Use the same format for every figure in a column (decimal places, separators).

1.1.6 Centring vertically and horizontally

A table on a page of its own is centred horizontally (equal space left and right) and vertically (equal space above and below) so that it looks balanced. In Word, the table is centred horizontally with Table Properties, Table, Alignment: Center, and the page is centred vertically with Layout, Page Setup, Layout tab, Vertical alignment: Center. Text inside cells can also be centred with the alignment buttons in Layout, Alignment.

1.1.7 Sorting – sorting rows and columns into ascending or descending order

Sorting arranges rows in order of the values in a chosen column: ascending (A to Z, smallest to largest, oldest to newest) or descending (Z to A, largest to smallest). In Word, select the table and use Layout, Sort, choose the column, the type (Text, Number or Date) and the order, and tick "Header row" so the headings stay at the top. A list of suppliers is usually sorted alphabetically; a sales table may be sorted by amount in descending order to show the best results first. Columns are reordered by cutting and pasting them, since the sort tool works on rows.

1.1.8 Calculating/computing totals

Totals are added at the foot of figure columns (and sometimes at the end of rows). They must be correct and checked: an error in a total makes the whole table unreliable. In Word they are calculated with a formula field (see Use of sum function below); in a spreadsheet with the SUM function. The word "Total" is placed in the stub and the totals are often bold.

1.1.9 Column headings

Column headings name the contents of each column. They are short, bold, and usually centred over the column; units are shown in the heading (Amount (Ksh), Weight (kg)) rather than repeated in every cell. Where columns are grouped, a spanned heading is placed over them using merged cells. For a table that runs over several pages, the heading row is set to repeat on each page (Layout, Repeat Header Rows).

1.1.10 Merging cell

Merging joins two or more neighbouring cells into one. It is used for a title row across the whole table, or for a heading that spans several columns (for example "Quarter 1" over January, February and March). Select the cells and choose Layout, Merge Cells. Split Cells does the reverse.

1.1.11 Figure alignment

Figures are aligned so that units, tens and hundreds (and decimal points) fall under each other, which makes columns easy to read and add. Whole numbers are right-aligned; numbers with decimals are aligned on the decimal point (a decimal tab in the cell, or right alignment with the same number of decimal places). Text is normally left-aligned and headings centred.

1.1.12 Use table row height feature

Row height sets how tall each row is. In Word it is set in Layout, Cell Size, Height, or in Table Properties, Row, "Specify height" with "At least" or "Exactly". Equal row heights give a neat appearance; extra height can be given to the heading row or to rows where people will write by hand (as in a register or sign-in sheet). Distribute Rows makes selected rows the same height.

1.1.13 Use of sum function

The SUM function adds a range of numbers. In a Word table, place the cursor in the total cell and use Layout, Formula: Word suggests =SUM(ABOVE) for a column or =SUM(LEFT) for a row, and a number format can be chosen. The result is a field: if a figure changes, select the field and press F9 to update it. In a spreadsheet the same task is done with =SUM(B2:B5).

Example: monthly sales in Ksh of 45,000, 52,500, 38,250 and 61,000 give =SUM(ABOVE) = 196,750.

1.1.14 End notes

Notes that explain items in a table (a source, a definition, an exception) are placed below the table and linked to the item by a symbol or number, for example an asterisk after a figure and "* Estimated figure" under the table. In a longer document, the word processor's Insert Endnote tool (References, Insert Endnote) places numbered notes at the end of the document or section and renumbers them automatically.

1.1.15 Multiple tables in one

Sometimes two or more related tables are presented together, either side by side on one page or as one table divided into parts with sub-headings (for example "Head Office" and "Branch" sections in one staff table). Each part keeps the same column structure so they can be compared. Nested tables (a table inside a cell) can be inserted in Word, but they are hard to read and are used sparingly; separate tables with a blank line between them, or a merged sub-heading row, are clearer.

Chapter Summary

This chapter explored the formatting of office document tabulations, covering diverse applications such as statistical data, reports, financial statements, and academic records. Key formatting techniques included centring content both vertically and horizontally, sorting data in ascending or descending order, calculating totals using functions like sum, and aligning figures effectively within tables. The chapter also addressed the importance of clear data presentation in tabulation displays and outlined best practices for designing tables that enhance readability and comprehension. In producing tabulated office documents, emphasis was placed on selecting high-quality paper, adhering to standard sizes such as A4 portrait, understanding proofreading marks, and applying proper formatting before saving and printing final copies. Finally, the chapter highlighted the purpose and importance of filing tabulated documents, described various filing systems, and detailed the preparation and procedures necessary for effective filing within an organization. Together, these topics provide a comprehensive guide to creating, presenting, managing, and preserving tabulated office documents in professional settings.