Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 09, 08:23 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2009
Posts: 1
Default macro for row showing no column markings

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.

  #2   Report Post  
Old November 23rd 09, 06:11 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default macro for row showing no column markings

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
wrote:

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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro showing and hiding detail KC Excel Discussion (Misc queries) 1 October 20th 09 07:56 PM
Excel 03 Macro w/Menu not showing in 07 GMC Excel Discussion (Misc queries) 1 June 24th 09 12:20 PM
Hiding and Showing Sheets using Macro engbe Excel Discussion (Misc queries) 3 May 12th 08 05:14 AM
What do these markings (--) do in a formula? RLind Excel Worksheet Functions 8 February 6th 07 10:45 PM
Assign a Macro feature not showing Danno Excel Worksheet Functions 2 October 7th 05 07:37 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017