• Dp

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.




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

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon