Excel productivity Tweaks #2:
Restrict the work area few columns and rows:
-
Select the first column you don’t want to see ( Ex :L Column)
-
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
-
Now select the first row you don’t want to see (Ex:18 th row)
-
Now press ctrl+shift+down arrow , now right click on the header and then hide.
-
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.
