I have an Excel files that has blanks that I need to remove. I can use Select > Special and highlight all of my banks to delete them and shift data without issue. My problem is the data in the cells are associated in pairs of twos so if I have a blank and have it highlighted I need to expand my selection on to the left to make sure I get the cell the describes it too. When I use the special feature to highlight all the random blank cell if is shift + arrow left it only expands one of the selected cells, not all of them.
Any suggestions or a different way I could go around this? You can see in this sample if I deleted all the blank cells it would shift the 100, 200, 300 descriptions around so I need to expand those selections one to the left to delete the description as well. If I CTRL+ ARROW LEFT the active selected cell in the top right is the only one that expands the selection.
EXCapture.PNG
Thanks,
Mike
Bookmarks