Adding Colum to a Row od info...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 26 Apr 2008 00:29 GMT

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

Reply to this Message

Neil - 27 Apr 2008 17:08 GMT

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

> I have a music database when opened in Excel in has all info in rows and I
> would like to add a few columns.
[quoted text clipped - 8 lines]
>
> Jeff

Reply to this Message

Rayashe - 28 Apr 2008 23:37 GMT

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 Data>Text to Columns>Next 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.

> I have a music database when opened in Excel in has all info in rows and I
> would like to add a few columns.
[quoted text clipped - 8 lines]
>
> Jeff

Reply to this Message

Rate this thread: