Show only some portion of Excel sheet

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