Dear,

I have a concern about pasting values with the “copy” formula. When we use the shortcut Ctrl+arrow key to navigate, it takes us to the last cell, skipping any empty cells in between. However, when we paste a blank value using the copy formula, this shortcut doesn’t work the same way and considers the last cell where we pasted the value. Why is that? Can you please help me understand this?

Thanks,

Kuldeep Kumar

​Dear,I have a concern about pasting values with the “copy” formula. When we use the shortcut Ctrl+arrow key to navigate, it takes us to the last cell, skipping any empty cells in between. However, when we paste a blank value using the copy formula, this shortcut doesn’t work the same way and considers the last cell where we pasted the value. Why is that? Can you please help me understand this? Thanks,Kuldeep Kumar  Read More

​