ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to add a radio button in excel (https://www.excelbanter.com/excel-worksheet-functions/213902-i-want-add-radio-button-excel.html)

Steven D

I want to add a radio button in excel
 
We have instructions for many different files that we need to run and under
each of them we want to list out items that should be looked at during a peer
review.

Not all choices would be used on all files. I was thinking that having
radio buttons would make it easy for us to click the ones we want as we have
over 500 instructions. We could then copy and paste the excel sheet into
WORD (saved as Web page filtered).

Also, is there any way to keep the dark boxes around what I have in excel
when I transfer it to WORD? I get the boxes, but not the darkened part.
--
Steven D

Dylan @ UAFC[_2_]

I want to add a radio button in excel
 
Steve
you have to have the eveloper tab on your window.
If not go to excel option and download the add-ins.

One you have done that, there a insert selection that
has the radio button.
Select the one you want past into the cell
it should ask you if would like to center it the
cell I would strongly advise that.
Make sure you have border on your cell.
go to help menu if you look for outlines and border.
When cntrl C cntrl V it should work not probelm

"Steven D" wrote:

We have instructions for many different files that we need to run and under
each of them we want to list out items that should be looked at during a peer
review.

Not all choices would be used on all files. I was thinking that having
radio buttons would make it easy for us to click the ones we want as we have
over 500 instructions. We could then copy and paste the excel sheet into
WORD (saved as Web page filtered).

Also, is there any way to keep the dark boxes around what I have in excel
when I transfer it to WORD? I get the boxes, but not the darkened part.
--
Steven D



All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com