table to plain text in microsoft office word 2019

Table to plain text in microsoft office word 2019 series#

Sometimes we may wish to split a single table into several smaller tables. You can see the multipage view below now shows the column headings (the headings row) being repeated on every page:

The following screen shot shows that we have selected the headings row, and the option has become available:Ĭlicking on the Repeat Header Rows option enables the option. This option will be greyed out until a row (or rows) from the table is selected. On the far right hand side of the Layout ribbon is an option “ Repeat Header Rows”. Our table currently has a row of column headings (a header row), but this is not repeated as we page through the document, as shown by the screen shot below of a multipage view of our table: We can customise many elements of our table through the Table Layout ribbon: Once you have created the basic layout for your table you can customise it manually. On the right of the Table design ribbon you can see options to:Ĭustomising Word Tables Table Tool Layout Tab We will now choose the 7 th table style (Plain Table 5) and here is the result: You can see that the table styles are different to the default ones we saw when we first converted the text to a table (compare with the earlier screen shot). In the following example we have selected row headings, banded rows and a total row, but deselected First Column. You will see that as you tick or untick these boxes the Table Styles icons change to refelct your choices. Add a total column (Last Column tick box).Indicate that there is a row heading column (First Column tick box).Indicate that there is a column headings row (Header Row tick box).On the left of the Table design ribbon you can see options to: The predefined Table Styles can be customised using the tick boxes on the left hand side of the ribbon. Alternatively you can manually format the table. There are some short cut options to format your table by selecting one of the predefined styles in the Table Styles section of the ribbon. Regardless of which method you choose to create your table you can format it via the Table Design ribbon, accessible via the Table Tools context tab: Table Tools Design Tab The row delimiter is taken to be a new line and Word has recognised 831 rows (there were 830 data rows and a header row pasted from the Excel workbook). You can see that Word has detected that the selected text has tabs between each field and has, therefore, deduced that there will be 6 columns required in the table. Select the text to be converted and then choose the Convert Text to Table option: The Convert Text to Table option in the Table drop down enables us to specify row and field delimiters to convert the plain text to a table. Here is how the data would look if we pasted it just as text:Īs we have simply pasted text into Word we now need to convert this text into a table. If you right click in the location you wish to paste the data into you will see the following pop up menu – the last paste option labelled with an A is the simple text paste: We could start with this default layout and modify it or we could paste the data in as simple text and then create the table from scratch. We have default column widths which has resulted in some wrap arounds, and we have default border styles with a thin line. You can see that we get the column headers highlighted as a table header row, and a separate column created for each column copied from the Excel workbook. If we paste this selected range into word using a standard paste (CTRL-V) then a default table will be created for us: Here is an example of data from an Excel workbook that is simply pasted (CTRL-V) into a Word document: repeating headings on every page the table flows on to.In Working with Tables in Microsoft Word - Part 1 we will look at: It is easy enough to copy and paste a data set into Word from a source such as a Microsfot Excel workbook as a lot of default formats are applied when the data is pasted, but formatting it to your requirements is then often the challenge.

Table to plain text in microsoft office word 2019 series#

In a series of blogs I aim to run through some simple, but essential tasks when working with tables in Word. Microsoft Word offers a very powerful table feature, but it can be a bit of an art working with tables sometimes.