PPCGeeks

PPCGeeks (http://forum.ppcgeeks.com/index.php)
-   HTC Touch Pro (http://forum.ppcgeeks.com/forumdisplay.php?f=63)
-   -   Excel Question real quick (http://forum.ppcgeeks.com/showthread.php?t=61813)

Skelator03 03-20-2009 02:07 PM

Excel Question real quick
 
Ok i am doing my office pool and i have it all done on excel well in excel when you have a formula in you can drag it down and it will not copy but change the letter / number of the grid by one in the formula so it will add all the points for me based upon who picked what team now here is the question how do i duplicate this effect on my phone cuz i have been keeping track of my score but cant figure out the drag function thanks a lot

Quirk 03-20-2009 02:13 PM

Re: Excel Question real quick
 
try this:

copy the cell, then select the range you want, and then paste. it *should* have the same effect as dragging the cell

gimme5 03-20-2009 02:16 PM

Re: Excel Question real quick
 
Just tried it, create your formula, copy it, highlight the cells you want to apply the formula to and then paste.

Edit: Beat me to it, Quirk :)

studentjunk 03-20-2009 02:17 PM

Re: Excel Question real quick
 
copy and paste
i.e., copy the formula, select the fields that you want to copy the formula to, and then paste into all those fields. Works the same way on excel - no need to drag

Skelator03 03-20-2009 02:17 PM

Re: Excel Question real quick
 
YOUR awesome thanks a lot someone can close this

CozBoogie 03-20-2009 02:30 PM

Re: Excel Question real quick
 
Quote:

Originally Posted by Skelator03 (Post 785760)
YOUR awesome thanks a lot someone can close this

Someone certainly can.

late,
Coz


All times are GMT -4. The time now is 07:00 AM.

Powered by vBulletin® ©2000 - 2025, Jelsoft Enterprises Ltd.
©2012 - PPCGeeks.com


Content Relevant URLs by vBSEO 3.6.0