If you work with Microsoft Excel everyday, ensure, block or highlight rows and columns is your daily job. To block them usually, we'll click header column or row to block all of them. I want to share another way to block entire rows or columns.

Ok, I consider your Microsoft Excel has opened. I have 3 tricks to block your cells.
1. To block entire row, such as if your cursor at B1 cell and you want to block entire row 1, press Shift + Space keys.
2. To block entire column, sucs as if your cursor at B1 cell and you want to block entire column B, press Ctrl + Space keys.
3. To blok entire cell in your sheet, press Ctrl + Shift + Space keys.
I don't try it yet with another spreadsheet applications but I think at least 1 from 3 tricks above can apply on them too.
Try it .....

0 comments