SOLVED

Excel - Select specific columns to use

Copper Contributor

I have built an Excel sheet with roughly 30 columns that pull data from the web.  I want to be able to pick  a certain number of these columns randomly and easily so I can see the selected columns on one screen.  What is the best way to create this?  i.e. Today I might want to look at 4 columns of the 30 but I don't want all 30 current columns on my view screen because it's too difficult to visually see.  A week later I might want to view 6 different columns from the 30 columns.  Do I need to start working with VB or is there a better way to do this.

2 Replies
best response confirmed by Rassy (Copper Contributor)
Solution

@Rassy 

Why doesn't Hide columns work with you?

@Sergei Baklan 

That is a good question and I can hide columns.  I was just wondering if there was another way to pull this data to possibly a new sheet or new view once I selected the columns I was looking for.  You may be right that hiding the columns is the simplest way.

1 best response

Accepted Solutions
best response confirmed by Rassy (Copper Contributor)
Solution

@Rassy 

Why doesn't Hide columns work with you?

View solution in original post