ST Alpha - "ST knows Excel" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 151

ST knows Excel

Posted by Beaker (aka anniebecca) Jun 24 '13, 05:20

So I have a formula I want to paste: =T26/9 . But every time I copy and paste it the T changes to a U (jumps the cell).

Is there a way to paste to multiple cells that will keep the equation the exact way I created it?

There must be right?

Responses:

$T26 (or $T$26 if you want to anchor both dimensions) -- nm - znufrii Jun 24, 05:21 2
- I wish that lookup formulas would automatically insert the range this way - zork Jun 24, 05:34 1
  - Right after you type/click the cell number, hit F4. It'll toggle through the dimmensions for you. -- nm - JaxSean Jun 24, 05:57
=$T$26/9 -- nm - Don Homer Jun 24, 05:21 2
- awesome, thanks alot -- nm - Beaker Jun 24, 05:24 1
  - no prob -- nm - Don Homer Jun 24, 05:24

Post a message top

ST knows Excel

Replies are disabled on threads older than 7 days.