ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting unwanted Cells (https://www.excelbanter.com/excel-discussion-misc-queries/31597-deleting-unwanted-cells.html)

tranetp

Deleting unwanted Cells
 

Is there anyway where you can delete unwanted cells that you do not want
in a work book.

An example is if you want say rows 1 to 20 and Columns A to E and you
only want those cells to appear in the work book. In other words I
don't want the rows from 21 to the end and columns F to the end to
appear.


--
tranetp
------------------------------------------------------------------------
tranetp's Profile: http://www.excelforum.com/member.php...o&userid=24473
View this thread: http://www.excelforum.com/showthread...hreadid=380727


abcd

You can hide (mask) columns or rows: selct them right-clic then select
"hide"

to un-hide them: select the columns before and after and in the menu
choose un-hide

tranetp


thanks, that is what I was looking for.


--
tranetp
------------------------------------------------------------------------
tranetp's Profile: http://www.excelforum.com/member.php...o&userid=24473
View this thread: http://www.excelforum.com/showthread...hreadid=380727


abcd

ok, great


All times are GMT +1. The time now is 10:46 AM.

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