Help! Hyperlink style went missing (cell styles)

%3CLINGO-SUB%20id%3D%22lingo-sub-1076876%22%20slang%3D%22en-US%22%3EHelp!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076876%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help.%20I%20have%20been%20working%20in%20some%20spreadsheets%20and%20have%20been%20successfully%20converting%20columns%20of%20email%20addresses%20to%20hyperlinks%20using%20the%20cell%20style%20%22hyperlink.%22%20I%20just%20opened%20a%20new%20spreadsheet%20and%20now%20the%20hyperlink%20style%20is%20missing.%20I've%20tried%20opening%20new%20worksheets%20to%20see%20if%20the%20style%20reappears%2C%20but%20it%20does%20not.%20So%20literally%20one%20minute%20it%20was%20there%20and%20working%2C%20and%20the%20next%20minute%20it%20was%20gone.%20How%20can%20I%20get%20that%20style%20back%3F%20I%20have%20attached%20a%20screenshot%20to%20show%20it%20is%20missing.%20It%20is%20usually%20found%20where%20I%20highlighted%20the%20screen%20shot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1076876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1076925%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F495139%22%20target%3D%22_blank%22%3E%40FSSimon%3C%2FA%3EI%20don't%20see%20a%20Hyperlink%20style%20in%20my%20Excel%20so%20am%20unsure%20what%20you%20are%20referring%20to.%20Maybe%20it%20was%20a%20custom%20style%20that%20someone%20else%20had%20set%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1076949%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F166840%22%20target%3D%22_blank%22%3E%40Alan%20Murray%3C%2FA%3E%26nbsp%3BThe%20only%20person%20who%20uses%20my%20computer%20and%20who%20uses%20Excel%20on%20it%20is%20me.%20I%20found%20the%20style%20from%20guidance%20I%20found%20on%20the%20Internet%20to%20begin%20with.%20The%20video%20showed%20it%20as%20a%20standard%20style%20that%20comes%20with%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1076968%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076968%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F495139%22%20target%3D%22_blank%22%3E%40FSSimon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECtrl%2BK%20will%20open%20up%20hyperlink%20in%20the%20current%20cell.%26nbsp%3B%20There%20you%20can%20map%20to%20where%20you%20want%20it%20to%20go%20-%20and%20upon%20saving%20you%20will%20get%20the%20traditional%20hyperlink%20format%20you%20were%20looking%20for.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20answer%20your%20question%20of%20what%20happened%20-%20but%20it%20is%20a%20band-aid%20for%20the%20time%20being.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162751i00AA3F962180891A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1076972%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F487135%22%20target%3D%22_blank%22%3E%40Fortijo%3C%2FA%3E%26nbsp%3BThanks%20so%20much%2C%20but%20I%20have%20a%20column%20populated%20with%20thousands%20of%20email%20addresses.%20Would%20I%20have%20to%20do%20that%20in%20every%20one%2C%20or%20can%20I%20select%20all%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1076974%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F495139%22%20target%3D%22_blank%22%3E%40FSSimon%3C%2FA%3EYou%20could%20use%20the%20HYPERLINK%20function%20in%20another%20column%20to%20generate%20links%20quickly.%20The%20formula%20if%20your%20first%20email%20address%20was%20in%20C3%20would%20look%20like%20this%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3DHYPERLINK(%22Mailto%3A%22%26amp%3BC3%2CC3)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523481%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Hyperlink%20style%20went%20missing%20(cell%20styles)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F495139%22%20target%3D%22_blank%22%3E%40FSSimon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20too%20experienced%20the%20problem%20of%20the%20missing%20%3CSTRONG%3EStyles%3A%26nbsp%3BHyperlink%3C%2FSTRONG%3E%26nbsp%3Bto%20apply%20to%20a%20spreadsheet%20with%20multiple%20columns%20of%20hyperlinks%20across%20thousands%20of%20rows.%20I%20was%20successful%20in%20making%20the%20Hyperlink%20option%20reappear%20in%20the%20Styles%20grouping%20by%20editing%20(F2%2C%20then%20pressing%20Enter)%20one%20cell%20to%20activate%20the%20hyperlink.%20When%20I%20now%20click%20the%20Styles%20drop-down%2C%20the%20option%20for%20Hyperlink%20appears.%20Next%2C%20I%20selected%20the%20desired%20column%2C%20clicked%20the%20Styles%20drop-down%2C%20chose%20Hyperlink%20and%20voila%2C%20it%20activated%20all%20Hyperlinks%20in%20the%20column.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Hyperlink.jpg%22%20style%3D%22width%3A%20650px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205460i9AEE06BEED313987%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Hyperlink.jpg%22%20alt%3D%22Hyperlink.jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I hope someone can help. I have been working in some spreadsheets and have been successfully converting columns of email addresses to hyperlinks using the cell style "hyperlink." I just opened a new spreadsheet and now the hyperlink style is missing. I've tried opening new worksheets to see if the style reappears, but it does not. So literally one minute it was there and working, and the next minute it was gone. How can I get that style back? I have attached a screenshot to show it is missing. It is usually found where I highlighted the screen shot.

6 Replies

@FSSimonI don't see a Hyperlink style in my Excel so am unsure what you are referring to. Maybe it was a custom style that someone else had set up.

@Alan Murray The only person who uses my computer and who uses Excel on it is me. I found the style from guidance I found on the Internet to begin with. The video showed it as a standard style that comes with Excel. 

Hi, @FSSimon 

 

Ctrl+K will open up hyperlink in the current cell.  There you can map to where you want it to go - and upon saving you will get the traditional hyperlink format you were looking for. 

 

It doesn't answer your question of what happened - but it is a band-aid for the time being.

clipboard_image_0.png

 

@Fortijo Thanks so much, but I have a column populated with thousands of email addresses. Would I have to do that in every one, or can I select all?

@FSSimonYou could use the HYPERLINK function in another column to generate links quickly. The formula if your first email address was in C3 would look like this;

 

=HYPERLINK("Mailto:"&C3,C3)

@FSSimon 

 

I too experienced the problem of the missing Styles: Hyperlink to apply to a spreadsheet with multiple columns of hyperlinks across thousands of rows. I was successful in making the Hyperlink option reappear in the Styles grouping by editing (F2, then pressing Enter) one cell to activate the hyperlink. When I now click the Styles drop-down, the option for Hyperlink appears. Next, I selected the desired column, clicked the Styles drop-down, chose Hyperlink and voila, it activated all Hyperlinks in the column.Hyperlink.jpg