Feb 04

Restrict the work area few columns and rows

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

    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. 

 

Leave a Reply

Your email address will not be published.