columns within columns

  • Thread starter Thread starter Helixal
  • Start date Start date
H

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?
 
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
 
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
 
Thanks Gord,
Worked like a charm

Gord Dibben said:
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
Click to expand...
 
Back
Top