Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel rename columns
Name: d4ndouk Date: April 3, 2003 at 07:12:51 Pacific OS: win 2k CPU/Ram: 1ghz 256
Comment:
hi just wondering if there was a way to replace the column names A....B....C....etc with myu own names for example age...eye colour....etc
Name: A Certain TH Date: April 4, 2003 at 02:52:11 Pacific
Reply:
I'm pretty sure you can't do this - Excel is a spreadsheet and has references in a cartesian fashion. Access allows you to do this, as it references in a database fashion.
If you are creating a database, then you may find that Access is the right place for it. If you are going to use Excel as a database then you should always remember that it is a spreadsheet application first and foremost.
If you still want to use Excel, then you can hide the Row & Column Headers from Tools... Options... View. So at least they aren't visible, and then yes - type your column headers into row 1 (or go mad and use row 2, if you fancy it!)
Summary: Hi everyone, I am very green when it comes to Excel, so I'll do my best to explain what I need to do. I have 2 custom host files that I want to merge. They have duplicate entries which I want to filte...
Summary: I have 5 excel spread sheets. Each spreadsheet has a common column named "Part Number". I have merged the 5 spreadshees and now have duplicate part numbers in the "Part Number" column. Ideally, I w...
Summary: Excel wont let me sort 2 of my columns because it says they are numbers stored as text! There is a little green triangle in the upper left-hand corner of the cells. Even if I recreate the document i...
0 
