How to Questions

[Ray Fox]

I need to copy the contents of a cell down the rest of the column (could be a couple of hundred cells)

Is there a faster way than holding the shift key, and cursoring down?

I tried ctrl 1, and page down, also end down.

 

Still searching.

 

Ray

[Ellen Browne]

Go to the topmost cell and and arrow up one more time, the whole column turns blue and you can copy

Sent from my iPhone

--
To post to this group, send email to tins...@googlegroups.com
To unsubscribe send email to tinspire+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com.au/group/tinspire?hl=en-GB?hl=en-GB
The tns documents shared by group members are archived at
https://sites.google.com/site/tinspiregroup/classroom-news/welcome-abouttime

[John Hanna]

You could create a formula for the cells:

            =seq(1,x,x,1,100)

 

Fills the first 100 cells with 1.

 

This formula goes in the grey cell in the second row of the screen.

 

But if the cell you want to copy contains a formula then you’ll have to do the copy/paste thing.

 

     John Hanna

     jeh...@optonline.net

     www.johnhanna.us

     T³ - Teachers Teaching with Technology

     "the future isn't what it used to be."

 

---

--

[alcoonslists]

Will the FILL command work for you?

Enter the item to be copied into the first cell.

Right-click, select Fill, and drag down.

Al

--
To post to this group, send email to tins...@googlegroups.com
To unsubscribe send email to tinspire+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com.au/group/tinspire?hl=en-GB?hl=en-GB
The tns documents shared by group members are archived at
https://sites.google.com/site/tinspiregroup/classroom-news/welcome-abouttime

Al

-------------------------

Albert Coons

al_c...@bbns.org

Buckingham Browne & Nichols School

Gerry's Landing Road

Cambridge, MA 02138

(617) 800-2264

AP Statistics Web Site:  www.bbn-school.org/us/math/ap_stats

[Ray Fox]

Thanks Al,

 

The fill works better than the copy > paste option.

It still requires cursoring down cell by cell, rather than a page at a time.

 

Ray

[Ray Fox]

John, I guess I may be stuck with copying the formula down.

Maybe there is a better mouse trap.

 

I have a list of years (random in column A) which can be generated randint(1940,2012,200) to get a list of 200 dates from 1940 to 2012.

 

What I'm trying to do is get a randsamp of five from that column for column B.

So far, I have in B1 =mean(RandSamp(year,5)), then copy down (or fill per Al) down.

 

Is there a way to generate this in column B from the diamond row?

Any other suggestions?

[Sean Bird]

You are right about not being about to use CTRL 1 or CTRL 3 to page down or get to the end while using Fill. 

A shortcut for fill is to press CTRL CLICK (like grab). When you grab the cell, it is like grabbing the corner of the cell with the software.

- Sean Bird

[Dennis Donovan]

From the diamond row you can do this with a sequence:

=seq(mean(randSamp(year,5,0)),k,1,n)

In this "k" is a dummy variable, sequence needs to increment a variable, but the variable does not have to be in the formula, "n" is the number of means you want to generate.

Note: I added a third parameter to the randSamp command, 0 means to sample with replacement, change it to 1 if you want to sample without replacement.  It defaults to zero, I included it in case you didn't know that was an option for the randSamp command.

---

From: Ray Fox <kenr...@gmail.com>
To: tins...@googlegroups.com
Cc: Sean Bird <covena...@gmail.com>
Sent: Thursday, February 9, 2012 6:48 PM
Subject: Re: [tinspire] How to Questions

[John Hanna]

That’s what I was going to suggest ;)

 

     John Hanna

     jeh...@optonline.net

     www.johnhanna.us

     T³ - Teachers Teaching with Technology

     "the future isn't what it used to be."

 

[Ray Fox]

That's the perfect solution!!

 

Thanks so much.