Restrict Work Area

[kskhan1105]

Hi,

So basically I want only a certain number of columns and rows to be shown in the workbook. For example, I want no columns beyond Z. I would select column AA and ctrl+shift+--> and hide. NO, I am looking for a more sophisticated solution. I tried "Developer" tab and scroll lock too but that creates other "Document Inspector" issues. I last time did it very easily that my workbook would not show rows beyond a certain row without doing anything super crazy. Just can't find out how in version "365"

Any help is appreciated.

Thank you.
Khurram Khan

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.