Excel, Formulas and Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2036374%22%20slang%3D%22en-US%22%3EExcel%2C%20Formulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036374%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20that%20is%20sent%20to%20me%20weekly%20when%20I%20try%20to%20filter%20and%20sort%20on%20a%20specific%20column%20I%20get%20a%20symbol%20around%20the%20down%20arrow%20which%20is%204%20circles%20in%20each%20corner%20to%20look%20like%20the%20corners%20of%20a%20box%20with%20a%20line%20going%20down%20to%204%20arrows%20pointing%20up%20down%20and%20side%20by%20side.%26nbsp%3B%20I%20am%20not%20able%20to%20sort%20unless%20I%20go%20to%20formulas%20and%20then%20show%20formulas.%26nbsp%3B%20And%20even%20then%26nbsp%3Bsometimes%20I%20still%20am%20not%20able%20to%20sort%20that%20specific%20column%20even%20with%20showing%20formulas%2C%20any%20suggestions%20on%20how%20to%20fix%20this%20as%20I%20have%20not%20been%20able%20to%20find%20any.%26nbsp%3B%20Pic.%20below.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2036374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have an excel spreadsheet that is sent to me weekly when I try to filter and sort on a specific column I get a symbol around the down arrow which is 4 circles in each corner to look like the corners of a box with a line going down to 4 arrows pointing up down and side by side.  I am not able to sort unless I go to formulas and then show formulas.  And even then sometimes I still am not able to sort that specific column even with showing formulas, any suggestions on how to fix this as I have not been able to find any.  Pic. below.

2 Replies

@JennGibson2Learn 

The box with circles in the corner is a shape; the 4 arrows let you move the box around.

Press Delete to remove the box.

If there are more of them:

  • Press F5 to display the Go To dialog.
  • Click Special...
  • Select Objects...
  • Click OK.
  • Press Delete.

You should now be able to sort the data.

@Hans Vogelaar 

Hans you are a life saver . Your directions work.  Thank you so much.