Is there a way to make Column Headings actual words in my spreadsheet? I know I can just made the headers of each of my columns by dressing them up with formatting, but I'm actually trying to use the numbers to count the rows. Any ideas? (I've already uncheck the R1C1 option)
Nope, you have only the options of A,B or 1, 2.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
It might help if you described what you're trying to accomplish. You start out talking about column headers, but then say you are "actually trying to use the numbers to count the rows." Not sure how words for column headers relates numbers for counting rows. What do you want the finished product to look like?
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
I'm making a list of travelers. I'd like my Column headings to say "Last Name" "First Name" etc. I'd like my rows to count the number of travelers. If I type into Row 1 the correct Column Headings, it counts one more traveler than necessary. At this point, it looks like it is not possible, so I adding a column and inputting numbers 1 - 100. I was just hoping the pre set numbering would work.
In your added column you can use
=ROW()-1
instead of typing in all those numbers.
If you just need a count, and don't need serial numbers for each individual entry, you can use
=COUNTA(A:A)-1
which will count all nonempty cells in Column A.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks