How can I print a table and split it into two parts?

Question

Hi all,

I have a table with a few rows and a lot of columns and I want to print it on one page.

I this I saw the feature before to split the table into a few parts (among one another) but I don't remember if that was on an older or newer Excel version.

Anyone with an idea how to achieve this in Excel 2010? I hoped it would appear in the print menu, but I couldn't find it.

Thanks in advance!

(oh, and I don't want to transpose the table)

Answer 1

Hi,

You can easily compare data from separate worksheets in Excel 2010 by splitting. To do so, follow the steps provided below:

1. Click the split bar located above the scroll arrow at the top of the vertical scroll bar and hold down the mouse button.
2. Drag downward to your preferred row at which you want your worksheet window divided.
3. Release the mouse button.

You can also split your worksheet vertically by dragging the split bar located at the right edge of the horizontal scroll bar.

Let us know if you find this post helpful.