Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default viewing specific columns

I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default viewing specific columns

Maybe you can record a macro when you hide all the columns you don't want to
see.

And record a macro when you unhide all the columns.

Then you can run either whenever you need.

ezil wrote:

I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default viewing specific columns

On Jul 6, 11:50 am, ezil wrote:
I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?


Hide columns or create a Macro that hides columns and runs off a
toolbar button.
Dennis

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Method of viewing/naming columns or conversions for same Copacetic Excel Worksheet Functions 3 May 8th 10 11:07 PM
Viewing information after hiding columns / rows Annie Excel Discussion (Misc queries) 2 February 21st 07 03:36 PM
Preventing people from viewing specific worksheets k1ckn1ck Excel Programming 9 January 25th 06 02:33 PM
Preventing Viewing of certain columns by recipient markd Excel Discussion (Misc queries) 1 February 9th 05 07:08 PM
can you prevent viewing of specific columns in a worksheet Tamara Excel Worksheet Functions 1 January 19th 05 04:12 PM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"