Removing Excel Formula

[andy-hughes]

I have inadvertently put a formula into an Excel cell.

The cell now has a tiny green triangle in its bottom right corner.

How can I get rid of it please?

[Peter Pedant]

if at any point in the future, you feel you need to do an excel course
excel-is-fun is excellent and free

it sounds as tho you have toggled the fill bar and it is waiting for you to give the second command.

if you put the cursor on the square and look in the space bar above
there should be formula you can delete

there is also a keystroke formular that shows ALL the formulas

[Etch]

An alternative for the category is to create a Filter:
Select a single cell in the category column, then choose 'Sort & Filter' > 'Filter'. A drop-down button will appear in the cell at the top of the category column. Click this and, in the list of categories, put ticks next to ones required. Click 'OK' and only the rows containing those categories will be displayed.

[bobbinwales]

Yes thats a better way etch, I have done it that way myself come to think of it

[andy-hughes]

Hi Etch

Thanks for that - I followed your instructions, and it tells me it has found 987 cells, but it doesn;t tell me where they are.

They are not showing on that secion - do i need to look somewhere else?

[THECORBYLOON]

Do those cells contain the same thing and do you want to delete it?

[Etch]

andy-hughes, the Find results should appear in the Find and Replace window (I'm using Excel Starter 2010, but I would expect things to be similar in later versions):
https://ibb.co/bXCQ8RX
Maybe in your case the window needs to be enlarged? Click on the bottom edge and drag it down.

You may find my second method more useful though, depending on what you are trying to do, because it hides the rows that don't contain the specified category making it easy to see the ones that do.

[Etch]

I've just checked online and nothing has changed in the later versions of Excel. The instructional video here may help:
https://support.microsoft.com/en-us/office/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

[andy-hughes]

Many thanks everyone.

It's days like this when I really feel my age!!