ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Clear/delete all cells outside of a range (https://www.excelbanter.com/excel-discussion-misc-queries/453994-clear-delete-all-cells-outside-range.html)

GARYWC

Clear/delete all cells outside of a range
 
Cells in range a1:m137 contain data.

But, when I use 'Go To Special' and click 'Last Cell', the cursor goes to a cell outside of range a1:m137.

How do I clear/delete all cells outside of range a1:m137?


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com