Question with tables

Jubinell

Board Regular
Joined
Jan 17, 2008
Messages
166
Hi,

I have a table listing projects a company has done at certain cities. Within one city there might have been several projects, so I have merged and center the cells under the city column for these projects into one. Like this:

Chicago__| P1
_________| P2
_________| P3

Those horizontal lines are meant to represent spaces, not borders.
I then put borders around and within all of the cells.

Now when I look at the print preview I see two problems when going from one page to the next.

1) The merged city cell appears only once (of course). Which means that when I came to a new page it was difficult to remember which city the project is for, unless I scroll back up to the previous page.
2) The borders do not go through the merge cells, which is nice within a page, but when viewing a new page it should go through a merge cell that was continuing from the previous page.

Any work-around to these problems? In other words:
1) Have the merged city re-appear for every new page.
2) Have the borders go through the merged cells for every new page.

Thank you in advance.
 
Last edited:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,221,314
Messages
6,159,187
Members
451,544
Latest member
MrsGrayMarlin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top