'View a table with a lot of columns (50)

I was wondering if you know some tools to help to display a table with around 50 columns. Let's imagine we have 4 row and 50 columns:

if we use Excel and dezoom we can't see anything,

so I was thinking of an interactive tool which dynamically displays the first columns on the screen and returns to line to display the remaining columns (perhaps it would need 5 or more return to lines to display all columns).

Do you know if such a tool (or tips to achieve this) exist?

Thanks

excel data-visualization

Solution 1:^[1]

Try this code on your sheet (Just change the name of your workbook, in my case Book1)

Range("F3").Select
ActiveWindow.FreezePanes = True
ActiveWindow.NewWindow
Windows.CompareSideBySideWith "Book1:1"
Windows.SyncScrollingSideBySide = False
ActiveWindow.Zoom = 84
Windows("Book1.xlsm:2").Activate
Windows.SyncScrollingSideBySide = True

On a resolution of 1920x1080 pixels, you will get 50 columns on 2 windows synchronized.

Hope it helps

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	David GarcÃa Bodego

'View a table with a lot of columns (50)

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]