PPCGeeks Forums HTC Arrive HTC HD2 HTC Thunderbolt HTC Touch Pro 2 HTC Evo 4G HTC Evo 3D Samsung Galaxy S II Motorola Droid X Apple iPhone Blackberry
Go Back   PPCGeeks > Windows Mobile > WM HTC Devices > HTC Touch Pro

Notices



Closed Thread
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-20-2009, 02:07 PM
Skelator03's Avatar
Halfway to VIP Status
Offline
Pocket PC: Touch Pro 2
Carrier: Sprint
Location: Houston
 
Join Date: Dec 2008
Posts: 606
Reputation: 295
Skelator03 is becoming a PPCGeeks regularSkelator03 is becoming a PPCGeeks regularSkelator03 is becoming a PPCGeeks regular
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
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
__________________
  #2 (permalink)  
Old 03-20-2009, 02:13 PM
Quirk's Avatar
PPCGeeks Regular
Offline
Pocket PC: TouchPRO2
Carrier: Sprint
 
Join Date: Nov 2008
Posts: 107
Reputation: 80
Quirk is becoming a great contributor
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Send a message via AIM to Quirk
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
__________________
Motorola i710 -> Motorola i850 -> HTC 6700 -> HTC 6800 -> HTC 6850 (broken keyboard) -> HTC 6850
This post has been thanked 1 times.
  #3 (permalink)  
Old 03-20-2009, 02:16 PM
gimme5's Avatar
Regular 'Geeker
Offline
Pocket PC: HTC EVO 3D
Carrier: Sprint
Location: Kissimmee/Poinciana, FL
 
Join Date: Aug 2007
Posts: 492
Reputation: 455
gimme5 is becoming a PPCGeeks regulargimme5 is becoming a PPCGeeks regulargimme5 is becoming a PPCGeeks regulargimme5 is becoming a PPCGeeks regulargimme5 is becoming a PPCGeeks regular
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Send a message via MSN to gimme5
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
__________________

MobileSpeedtest.com (yes, that's my site)
  #4 (permalink)  
Old 03-20-2009, 02:17 PM
studentjunk's Avatar
PPCGeeks Regular
Offline
Pocket PC: touch pro
Carrier: sprint
 
Join Date: Sep 2007
Posts: 204
Reputation: 185
studentjunk is keeping up the good workstudentjunk is keeping up the good work
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
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
  #5 (permalink)  
Old 03-20-2009, 02:17 PM
Skelator03's Avatar
Halfway to VIP Status
Offline
Pocket PC: Touch Pro 2
Carrier: Sprint
Threadstarter
Location: Houston
 
Join Date: Dec 2008
Posts: 606
Reputation: 295
Skelator03 is becoming a PPCGeeks regularSkelator03 is becoming a PPCGeeks regularSkelator03 is becoming a PPCGeeks regular
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Re: Excel Question real quick

YOUR awesome thanks a lot someone can close this
  #6 (permalink)  
Old 03-20-2009, 02:30 PM
CozBoogie's Avatar
Coz-erator
Offline
Pocket PC: Sprint Galaxy Note 2 & other misc digital devices
Carrier: Sprint
Location: Pacific Northwest
 
Join Date: Oct 2006
Posts: 13,694
Reputation: 15639
CozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation levelCozBoogie can't get a higher reputation level
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Send a message via MSN to CozBoogie Send a message via Yahoo to CozBoogie
Re: Excel Question real quick

Quote:
Originally Posted by Skelator03 View Post
YOUR awesome thanks a lot someone can close this
Someone certainly can.

late,
Coz
__________________
"I don't want to spend my life explaining myself. Either you get it or you don't." Frank Zappa
Closed Thread

  PPCGeeks > Windows Mobile > WM HTC Devices > HTC Touch Pro

Thread Tools
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

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


All times are GMT -4. The time now is 12:39 PM.


Powered by vBulletin® ©2000 - 2020, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.6.0
©2012 - PPCGeeks.com