/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
A-Z replacement 0 Recommended Answers 7 Replies 16 Upvotes
1 Update
$0 Updates
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
0
Hi, I try to change a table names in blank sheet, instead of having fro left to right rows A-Z i want to have 1, 2 , 3, ect. 
this is all i need
Thanks
Relevant Answer Relevant Answers (0)
All Replies (7)
Relevant Answer
just type in  1  in cell a1
press & hold ctrl and drag all the way across
done

marked this as an answer
Relevant Answer
Hi, thanks for a responce
1. it did not work, just like nothing happening, do not know why
2. even if it worked it still shows A-Z in top.... and this is exactly thing I do not want. It interrupts. so when I print it out, I have to cut it?
 I found it hard to believe that google, a giant company, created so many extreme complicated things did not figure a way to change such simple option..... :O 
3. I really do appreciate Your help. Thanks again !!!
marked this as an answer
Relevant Answer
Hi,
 
Just curious, how do you get the A to Z column headers to print?
marked this as an answer
Relevant Answer
Hello,
 
You can not change the column letters to numbers, labels or whatever. You can't even do this in Excel.
 
 
Both column letters and row numbers are necessary in a spreadsheet for cell referencing.
 
 
 
James :) 
marked this as an answer
Relevant Answer
James, 

You can indeed change the A-Z column labels to numbered columns in Excel. I do it all the time as I prefer writing macros using numeric iterations and identifying the columns by number.

It is done by selecting File > Options > Formulas > Working with formulas, and checking the R1C1 reference style check box.

I would love to be able to do this in my online spreadsheet doc.
marked this as an answer
Relevant Answer
James, 

You can also regexextract() from address() to get column letter.

You can do the same in excel. Just have to parse it properly from address() function.
marked this as an answer
Relevant Answer
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Removed from Updates
Marked as Recommended Answer
Marked as Update
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
Known Issue
Fixed
Marked Fixed
Unmarked Fixed
Unable to mark fixed
Unable to unmark fixed
/docs/profile/0