Home

Freeze Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-329190%22%20slang%3D%22en-US%22%3EFreeze%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329190%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%2051%20spreadsheets%20in%20one%20workbook.%26nbsp%3B%20The%20first%20spreadsheet%20serves%20as%20the%20master%20sheet.%26nbsp%3B%20Is%20there%20a%20way%20to%20freeze%20that%20sheet%20while%20scrolling%20through%20the%20other%2050%20spreadsheets%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-329190%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329468%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329468%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Eva%20Vogel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response%20and%20suggested%20solution%20to%20my%20question.%26nbsp%3B%20I%20do%20not%20understand%20the%20wordings%20on%20the%20screenshots%20because%20they%20are%20in%20German%2C%20but%20it%20appears%20to%20me%20that%20you%20are%20showing%20me%20how%20to%20freeze%20cells%20in%20a%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20is%20to%20freeze%20a%20particular%20spreadsheet%20among%20many%20spreadsheets%20in%20a%20workbook.%26nbsp%3B%20Attached%20is%20a%20screenshot%20of%20the%20workbook%20showing%20various%20spreadsheets.%26nbsp%3B%20I%20need%20the%20first%20spreadsheet%20named%20%22Church%22%20to%20stay%20in%20place%20as%20I%20scroll%20through%20the%20other%20spreadsheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20if%20there%20is%20a%20way%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20God%20bless%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhyDNA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329222%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329222%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F276363%22%20target%3D%22_blank%22%3E%40WhyDNA%3C%2FA%3E%20!%20You%20can%20do%20it%20with%20my%20tutorial%20here.%20I%20provided%206%20Screenshots%20for%20you%2C%20see%20them%26nbsp%3B%20attached.%3C%2FP%3E%3CP%3EAfter%20you%20did%20my%206%20steps%2C%20you%20will%20have%20a%20range%20of%20cells%20called%20%22entry%22%20witch%20is%20unprotected%2C%20first%20cell%20of%20that%20range%20is%20the%20real%20entry%20point%20for%20your%20dashboard.%20It%20has%20to%20do%20with%20cell%20formatting%2C%20then%20unlocking%20the%20named%20cells%20within%20that%20range%2C%20then%20protect%20all%20cells%20except%20this%20entry%20range.%20Hope%20that%20helps.%20If%20so%2C%20give%20a%20Like%20%3A)%26nbsp%3B%20Greets%2C%20Eva.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
WhyDNA
New Contributor

I have 51 spreadsheets in one workbook.  The first spreadsheet serves as the master sheet.  Is there a way to freeze that sheet while scrolling through the other 50 spreadsheets?

2 Replies

Hi @WhyDNA ! You can do it with my tutorial here. I provided 6 Screenshots for you, see them  attached.

After you did my 6 steps, you will have a range of cells called "entry" witch is unprotected, first cell of that range is the real entry point for your dashboard. It has to do with cell formatting, then unlocking the named cells within that range, then protect all cells except this entry range. Hope that helps. If so, give a Like :)  Greets, Eva.

 

Hi Eva Vogel,

 

Thank you for your response and suggested solution to my question.  I do not understand the wordings on the screenshots because they are in German, but it appears to me that you are showing me how to freeze cells in a spreadsheet.

 

What I need is to freeze a particular spreadsheet among many spreadsheets in a workbook.  Attached is a screenshot of the workbook showing various spreadsheets.  I need the first spreadsheet named "Church" to stay in place as I scroll through the other spreadsheets.

 

Please advise if there is a way to do this.

 

Thank you and God bless,

 

WhyDNA

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies