Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

varying a cll value from min to max

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin K - 21 Aug 2006 12:59 GMT
Hi,

I am writing from Germany so sorry for my bad English!

I have got following problem: I want to change a value of a cell fro
the minimum to the maximum in defined steps. For example: I know, tha
the value varies form 5 to 10, I want to say ecel "change it in step
of 1" and after that I can vary the value from 5 to 6 etc up to 10 b
using the mouse. My aim is that I want to see what happens if
parameter changes from a to b.... I am thankful for answers tha
include an instruction like "first click there then do this etc
because I am new in excel. Thank you so much!

Marti
Marcelo - 21 Aug 2006 13:25 GMT
Hi Martin,

one way is open the form bar, you will see a butom with two arrows one to up
and one to down, click on it, drawing on your sheet.

right click - Control Setup - setup as you need.

hth
Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> Hi,
>
[quoted text clipped - 10 lines]
>
> Martin
Martin K - 21 Aug 2006 16:09 GMT
Hi Marcelo,

thanks a lot! It works. Vielen Dank aus Deutschland. Muito obrigad
pela sua ajuda!

Martin

Marcelo Wrote:
> Hi Martin,
>
[quoted text clipped - 37 lines]
> > View this thread
> http://www.excelforum.com/showthread.php?threadid=573722
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.