Excell

%3CLINGO-SUB%20id%3D%22lingo-sub-1896610%22%20slang%3D%22en-US%22%3EExcell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1896610%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1-renaming%20columns%3C%2FP%3E%3CP%3E2-renaming%20hyperlink%20(it%20is%20too%20long%20and%20doesnt%20look%20professional%20on%20my%20chart)%3C%2FP%3E%3CP%3E3-embedding%20the%20chart%20onto%20my%20squarespace%20blog%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1896610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESettings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1918834%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918834%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872094%22%20target%3D%22_blank%22%3E%40Patrice355%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ETo%20rename%20a%20column%2C%20select%20the%20column%20header%20and%20hit%20%22F2%22%20on%20you%20keyboard.%20This%20will%20put%20your%20cell%20in%20Edit%20mode%20and%20you%20can%20modify%20the%20text.%20You%26nbsp%3B%20can%20also%20just%20start%20typing%20without%20hitting%20%22F2%22.%3C%2FLI%3E%3CLI%3EIn%20excel%2C%20you%20can%20use%20%3Dhyperlink%20function.%20%22%3Dhyperlink(link%20location%2C%20friendly%20name)%22%20See%20example%20below.%20This%20will%20make%20a%20hyperlink%20to%20google%20but%20will%20only%20show%20the%20word%20%22search%22.%3C%2FLI%3E%3C%2FOL%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DHYPERLINK(%22www.google.com%22%2C%22search%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I%20don't%20know%20about%20SqareSpace%20blog%20so%20I%20can't%20help%20with%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need help

 

1-renaming columns

2-renaming hyperlink (it is too long and doesnt look professional on my chart)

3-embedding the chart onto my squarespace blog

 

Help Thanks

 

1 Reply
Highlighted

Hi @Patrice355,

 

  1. To rename a column, select the column header and hit "F2" on you keyboard. This will put your cell in Edit mode and you can modify the text. You  can also just start typing without hitting "F2".
  2. In excel, you can use =hyperlink function. "=hyperlink(link location, friendly name)" See example below. This will make a hyperlink to google but will only show the word "search".
=HYPERLINK("www.google.com","search")

 

And I don't know about SqareSpace blog so I can't help with that.