Category: Formatting data

Formatting a spread sheet column so it spans multiple columns.

I have some data in two columns in Google sheets (also in Libre office Calc). How do I print it so it is two columns (of two columns) , down the first column, down the second column, and onto another page?

The easiest way for me was

  • Copy the column of data into the clip board.
  • Go to libre office writer
  • Paste the data
  • Top line of options, Format -> Page style ( or Shift+Alt+P)
  • Select the Columns option on the top line
  • Columns + (to make it two columns)
  • OK
  • Set a heading
    • Insert -> header and footer ( near the bottom)
    • Header – > all
  • Set a page number
    • Insert -> Page number ( 5th from the bottom)