Clearing Excel Errors: Clearing all the green triangles

1. Take off freeze panes & remove splits
2. Page down so upper left column-row contains an error
3. Drag with mouse across other errored columns
4. Right-click any "!" cell and choose "Ignore Error"

No comments:

Favorite Tweets