maybe I should state my question better.
right now - the columns are named A B C D E F and so on. I want to label each colum where A is a name and I can put that name in where A is in the heading - not in the fields, but on the column heading, and then another name for B C D E F and so on. Thanks if anyone knows how to do this.
2007-10-16 05:21:08 · 5 answers · asked by art_flood 4 in Computers & Internet ➔ Software
art...
just remember ..."no question is a silly question"...we all have to learn.
with that being said the column headings A B C D... and the row headings 1 2 3 4 .... are not changable. they are simpy guides and will not print.
Now what you can do is place column headings Under each A B C..... and those headings can be frozen -so that they are always present on your screen. These new headings can also be se to print on each page if your print is more than 1 page.
The same is true for the rows....if you want to name them...they also can be frozen and/or printed on all pages.
i have used excel since 1980. when it first came out it was only for Macintosh computers....IBM computers used Lotus. So if you have any further questions on how to accomplish the column name, freeze or print...please do not hesitate to contact me.
thanks and good luck .. :)
2007-10-16 05:46:09 · answer #1 · answered by Blue October 6 · 2⤊ 0⤋
Column Headings In Excel
2016-12-26 06:26:26 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Excel Column Headings
2016-10-03 02:57:18 · answer #3 · answered by ? 4 · 0⤊ 0⤋
This Site Might Help You.
RE:
Excel Column Headings -?
maybe I should state my question better.
right now - the columns are named A B C D E F and so on. I want to label each colum where A is a name and I can put that name in where A is in the heading - not in the fields, but on the column heading, and then another name for B C D E F and so on. ...
2015-08-19 18:18:27 · answer #4 · answered by Fleta 1 · 0⤊ 0⤋
No, you can't change the column headings, but if you really want to, you can make it look like they're changed by making the first row look like those column headings:
- Format your first row to look like you want (like the column headings).
- hide the real headings: Tools-Options-View-uncheck Row & column headers
- go to cell A2 and do Window-Freeze Panes, so that your new headers always stay at the top
This will result in column headings, but no row numbers. If you want row numbers, then:
- put your new row numbers in column A
- format column A to look like you want
- go to cell B2 and do Window-Freeze Panes
You can still change column widths using Format-Column-Width (and row heights, similarly).
If you need more info, add more detail, or e-mail.
Cheers.
.
2007-10-16 05:43:42 · answer #5 · answered by aladou 5 · 2⤊ 0⤋
I think it can be done with visual basic. I know you can get to Visual Basic through Excel, and I suspect this is going to provide the answer to your question. If you don't know much about Visual Basic, I'd get a book before I got too deep into it.
2007-10-16 05:40:29 · answer #6 · answered by chollymon2002 2 · 0⤊ 3⤋
You can't do this silly goose. and if you have a question in excel there is a box on the top left of the program - you type in your questions and it gives you different answer options
2007-10-16 05:29:15 · answer #7 · answered by Kalli 3 · 2⤊ 2⤋