Problem using shortcut keys
Hello, I’m using the Excel shortcut keys Ctrl+Shift+Down to select all of the consecutive cells with data down a column starting with the cell that is originally selected. This could be anywhere from 1 to 100 cells. The data in these cells is generated from a formula. Z2 is =TRIM(X2), Z3 is =TRIM(X3), Z4 is =TRIM(X4) and so on. If I have data in say Z2-Z6 I want the Excel shortcut to select those cells. The problem is, cells Z7 and downward still have the formula (but no data) and I believe for this reason the XL shortcut is selecting those cells also which I don’t want. Is there with a way to work around this? Thanks
|