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).
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 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!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

Видео Show Only a Few Rows or Columns канала Doug H