I have a music database when opened in Excel in has all info in rows and I
would like to add a few columns.


Want to Add Col 1 Col 2 Col 3
Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1]

Is there a way to do this as the database is quite large. I have Office
2007.

TIA

Jeff

To insert a row into the complete spreadsheet, right click on the header for
the column AFTER where you need you new column to appear, from the context
menu select 'Insert' and you will get a new cloumn insrted into your
worksheet.

HTH

Neil
www.nwarwick.co.uk


"Jeff" wrote:

I have a music database when opened in Excel in has all info in rows and I
would like to add a few columns.


Want to Add Col 1 Col 2 Col 3
Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1]

Is there a way to do this as the database is quite large. I have Office
2007.

TIA

Jeff

Do you want to split Row 1's information into columns?
Eg:
Col 1 Col 2 Col 3 Col 4
America 06/03/2007 America Here & Now

If that is the case the I would assume that all of your information is in
column A only?
Highlight the range from start cell (Row 1) to last cell in column A only
and select DataText to ColumnsNext select Other and put your - in the box,
Next, you may need to scroll down here to get to a line that has the most
information separated by the - and then click Finish.

"Jeff" wrote:

I have a music database when opened in Excel in has all info in rows and I
would like to add a few columns.


Want to Add Col 1 Col 2 Col 3
Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1]

Is there a way to do this as the database is quite large. I have Office
2007.

TIA

Jeff