Excel productivity Tweaks #2:

 

Restrict the work area few columns and rows:

1. Select the first column you don’t want to see  ( Ex :L Column)

2. Now  press ctrl+shift+right arrow , now right click on the header and then press hide option.

   

   Restrict Work Areas-Excel productivity Tips by snatchexcel.com

3. Now select the first row you don’t want to see (Ex:18 th row)

4. Now  press ctrl+shift+down arrow , now right click on the header and then hide.

5. That’s it 🙂  Now your worksheet looks really cool.     

 

Alternatively you can watch the YouTube video by clicking the image below

 

Please leave your comments below if this trick is useful.