Freezing a worksheet that contains both summary and detail information

%3CLINGO-SUB%20id%3D%22lingo-sub-1980483%22%20slang%3D%22en-US%22%3EFreezing%20a%20worksheet%20that%20contains%20both%20summary%20and%20detail%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1980483%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20do%20the%20following%20but%20having%20difficulties%20trying%20to%20see%20if%20excel%20will%20do%20this%20or%20not%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EIn%20the%20same%20worksheet%3C%2FSTRONG%3E%3C%2FU%3E%20-%20I%20have%20summary%20information%20in%20columns%20A-J%20that%20I%20want%20to%20keep%20static%20(say%20rows%201-25)%20and%20be%20able%20to%20scroll%20the%20source%20data%20that%20is%20being%20summarized%2C%20which%20is%20in%20columns%20K-Z%20(say%20rows%201-500)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20freeze%20%2F%20split%20the%20information%20so%20that%20I%20don't%20have%20to%20create%20multiple%20windows%20or%20split%20the%20information%20up%20among%20multiple%20worksheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20interested%20in%20work-arounds.%20I%20know%20a%20dozen%20workarounds%20to%20the%20problem%20none%20of%20which%20directly%20answers%20my%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20if%20it%20can%20be%20done%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea)%20in%20a%20single%20worksheet%3B%3C%2FP%3E%3CP%3Eb)%20using%20a%20single%20instance%20of%20excel%3B%3C%2FP%3E%3CP%3Ec)%20without%20having%20to%20create%20multiple%20%22new%20window%22%20instances%3C%2FP%3E%3CP%3Ed)%20without%20having%20to%20rearrange%20my%20information%20putting%20the%20summary%20information%20over%20top%20the%20detail%20information%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1980483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1980585%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20a%20worksheet%20that%20contains%20both%20summary%20and%20detail%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1980585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F899160%22%20target%3D%22_blank%22%3E%40knomaze%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20under%20the%20Window%20menu%2C%20the%20methods%20under%20the%20words%20%22Split%22%20and%20%22Freeze%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20do%20different%20things%2C%20but%20seem%20to%20be%20what%20you're%20looking%20for.%20HOWEVER%2C%20%5Blet%20me%20continue%20this%20%22however%22%20below....%5D%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1607709444501.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239891i7E5A1474F1D082E7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1607709444501.png%22%20alt%3D%22mathetes_0-1607709444501.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever.........If%20you're%20talking%20of%20freezing%20a%20summary%20of%2025%20rows%20at%20the%20top%20of%20the%20screen%2C%20then%20you're%20almost%20filling%20the%20screen%20with%20that%20to%20begin%20with.%20Which%20starts%20to%20suggest%20you'd%20be%20better%20off%20with%20a%20separate%20%22Dashboard%22%20or%20%22Summary%22%20screen%20to%20begin%20with.%20Why%20are%20you%20so%20resistant%20to%20that%2C%20if%20I%20might%20ask%3F%20Usually%20the%20freeze%20and%20split%20options%20are%20employed%20to%20keep%20headers%20and%20maybe%20a%20few%20other%20reference%20cells%20visible%20while%20scrolling%20down%20a%20large%20sheet%2C%20but%20rarely%20is%20it%20productive%20to%20freeze%2025%20rows.....%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm looking to do the following but having difficulties trying to see if excel will do this or not

 

In the same worksheet - I have summary information in columns A-J that I want to keep static (say rows 1-25) and be able to scroll the source data that is being summarized, which is in columns K-Z (say rows 1-500)

 

Is there anyway to freeze / split the information so that I don't have to create multiple windows or split the information up among multiple worksheets.

 

I'm not interested in work-arounds. I know a dozen workarounds to the problem none of which directly answers my question.

 

I want to know if it can be done

 

a) in a single worksheet;

b) using a single instance of excel;

c) without having to create multiple "new window" instances

d) without having to rearrange my information putting the summary information over top the detail information

 

Thanks

1 Reply

@knomaze 

Have you tried under the Window menu, the methods under the words "Split" and "Freeze"?

 

They do different things, but seem to be what you're looking for. HOWEVER, [let me continue this "however" below....]

mathetes_0-1607709444501.png

 

However.........If you're talking of freezing a summary of 25 rows at the top of the screen, then you're almost filling the screen with that to begin with. Which starts to suggest you'd be better off with a separate "Dashboard" or "Summary" screen to begin with. Why are you so resistant to that, if I might ask? Usually the freeze and split options are employed to keep headers and maybe a few other reference cells visible while scrolling down a large sheet, but rarely is it productive to freeze 25 rows.....