Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 9th 12, 10:59 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2011
Posts: 3
Default Make first imported CSV row into column names ?

Hi,

Is there a way to make the column names in the first row replace the
A,B,C... in the excel tabs?

I am importing a CSV with the col names in the 1st row. It would be
nice to be able to make the ABCDE... into the corresponding col names
from the csv first row, then delete the first row as it is not really
data but I guess it could be called meta-data.

Can this be done during the import process, or easily in one swoop
after the import?

OR

Is the best practice to make the first row unchangeable and not part
of the data that can be manipulated in the sheet? - seems that would
serve same purpose as what I'm asking above.

Thanks.

  #2   Report Post  
Old January 9th 12, 11:39 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Make first imported CSV row into column names ?

You cannot change/overwrite the Column headers A, B, C etc.

You can hide them but this also hides row headers.

Best is to Freeze Panes so row 1 with your titles stays in view at
all times..........where you find that command depends upon your
version of Excel.

You don't say so I'll assume 2003 or 2007

2003.............Select A2 then WindowFreeze Panes

2007.............ViewFreeze PanesFreeze Top Row


Gord


On Mon, 9 Jan 2012 14:59:19 -0800 (PST), goldtech
wrote:

Hi,

Is there a way to make the column names in the first row replace the
A,B,C... in the excel tabs?

I am importing a CSV with the col names in the 1st row. It would be
nice to be able to make the ABCDE... into the corresponding col names
from the csv first row, then delete the first row as it is not really
data but I guess it could be called meta-data.

Can this be done during the import process, or easily in one swoop
after the import?

OR

Is the best practice to make the first row unchangeable and not part
of the data that can be manipulated in the sheet? - seems that would
serve same purpose as what I'm asking above.

Thanks.

  #3   Report Post  
Old January 10th 12, 11:23 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2011
Posts: 3
Default Make first imported CSV row into column names ?


Best is to *Freeze Panes


This worked, thanks.

Is there a way to start the row numbers at the left from 0 instead of
one?

I could start this question in a new thread if necessary.

I want the 1st row of actual data to be 1 not 2, that's why I ask.

Thanks.
  #4   Report Post  
Old January 11th 12, 04:55 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Make first imported CSV row into column names ?

Row numbers are fixed and cannot be changed...........same rulles as
column letters.

For appearance only you can hide the row headers, which will also hide
column headers.

In A2 enter =ROW()-1 and copy down as far as you wish.

UnFreeze Panes then select B2 and re-freeze panes.

NOTE: I state "appearance only".

Any other use of those numbers could cause confusion.

Any formulas created would have to account for the mis-labeled rows.


Gord


On Tue, 10 Jan 2012 15:23:38 -0800 (PST), goldtech
wrote:


Best is to *Freeze Panes


This worked, thanks.

Is there a way to start the row numbers at the left from 0 instead of
one?

I could start this question in a new thread if necessary.

I want the 1st row of actual data to be 1 not 2, that's why I ask.

Thanks.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename imported MS Access field names Ron Excel Discussion (Misc queries) 1 May 7th 09 05:17 PM
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET r.kordahi Excel Discussion (Misc queries) 2 January 3rd 09 08:10 AM
Make words imported into numbers, ex SMRC=303 mulligbo Excel Discussion (Misc queries) 2 October 31st 06 10:03 AM
How do I add imported data with a - sign after it to make it add . Eileen White Excel Discussion (Misc queries) 2 May 18th 06 08:01 PM
How do I make a graph of the frequency names come up in a column? gziomek Charts and Charting in Excel 3 December 28th 05 11:55 PM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017