macro for row showing no column markings


Brandy Barton

In an excel document, I want the top two rows to have one or two wide colums
that go across the page, whilst the remainder of the rows have much narrower
colums, up to 8 across the page - this will split the colums when shown and
printed out- can this be done - must admit to be very new to Excel and all
advice would be welcome.



Gord Dibben

Column widths and row heights are properties of the entire column and row.

Maybe Center Across Selection would work for you?

I hesitate to mention "merged cells" due to the problems they can cause but
for printing only they are useful.

Gord Dibben MS Excel MVP

On Sun, 22 Nov 2009 12:23:01 -0800, Brandy Barton <Brandy

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question