Forum Discussion
Excel - Select specific columns to use
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.
Why doesn't Hide columns work with you?
2 Replies
- SergeiBaklanDiamond Contributor
Why doesn't Hide columns work with you?
- RassyCopper Contributor
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.