top of page
  • Writer's pictureDp

Show only some portion of Excel sheet

Updated: May 2, 2019

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.


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


Recent Posts

See All


bottom of page