Select Blanks:
Welcome to the third post of this series – Select blanks. Click here to read to navigate to go to special and to select comments or Click here to read to select constants and formulas.
Why Select Blanks?
I often use this option in Excel and I sincerely thank Microsoft for having this option in Excel. I must admit I hate to see blank cells in my data. It is quite common that we see blank cells in a large set of data, especially for people who download data from web and people who get a pivot table paste as values as his input for further processing. One might want to get rid of blank cells or put a constant (Sometimes, I make blank cells as zero) or fill the blank cells with a common formula etc.
Bear in mind to select a range of cells while selecting blanks or else by default excel selects all blanks in the used region. I mean by used region, from A1 to the last used cell.
Navigate to Go To Special - Blanks
Click here to learn navigation.
Keyboard Shortcut: Press F5, then Alt+S+K.
