Edit text in a control on a worksheet

You can edit the text that is displayed in a Form control or ActiveX control, such as a label or help information, and you can edit the alternative text description for a control.

What do you want to do?


Edit the text in a Form control

  1. Select the Form control.

For more information, see Select or deselect controls on a worksheet.

  1. Right-click the selection, and then click Edit Text.

The control border shows a dashed pattern.

Text box with a hatched border

  1. Edit the text for the control.
  2. After you have finished editing the text, right-click the selection, and then click Exit Edit Text.

Top of Page Top of Page

Edit the text in an ActiveX control

  1. If the Developer tab is not available, display it.

ShowDisplay the Developer tab

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note   The Ribbon is a component of the Microsoft Office Fluent user interface.

  1. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.
  2. Select the ActiveX control.

For more information, see Select or deselect controls on a worksheet.

  1. Right-click the selection.
  2. Point to the name of the object (for example, CheckBox Object), and then click Edit.
  3. Edit the text for the control.
  4. After you have finished editing the text, press ESC.

Top of Page Top of Page

Edit an alternative text description for a control

Web browsers display alternative text (alt text) while images are loading, if pictures are missing, and can also display alternative text if you position the pointer over an image. Web search engines use alternative text to help find Web pages. Alternative text is also used to help users who have disabilities.

  1. Select the control.

For more information, see Select or deselect controls on a worksheet.

  1. Right-click the selection, click Format Control, and then click the Web tab.
  2. In the Alternative text box, type the text that you want displayed.
 
 
Applies to:
Excel 2007