ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I hide and unhide the same columns without reselecting (https://www.excelbanter.com/excel-worksheet-functions/80454-how-do-i-hide-unhide-same-columns-without-reselecting.html)

CJE

How do I hide and unhide the same columns without reselecting
 
How do I hide and unhide the same columns without reselecting the same colums
each time?

Dinesh

How do I hide and unhide the same columns without reselecting
 
Hi,

Select Data and try Group/Ungroup function.

"CJE" wrote:

How do I hide and unhide the same columns without reselecting the same colums
each time?


Gord Dibben

How do I hide and unhide the same columns without reselecting
 
See help on Custom Views.

You can set up various views of a worksheet and switch from one to another.

i.e. choose the columns to hide then hide them.

ViewCustom ViewsAdd........give this view a name and OK.


Gord Dibben MS Excel MVP


On Wed, 29 Mar 2006 18:27:01 -0800, CJE wrote:

How do I hide and unhide the same columns without reselecting the same colums
each time?




All times are GMT +1. The time now is 10:31 PM.

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