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
Highlighted
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
Highlighted

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.

 

Highlighted

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
Loading spreadsheet with notes in cells into Teams
DaleA123 in Microsoft Teams on
0 Replies
Power Query freezes in Excel
ire123 in Excel on
0 Replies
Spreadsheets with mobile access
darciwilliams in Microsoft Teams on
5 Replies
excell spreadsheet
lonniemc in Excel on
0 Replies
Link in Teams spreadsheet wont open in Teams
Ben Curran in Microsoft Teams on
0 Replies