• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Excel spreedsheet problem

I am not great at excel but need to create a spreadsheet that has about 30 columns and about 40 rows with data. I also need to have the name, date of birth and todays date at the top of the spreadsheet with wider columns that will not increase the size of the columns below. Is this possible in excel. thank you.
0
jodyreid
Asked:
jodyreid
1 Solution
 
John HurstBusiness Consultant (Owner)Commented:
A column is the same width for ALL rows. So the way you stated it, No.

Here is what you can do:

1. Make the header row taller than the data rows and allow the title to wrap. I do this.

2. If a data element has two columns (does not appear so), you can join two columns in one row with the Merge and Center icon.
0
 
convergintCommented:
When you type in your headers, just highlight them and use the Wrap Text function in the ribbon bar.  It's left of the number formatting in the Home ribbon tab.
0
 
Russell FoxDatabase DeveloperCommented:
Better still, merge multiple cells together for your main header (see attached example).
MergeCells.xlsx
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
John HurstBusiness Consultant (Owner)Commented:
merge multiple cells together  <-- Yes. Merge and Center was what I proposed above.  But also as I noted, this does not work if the header is over only one cell of numbers (birthdays -ymd usually are better as one cell).
0
 
Russell FoxDatabase DeveloperCommented:
Sorry, John, you're right - I only saw the wrap text part of your answer. No points for me, please.
0
 
jodyreidAuthor Commented:
Thank you all for your help.
0
 
John HurstBusiness Consultant (Owner)Commented:
@jodyreid  - You are very welcome and I was happy to help.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now