Excel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank cells.
How:?
Step 1:
Select the Row from Which you want to hide
Step 2:
Press Ctrl+Shift+Down Arrow to select all the rows till 2 ^20
Step 3:
Right Click and Select Hide
Step 4:
Select the Column from which you want to hide
Step 5:
Press Ctrl+Shift+Right Arrow to Select all the columns till 2 ^14
.
Step 6:
Right click and Select Hide
You are Done now.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com
Comments