Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-29-2007, 04:42 PM
Kelvin
 
Posts: n/a
two questions, Yes/No form control, and how did they create this adjustable area on the sheet...

I see that I can instert form control/option button, but what I need is to
have a list of questions that can each be answered Yes/No

Question Yes No
Question Yes No
Question Yes No

Also I was asked to help with spreadsheet that has what appears to be a box
(could be the print area) around the data.
Outside of that box is sort of grayed out...
I can drag the edge of the box with my mouse and it seems like it changes
the print area...

I have no idea how they created this area on the spearsheet

Any help would be appreciated!

Kelvin


Reply With Quote
  #2 (permalink)  
Old 11-29-2007, 04:53 PM
Kelvin
 
Posts: n/a
Re: two questions, Yes/No form control, and how did they create this adjustable area on the sheet...

I figured out that the issue with the option buttons what a security/macro
not being enabled... but I havn't figure out the other question.

Kelvin

"Kelvin" <someone@domain.com> wrote in message
news:OQ3yvbqMIHA.4880@TK2MSFTNGP03.phx.gbl...
>I see that I can instert form control/option button, but what I need is to
>have a list of questions that can each be answered Yes/No
>
> Question Yes No
> Question Yes No
> Question Yes No
>
> Also I was asked to help with spreadsheet that has what appears to be a
> box (could be the print area) around the data.
> Outside of that box is sort of grayed out...
> I can drag the edge of the box with my mouse and it seems like it changes
> the print area...
>
> I have no idea how they created this area on the spearsheet
>
> Any help would be appreciated!
>
> Kelvin
>



Reply With Quote
  #3 (permalink)  
Old 11-29-2007, 05:19 PM
M. Authement
 
Posts: n/a
Re: two questions, Yes/No form control, and how did they create this adjustable area on the sheet...

I believe you are talking about Page Break Preview mode. To turn this
feature on/off, go to View|Page Break Preview. This allows you to use the
mouse to change where page breaks occur, not the print area.

Hope that helps!


"Kelvin" <someone@domain.com> wrote in message
news:uqhwghqMIHA.5860@TK2MSFTNGP04.phx.gbl...
>I figured out that the issue with the option buttons what a security/macro
>not being enabled... but I havn't figure out the other question.
>
> Kelvin
>
> "Kelvin" <someone@domain.com> wrote in message
> news:OQ3yvbqMIHA.4880@TK2MSFTNGP03.phx.gbl...
>>I see that I can instert form control/option button, but what I need is to
>>have a list of questions that can each be answered Yes/No
>>
>> Question Yes No
>> Question Yes No
>> Question Yes No
>>
>> Also I was asked to help with spreadsheet that has what appears to be a
>> box (could be the print area) around the data.
>> Outside of that box is sort of grayed out...
>> I can drag the edge of the box with my mouse and it seems like it changes
>> the print area...
>>
>> I have no idea how they created this area on the spearsheet
>>
>> Any help would be appreciated!
>>
>> Kelvin
>>

>
>



Reply With Quote
  #4 (permalink)  
Old 11-29-2007, 05:49 PM
Kelvin
 
Posts: n/a
Re: two questions, Yes/No form control, and how did they create this adjustable area on the sheet...

that was it!

Thanks

Kelvin


"M. Authement" <mautheme@kcc.com> wrote in message
news:%236toHwqMIHA.5208@TK2MSFTNGP04.phx.gbl...
>I believe you are talking about Page Break Preview mode. To turn this
>feature on/off, go to View|Page Break Preview. This allows you to use the
>mouse to change where page breaks occur, not the print area.
>
> Hope that helps!
>
>
> "Kelvin" <someone@domain.com> wrote in message
> news:uqhwghqMIHA.5860@TK2MSFTNGP04.phx.gbl...
>>I figured out that the issue with the option buttons what a security/macro
>>not being enabled... but I havn't figure out the other question.
>>
>> Kelvin
>>
>> "Kelvin" <someone@domain.com> wrote in message
>> news:OQ3yvbqMIHA.4880@TK2MSFTNGP03.phx.gbl...
>>>I see that I can instert form control/option button, but what I need is
>>>to have a list of questions that can each be answered Yes/No
>>>
>>> Question Yes No
>>> Question Yes No
>>> Question Yes No
>>>
>>> Also I was asked to help with spreadsheet that has what appears to be a
>>> box (could be the print area) around the data.
>>> Outside of that box is sort of grayed out...
>>> I can drag the edge of the box with my mouse and it seems like it
>>> changes the print area...
>>>
>>> I have no idea how they created this area on the spearsheet
>>>
>>> Any help would be appreciated!
>>>
>>> Kelvin
>>>

>>
>>

>
>



Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



All times are GMT. The time now is 06:02 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Codigo da vinci | iKobo | Loans | Mortgage Calculator | Web directory



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114