Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
CNF CNF is offline
external usenet poster
 
Posts: 1
Default How do I create checkboxes in Excel 2007?

Hi,

I'd like to add some checkboxes to a particular column in a spreadsheet I'm
creating but I can't find any easily apparent way to do this on Excel 2007.
Can anyone advise?

Thanks ;0)
--
CNF
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 185
Default How do I create checkboxes in Excel 2007?

CNF

You need to activate the developer tab (Office buttonExcel
options...Popular tabShow developer tab on ribbon

The form controls are on this tab

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"CNF" wrote in message
...
Hi,

I'd like to add some checkboxes to a particular column in a spreadsheet
I'm
creating but I can't find any easily apparent way to do this on Excel
2007.
Can anyone advise?

Thanks ;0)
--
CNF


  #3   Report Post  
Junior Member
 
Posts: 27
Default

Quote:
Originally Posted by CNF View Post
Hi,

I'd like to add some checkboxes to a particular column in a spreadsheet I'm
creating but I can't find any easily apparent way to do this on Excel 2007.
Can anyone advise?

Thanks ;0)
--
CNF
You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.

Sample check boxes Sample radio button controls

To add either a check box or an option button, you’ll need the Developer tab on your Ribbon.

Notes: To enable the Developer tab, follow these instructions:

In Excel 2010 and subsequent versions, click File Options Customize Ribbon , select the Developer check box, and click OK.

In Excel 2007, click the Microsoft Office button Office button image Excel Options Popular Show Developer tab in the Ribbon.

To add a check box, click the Developer tab, click Insert, and under Form Controls, click Button image .

the check box control on the ribbon

To add an option button, click the Developer tab, click Insert, and under Form Controls, click Button image .

the radio button control on the ribbon

Click in the cell where you want to add the check box or option button control.

Tip: You can only add one checkbox or option button at a time. To speed things up, after you add your first control, right-click it and select Copy Paste.

To edit or remove the default text for a control, click the control, and then update the text as needed.

edit text for a form control


I hope these steps will be helpful!
Tim Paine
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a min-max bar chart in excel 2007 ? Junkyard Engineer Charts and Charting in Excel 5 December 30th 07 03:01 PM
How do I create a list in excel 2007? CDB1124 Excel Worksheet Functions 3 October 9th 07 09:41 PM
Cannot create charts in Excel 2007 Whiz_In_Ache Excel Discussion (Misc queries) 0 August 21st 07 03:25 PM
Excel 2007 - cannot create an outline 6538 Excel Discussion (Misc queries) 1 July 3rd 07 12:45 AM
How do I create mailing labels in excel 2007? fireroute New Users to Excel 1 June 4th 07 09:51 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"