santa12345
Board Regular
- Joined
- Dec 2, 2020
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
Hello. I am copying a range of data from one tab. (1st tab)
There maybe some blank rows of data in the range. (1st tab)
I then copy and paste special that range of data as values only into another tab. (2nd tab)
When I sort the 2nd tab and then hit Shift Ctrl Down Arrow it grabs more rows that the displayed data.
There is no character / formula, etc.. in the blank rows even thou the shift ctrl down arrow grabs it.
Any ideas would be greatly appreciated.
Thank you.
There maybe some blank rows of data in the range. (1st tab)
I then copy and paste special that range of data as values only into another tab. (2nd tab)
When I sort the 2nd tab and then hit Shift Ctrl Down Arrow it grabs more rows that the displayed data.
There is no character / formula, etc.. in the blank rows even thou the shift ctrl down arrow grabs it.
Any ideas would be greatly appreciated.
Thank you.