Copying from Excel that has hidden columns
I'm facing an issue when copying from an Excel document with hidden columns to a sheet that has the exact same columns, but none are hidden. When I use Command C in Excel and Command V in the sheet, it only pastes the Excel's visible columns.
Users have to transfer specific rows from excel documents into an existing sheet without importing.
Any suggestions on how to paste all columns, including the hidden ones?