Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 05:45:16 +0000
Copy paste in spreadsheets
View Count: 1153
| [2018-02-26 12:38:20] |
| User976521 - Posts: 4 |
|
Hi, I have version 1705. How do I copy paste a row of formulas down ? For instance if I copy the cells A3, B3, C3, D3,E3, by selecting them and do a right click and then click Copy formula., and afterwards I select all the cells from columns A,B,C,D,E( starting row 4) till row 50 for instance, I click paste. What I have as a result is that the formulas are only copied to row 4 ( A4,B4,C4,D4,R4) although I selected all the cells til row 50. What I would like is to have them till row 50. How can I make it work ? Thank you |
| [2018-02-26 18:35:32] |
| |
|
Refer to: Working with Spreadsheets: Filling Cells with Value or Formula Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2018-03-05 23:11:50] |
| bradh - Posts: 854 |
|
When I put a formula or value in row 3 of any column from K on up to, but including the study values, it automatically copies down as many rows as the spreadsheet study settings dictate. Unlike Excel, I have never had to copy down. Am I missing something?
Date Time Of Last Edit: 2018-03-06 04:12:24
|
| [2018-03-06 16:14:27] |
| User976521 - Posts: 4 |
|
Hi Brath, It is indeed automatic unless like me you use additional worksheets. The 60 automatic columns aren't enough for what I need. Regards, |
To post a message in this thread, you need to log in with your Sierra Chart account: