columns within columns

[Helixal]

I'd like to make a single page spreadsheet with the twelve months across the
top. within each, i would like 4 or 5 columns representing the weeks.this
will be an actual 2010 calendar. the titles for the inner columns will be
the date of the first monday of the week. vertical grid lines separating
the months are a little darker than the grid lines separating the weeks. the
y axis will be the values to be entered

any suggestiions?

 

[Billy Liddel]

Before you start have a look at John Walkenback's calender @

http://spreadsheetpage.com/index.php/files


Look for Array Formula Calander that you can download.

HTH
Peter

 

[Helixal]

This seems more complex than I need.
Let me ask how do you put a label (e.g. "JAN") over the 5 columns
representing the 5 weeks in January 1010?

I also need to know how to place a vertical line eevery 4 or five columns.
When I use formatting I get a vertical line between all the columns

Thanks

 

[Gord Dibben]

Type JAN in A1.

Select A1:E1 and format to "center acrosss selection"

To have a vertical border, select column E and CTRL + Click on column H and
add a left hand border.


Gord Dibben MS Excel MVP

 

[Helixal]

Thanks Gord,
Worked like a charm

Type JAN in A1.

Select A1:E1 and format to "center acrosss selection"

To have a vertical border, select column E and CTRL + Click on column H
and
add a left hand border.


Gord Dibben MS Excel MVP