Hiding #FIELD! in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2160824%22%20slang%3D%22en-US%22%3EHiding%20%23FIELD!%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160824%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20creating%20a%20stock%20portfolio%20tracker%20and%20I%20was%20wondering%20if%20there%20is%20any%20way%20to%20hide%20cells%20that%20contain%20%23field%20such%20as%20my%20picture%20below.%20I%20want%20to%20make%20the%20sheet%20look%20clean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20alleviate%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22carlocqb_0-1614122331279.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F257221i66B70C1F5658A08F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22carlocqb_0-1614122331279.png%22%20alt%3D%22carlocqb_0-1614122331279.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2160824%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
Occasional Visitor

Hello, I am creating a stock portfolio tracker and I was wondering if there is any way to hide cells that contain #field such as my picture below. I want to make the sheet look clean.

 

Is there any way to alleviate this?

carlocqb_0-1614122331279.png

 

2 Replies

@carlocqb 

 

If  you make your data into an Excel Table, as I've done with the attached, then it just automatically fills in the data when you enter the ticker in the first column or a new row, fills in the other columns.

mathetes_0-1614133250645.png

 

@carlocqb 

If you check the formula bar you see the formula by which the ticker is returned

image.png

You may modify it on

=IFERROR(D4.[Ticker symbol],"")

and drag down or double click on the dot at the right bottom on first cell selection.

image.png

But as @mathetes suggested it's better to use tables.