Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / April 2005

Tip: Looking for answers? Try searching our database.

Print merged cells correctly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frantisek Horalek - 03 Apr 2005 09:32 GMT
Hello,
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.

How to do that?

Thanks for any help!

Imagino
David McRitchie - 03 Apr 2005 13:54 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.