Archived 2015 Posts
Archived 2015 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Copy column and cell locking
How to lock a cell in the sheet?
Comments
-
Thanks for the questions! There isn’t a way to copy a column from one sheet to another unless you are copying or moving rows from one sheet to another. If the destination sheet does not contain a column that exists in the source sheet, it will be copied and added to the far right in the destination sheet.
While you cannot lock a single cell, you can lock a row row or column. Here is some information on how this functionality works: http://help.smartsheet.com/customer/portal/articles/522077-locking-unlocking-columns-and-rows
-
Hi All,
I export a sheet to excel, and i import when i create new sheet, so no need to enter the column name in each time when create new sheet,
Thanks Mr. Travis for your comment.
Thanks.
-
You could also make a copy of the sheet (rather than exporting and importing) by right clicking in the title tab (while in the sheet) and selecting Save as New.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a r…