Initial empty cells ignored when pasting in single column from Excel


#1

Pasting in a single column from Excel that starts with multiple blank cells causes first rows to be discarded. In other words, the first nonblank row is moved up and used as the initial value.

Workaround:
Entering a placeholder value for the first row so blank rows below it are pasted in properly.


#2

The last rows are discarded too. Not a big deal with the workaround but sometimes when you forget to put placeholder in first row and only realize it after pasting a few columns… Disasters can happen… :sweat_smile: