Excel large sheet: Want to bring right side coloumns visible when needed


New Member
Dear Friends
I am new to this forum and need a solution to my problem:

I have a large sheet and have about 50 headers on coloumn on right side. I need not to scroll to right side and need to bring each coloumn in front of me with one click.
At the same time I need some fixed cells always in front of me while bringing any coloum header visible to me.

But not with freeze pans !

Actually I have started my construction business and need to work on all 50 headers and need to show at top some 3 cells visible to me always, even while I have brought for located right side header

I made "named ranges" to each column and can bring any column I need by clicking "name range" but then I cannot display the very first few top cells "Always". When I call any column with named range, the header come in front but cannot see my left most formulated cells always?

Could you help please?


Well-known Member
Your premise would require either Freeze Panes or Split just for starters.... or you have to write VBA for each and every case you want to display where you would Hide the columns you do not want to see.


New Member
Dear Friends

I have done all what I wanted by reading several Excel forum, if anyone needs my programming, I can send to his/her mail.
However, I need a small help from you:
I need to put a macro button to Window's built function "Alt+Enter" or , in one Excel cell, I can do "Alt+Enter" and then should be to copy this multi-line Format in all Cells of that particular column all the way down by selecting through "Control+****+Down Arrow"?
Is it possible?
My intention is:
To put data in a single cell, do it multi-line but the cell must not expand to several Rows. Alt+Enter is great to do this but I have 100s of cell propagating downwards and I need to put formatting in ALL cells like the one I already did: Alt+Enter , in one go?

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...