Home

Working in multiple spreadsheets - highlighting (Excel 2013)

%3CLINGO-SUB%20id%3D%22lingo-sub-905762%22%20slang%3D%22en-US%22%3EWorking%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905762%22%20slang%3D%22en-US%22%3E%3CP%3EI%20frequently%20work%20in%20two%20spreadsheets%20simultaneously.%26nbsp%3B%20I%20highlight%20in%20both.%26nbsp%3B%20My%20problem%20is%20now%20that%20we're%20using%20Excel%202013%2C%20when%20I%20change%20the%20highlight%20color%20in%20one%20spreadsheet%2C%20it%20changes%20it%20in%20the%20second%20spreadsheet%20too.%26nbsp%3B%20How%20can%20I%20keep%20these%20separate%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-905762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908663%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908663%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20by%20highlight%20color%3F%20Can%20you%20show%20us%20a%20screenshot%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908714%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908714%22%20slang%3D%22en-US%22%3E%3CP%3EHighlighting%20cells.%26nbsp%3B%20On%20one%20worksheet%20I'm%20highlighting%20the%20cells%20gray%20when%20the%20item%20is%20complete%2C%20and%20the%20other%20I'm%20highlighting%20yellow.%26nbsp%3B%20When%20I%20select%20the%20highlight%20color%20on%20one%20worksheet%20window%2C%20it%20changes%20it%20on%20the%20other%20window%20as%20well.%26nbsp%3B%20I%20have%20to%20change%20it%20every%20time%20I%20go%20to%20each%20worksheet.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908972%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423806%22%20target%3D%22_blank%22%3E%40terlynn_1370%3C%2FA%3E%20Are%20you%20by%20any%20chance%20referring%20to%20this%20button%20(the%20one%20with%20the%20red%20box%20around%20it)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20394px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137186i8EBDCB2D353D752D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-10-11_17-00-41.gif%22%20title%3D%222019-10-11_17-00-41.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20yes%2C%20then%20the%20only%20way%20to%20achieve%20what%20you%20need%20is%20by%20launching%20a%20second%20instance%20of%20Excel.%20In%20Windows%20Excel%20you%20do%20so%20by%20holding%20down%20the%20Alt%20key%20while%20starting%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
terlynn_1370
New Contributor

I frequently work in two spreadsheets simultaneously.  I highlight in both.  My problem is now that we're using Excel 2013, when I change the highlight color in one spreadsheet, it changes it in the second spreadsheet too.  How can I keep these separate?

3 Replies
What do you mean by highlight color? Can you show us a screenshot?

Highlighting cells.  On one worksheet I'm highlighting the cells gray when the item is complete, and the other I'm highlighting yellow.  When I select the highlight color on one worksheet window, it changes it on the other window as well.  I have to change it every time I go to each worksheet.  @Jan Karel Pieterse 

@terlynn_1370 Are you by any chance referring to this button (the one with the red box around it):

 2019-10-11_17-00-41.gif

If yes, then the only way to achieve what you need is by launching a second instance of Excel. In Windows Excel you do so by holding down the Alt key while starting Excel.

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
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies