Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I feel like such a dunce, but I cannot figure out how/where to do this.

I've pasted a command button into a sheet and it came in with a default name of "Button 1". I cannot figure out where in the interface to go to change the button's name. (I can change the button's label text, I'm actually interested in renaming the button itself).

I've tried clicking "Design Mode" in the Developer Ribbon, but that does not seem to give me any additional interfaces or options for setting the button's attributes.

Help! (FYI: using Excel 2010).

share|improve this question
click on the Properties button to the left of the Design Mode button. then click the object you want to rename – Brad Jan 14 '13 at 19:18
@Brad, thanks. I tried that (I hadn't tried clicking Properties, then the Button, so you've moved me forward). However, when I click Properties (to the right of the Design Mode icon), then click the button, it doesn't show me properties for the button. Instead, it shows me properties for Module1. I've tried dropping down the list in properties combo box, to see if the button is listed, but it's not. What next, do you know? Thanks! – DWright Jan 14 '13 at 19:32
up vote 6 down vote accepted

You can change the name of the button (as well as any other object/chart) by selecting and typing in the small Name box left of the formula bar (confirm it by pressing Enter):

enter image description here

share|improve this answer
Thank you. That's what I was missing. Somehow my eye never went to the name box. The screen shot was exactly what I needed to see. – DWright Jan 14 '13 at 19:39
You're most welcome! – Peter Albert Jan 14 '13 at 19:51

This question is answered, but here's an important addendum:

There is a 32-character limit on the length of Command Button names.

The behavior if you enter a name longer than 32 characters is that Excel seems to ignore your input—no error message is given, but your changes are rolled back.

When this happened to me, I thought there must be some other panel or setting I needed to use, maybe there was some workbook corruption, etc. Once I figured out that the issue was just the name length, I experimented to confirm that on Excel 2010, 32 is the maximum length.

share|improve this answer
This should be a comment if it doesn't specifically answer the question. – wbeard52 Oct 6 '15 at 17:04

You can also right click on the command button, choose "command button object" and then choose "edit"

share|improve this answer

Select the Design mode on , right click properties " Alphabetic" change the name on caption to your desired name.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.