D delta Member Feb 12, 2017 #1 i restrict work area like i attach sample file how it is made pl describe how it is possible. Attachments main.xls 42 KB · Views: 4
N NARAYANK991 Excel Ninja Feb 12, 2017 #2 Hi , 1. Select column H. 2. Keeping the SHIFT key pressed , press the END key and then the right arrow key ; this will select all of the columns H through IV. 3. Right-click and select Hide. 4. Select row 10. 5. Keeping the SHIFT key pressed , press the END key and then the down arrow key ; this will select all of the rows 11 through 65536. 6. Right-click and select Hide. Narayan
Hi , 1. Select column H. 2. Keeping the SHIFT key pressed , press the END key and then the right arrow key ; this will select all of the columns H through IV. 3. Right-click and select Hide. 4. Select row 10. 5. Keeping the SHIFT key pressed , press the END key and then the down arrow key ; this will select all of the rows 11 through 65536. 6. Right-click and select Hide. Narayan
