Hi Frantisek (or is it Imagino),
Not sure if you just mean columns A & B. If it is only
A&B then you have to make the columns narrower and
either shrink to fit within cells or split lines within a cell
such as using Alt+Enter which gets you an automatic
wrap cells. Wrapping within cells wraps a cell at the
boundary of a cell.
Depending on what you've done before
you might be forced to readjust manually your row heights
or use a macro.
There are no controls in Excel that indicate columns or
rows must be kept together
You can use file, page setup, page, fit to page
the pages wide by pages tall are two independent
parameters, you can use either, both, or neither.
You can adjust the margins (page set, page, margins
or easier in Print Preview)
You can introduce your own page breaks to break before
an automatic page break would have occurred.
You can change the font size so you can use a narrower
column. You can also use Shrink to fit for a cell
under format, cells, alignment, shrink to fit.
You can adjust the width of a single column by dragging the
line between the column headers (A,B,C). You can select
multiple columns and do them at once for the same width,
or for all columns by using Ctrl+A and then doing one of
those. Any of those can be adjusted automatically by
double-clicking on the demarcation line between column headers.
You can do the equivalent for rows, but you are only concerned
with columns here.
can double click on any line between the column headers (A,B,C),
to adjust to the widest. Or you can do a single column by not
selecting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> I have a huge table where some cells in the first column are merged,
> some are not.
> When I print this table, on the paper some merged cells are split onto
> two papers. I do not want this, I need those merged cells together.
>
> Imagino
David McRitchie - 03 Apr 2005 17:33 GMT
In rereading your question, and perhaps I am put more meaning
into this than you intended but you indicated "some merged cells"
possibly meaning not all merged cells. So if some merged cells
were okay, I would assume that is because they would fit in
Column A anyway -- is that true?
You might experiment with Text boxes, they will get split between
pages, but it might give you a little more flexibility in some usages,
if they are just going to have constant descriptive content.
---
HTH,
David McRitchie, Microsoft MVP - Excel