Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Please help - Copy & Pasting from Excel to Smartsheets not working
I am new user on smartsheets at my new job, I am unable to copy & paste from Excel to Smartsheets multiple cells. Copy works in Excel but Paste is grayed out in Smartsheets. This seems to a major problem for years as I read all the community discussions about it back several years. I am on Mac, using google chrome ? I am also wondering if it is only an issue for Mac users? The other users in my office are on PC. Please help anyone.
Answers
-
-
-
Shorcut hotkeys do not work as well.
-
I've not had a problem with it. Can you share some screenshots? What level permission do you have in the sheet? Have you tried pasting to another excel doc to ensure the data is definitely getting copied?
-
My workaround for this issue (I experience it as well) is to import the Excel Sheet (it's quick & easy) then copy paste from the the new sheet. Would that work?
I can copy-paste one cell at a time (from a Mac) but not multiple cells.
-
I am not able to share a screenshot, sorry. It is for work. I am amble to copy 1 cell from Excel & paste it to another cell in smartsheet. Doing only 1 cell doesn't work every time but most of the time. I am able to copy multiple cells from Excel but when I go to paste the multiple cells in smartsheet "paste" is greyed out.
-
Have you tried command-C in Excel then command-V in Smartsheet? When I try to right click and copy in Excel then paste into Smartsheet, that doesn't work, but if I use command-C and command-V I'm able to paste several cells from Excel to Smartsheet.
I've found importing the Excel sheet into Smartsheet to be the best option though. -
@amccoy I've seen comments about that solution which I have not tried yet. The other major problem is the smartsheet workspace is preset with customized rows. The Excel sheet only has a few rows. I was told if I import I will mess up the customization.
-
I'm not referring to importing the Excel into the Smartsheet directly. I'm referring to creating a new sheet (grid) and then importing the Excel sheet for the sole purpose of using it to copy-paste within Smartsheet. Essentially, replicating your Excel Sheet in Smartsheet, then copy-paste within Smartsheet is much easier.
Also, I've tested copy-paste using the hotkeys on my Mac and it seems to work as long as you use them in both Excel and Smartsheet. -
@amccoy ahhhh I see what your saying. I understand. I will try that. Thank you for the suggestion.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 451 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello, I am a new user to Smartsheet and have a question on Saved Automation Workflows. I am trying to edit the email by adding a due date in the subject line of the email once it reaches a trigger da…
- I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 day…
- In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at…
