Results 1 to 21 of 21

In a table, how can I select to display only certain columns and not others.

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2021
    Location
    GENEVA
    MS-Off Ver
    EXCEL FOR MAC MICROSOFT 365
    Posts
    83

    In a table, how can I select to display only certain columns and not others.

    I have a table with around 60 columns. The number of columns will continue to grow. When I input data, I only need to work on a relatively small number of columns (say 6 columns), which could be located anywhere amongst the 60+ columns. For example, I might need to work on columns A,B,C and on columns BA, BB, BC at the same time.

    This is becoming difficult to manage as I can't display the whole table on a single monitor, and I keep having to scroll huge distances to the left or right.

    I have illustrated what I would like to achieve in the attached simplified spreadsheet.

    I can achieve the required outcome by MANUALLY hiding or shrinking non-needed columns, but this is very tedious and time consuming - at least doing it manually. I would like to find a simpler way, I am sure someone here can help?

    Below is a simple version of the spreadsheet.
    Screenshot 2022-03-09 at 08.53.17.png

    Below is the desired outcome after filtering out columns B to E
    Screenshot 2022-03-09 at 08.54.15.png
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-28-2020, 10:30 AM
  2. Dropdown to select table then rows display infor from selected
    By Hooty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2018, 02:37 PM
  3. Replies: 1
    Last Post: 08-29-2014, 10:38 AM
  4. select numbers in columns and display them in other lines
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-31-2013, 04:58 PM
  5. Need to select particular value from table and display message
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2013, 09:02 PM
  6. [SOLVED] Select & Display editable table via dropdown box
    By -AJ- in forum Excel General
    Replies: 2
    Last Post: 06-16-2013, 02:30 PM
  7. Replies: 0
    Last Post: 09-10-2012, 09:19 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1