Forum Discussion

Rassy's avatar
Rassy
Copper Contributor
Dec 14, 2019
Solved

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.

2 Replies

    • Rassy's avatar
      Rassy
      Copper Contributor

      SergeiBaklan 

      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.