Home view

%3CLINGO-SUB%20id%3D%22lingo-sub-2061453%22%20slang%3D%22en-US%22%3EHome%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061453%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20have%20the%20%22HOME%22view%20always%20at%20the%20top%20of%20my%20worksheets%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2061453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2061473%22%20slang%3D%22en-US%22%3ERe%3A%20Home%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929304%22%20target%3D%22_blank%22%3E%40Thomas_Banfield%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2061567%22%20slang%3D%22en-US%22%3ERe%3A%20Home%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061567%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929304%22%20target%3D%22_blank%22%3E%40Thomas_Banfield%3C%2FA%3E%26nbsp%3BDo%20you%20mean%20that%20the%20active%20cell%20in%20every%20sheet%20should%20be%20A1%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20select%20the%20first%20tab%20%22Restaurants%22.%20Press%20Shift%20(hold)%20and%20the%20last%20tab%20%22Monthly%20Charges%20II%22.%20And%20then%20select%20A1%20in%20the%20sheet%20that%20is%20displayed.%20Now%20press%20and%20of%20the%20other%20sheet%20tabs.%20All%20sheets%20are%20now%20%22positioned%20in%22%20A1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I would like to have the "HOME"view always at the top of my worksheets

2 Replies

@Thomas_Banfield Do you mean that the active cell in every sheet should be A1?

 

If so, select the first tab "Restaurants". Press Shift (hold) and the last tab "Monthly Charges II". And then select A1 in the sheet that is displayed. Now press any of the other sheet tabs. All sheets are now "positioned in" A1.