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.
Paste in Visible Columns
Hi,
I am looking for feature that's available in excel. I have to copy-paste from one sheet to another. I am copying from colummns 3 consecutvie columns - A, B, C. Pasting in A1,C1,D1 (where B1 is hidden). When I paste it, column A gets pasted in A1, B in B1 and C in C1. Where as I would like it to be pasted in A1,C1,D1. Is this possible?
Comments
-
Hi Meenakshi-- I wasn't able to replicate this on my end, are you using the keyboard shortcuts for copy and paste? Another option, since it's easy to re-arrange columns in Smartsheet, would be to move column B out of the way temporarily, then move it back!
-
Hi Kennedy, thanks for the response. Yes, I'm using keyboard shortcuts. I have also tried right click->paste and it's the same. The challenge in moving B out of the way is that, we have too many "B"s - say 6 or 7. It's more work for us to unhide all the columns and move them out of the way. And move it back once the copy-paste is done.
May be this feature is not available on Smartsheet?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives