#1
|
|||
|
|||
Excel table properties
I am making a logbook in excel 2010. When I enter columns excel wants to give the columns with the same name a number. How can I use the same names for columns? I have included the file I use.
|
#2
|
|||
|
|||
Hi
It is not clear from your post what your issue is. I have had a look at your spreadsheet and cannot work out what the issue is. Please provide more detail and I will look again. Tony(OTPM) |
#3
|
|||
|
|||
Quote:
Thanks for your reply. The question was if it is possible to have the same names for the collumns? I have solved the issue by placing one or two spaces after the name to have the same names (eg. "day" and "day "). With the spaces it is good enough for me, but is it possible to give the same names for collumns? |
#4
|
|||
|
|||
Hi
Excel has default built in Column Headers, they are either A, B, C, etc ot you can change the configuration to show 1,2 3 4 5 6 etc. You can define your own column headers in Row 1 for example and these can show as many duplicates as you wish. The question is how are you using the spreadsheet and why do you want to have duplicate headers? Tony(OTPM) |
#5
|
|||
|
|||
I understand your problem, its a table thing!!
An Excel table requires unique headers, to enable filtering/sorting etc. Thats why its appending integers. It is really illogical to have duplicate header names, so rename them something meaningful, ie StartDay, EndDay etc. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Excel Table to Powerpoint | gsteveli | PowerPoint | 0 | 05-25-2011 07:50 PM |
Excel data to Word table | Jaymond Flurrie | Word VBA | 2 | 02-27-2011 07:42 PM |
Outlook Export Body Table to Excel | almecum | Outlook | 0 | 08-10-2010 11:28 AM |
Updating excel link alters table format in PP | dbmagnus | PowerPoint | 0 | 06-03-2010 12:12 PM |
Converting MSWord table to MS Excel spreadsheet | MiaLouise | Office | 1 | 03-09-2010 10:08 AM |