Show Only a Few Rows or Columns

Want to learn how to hide unused cells in all the columns or the rows? Maybe you want to limit the information to one page without scrolling. Removing empty cells whether it's the rows or the columns doesn't reduce the the size of the file, but it gives the impression of a cleaner worksheet. It's more than just making the grid lines invisible, it restricts scrolling by giving the impression of locking the scrolling capability or making it look like you locked the screen. To learn how to show only a few rows or columns in a worksheet check out this video.

Two examples one using the Hide feature (2:19) and the other limiting the scrolling area (4:37).

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[semiangelik]

Thank you so much! I was getting frustrated with other tutorials.

[superpiggy]

Thank you SOOO much for the clear explanations!!!

[snehap]

After 2 minutes
Exactly what I am searching
Thank you

[shubhrajit]

Thanks for the video! For anyone who is in a hurry, just watch from 2:20 to 3:00.

[wizzarin]

You just solve one of my headaches. thankyou

[ronaldbirch]

Thanks that was quick, easy to follow and helpful

[suraksha]

Just amazing how you explain it. Thanks a lot for sharing.

[wilpoward]

Thanks for the video, was trying to figure this out for some time.

[Yeeeeeehaw]

Great and clear explanation man !
Thanks

[rajsuthar]

Quite informative. This video could've been 2 minutes shorter.

[aryansingh]

How do we unhide the rows and columns?

[monadm]

Hello Doug, I have a table with 6 culums and (21420) rows, couldnt past it into Excel? do you know any way of doing that? thanks

[AswertyKhone]

Shif+ctrl and (Sorry not well English)

[srennielsen]

This is so much easier in Google Sheets. Holy shit why did Excel make this so difficult. Any time I press delete, it ltierally re-inserts the rows or columns??? Oh well, hiding them works. Still unnecessarily aids to work with, though.

[ravi]

Thank you so much. Guys Plz subscribe and click on bell icon. Very useful channel for beginners and professionals. I hope in future u make a video on length of stay and bed occupancy rate formula on ms excel which is use in hospitals plz. Thanks again. God bless u. Keep it up. 👍

[BlaqcRain]

Start this video at 2:19 to get to the tutorial .. beecause my god

[kenshuman]

Too much talking. Just show how to hide the columns