«

»

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. 

 

About the author

Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">