I'm using Excel 2016 on windows 10.
When I copy a range of data I want to "Special" paste, it excludes the blank cells in the range and then the pasted data is misaligned (column wise).
I have searched for a solution, but all I can find is how to turn ON Skip blank cells.
Is there a way for me to turn it OFF? Pasting normally is fine, but I want to be able to special paste to disregard formatting, but keeping the blank cells.
When I copy a range of data I want to "Special" paste, it excludes the blank cells in the range and then the pasted data is misaligned (column wise).
I have searched for a solution, but all I can find is how to turn ON Skip blank cells.
Is there a way for me to turn it OFF? Pasting normally is fine, but I want to be able to special paste to disregard formatting, but keeping the blank cells.
