1

I have a table in a sheet like this:

enter image description here

I want to place the table in the middle of page. but the number of column is odd (5) and the number of column in the sheet is even (8). there is 2 cols after table and 1 col before it. so the table is not in the middle and after printing it is not in the middle too. how can I place the table in the middle of sheet?

Improve this question

1 Answer 1

Reset to default
2

Set your print area to be just the table you want to print (page layout - print area - set) then in page setup select to center your data both vertically and horizontally.

If you want to see also the empty cells around your table then set the print area to be the seven column wide range and as tall as you need.

Improve this answer
2
  • how can I set the print area to be the seven column wide range?
    – user123
    Jun 24, 2015 at 8:57
  • select the range you want to be printed than click "set print area", I've added link to the solution.
    – Máté Juhász
    Jun 24, 2015 at 11:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .