- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Clearly, We’ve Got Some Options

Posted By On May 26, 2006 @ 2:21 PM In MS Excel,MS Office Help | Comments Disabled

Clearly, We’ve Got Some Options

So, you’re working in MS Excel with some data and you’ve got some changes to make.

If you needed to delete some data, you would simply highlight the cells and hit the Delete key.

But, let’s suppose you don’t want the data deleted, but instead you want the formatting removed. What do you do then?

You could spend time reformatting the cells or undoing whatever formatting has to go, but this could take a while, so I bet you’re looking for a quicker method. (Of course, undo only works if the formatting steps were the last things done).

The truth is, you do have choices about what you clear from a cell without all the extra steps. Ready to see how?

Good, then let’s look at our options.

The first thing you need to do is highlight the cells to be affected.

Next, you’re looking for the Edit menu, Clear choice.

Clear brings up a submenu with four options.

All will clear out everything. (And I do mean everything: data, formatting, comments and all).

Formats will remove all formatting. (The cell’s contents and any comments will not be affected).

Contents is the same as the Delete key. It will remove the cell’s contents (data, formulas, labels, etc.) only and leave intact any formatting and/or comments.

Side Note: Another quick way to clear contents is to highlight the cells and right click.

Choose Clear Contents from the pop up menu that appears.

Comments removes all comments attached to the highlighted cells. All cell contents (data, formulas, labels, etc.), along with formatting, are not affected.

So, we clearly have some choices. The question is: to delete or to not delete.

~ April

Clearly We’ve Got Some Options

Posted By On November 19, 2004 @ 2:24 PM In MS Excel | No Comments

Clearly We’ve Got Some Options

So… you’re working in MS Excel with some data and you’ve got some changes to make.

If you need to delete data you would simply highlight the cells and hit the Delete key.

But, let’s suppose that you don’t want the data deleted but instead want the formatting removed. What do you do then?

You could spend time reformatting the cells or undoing whatever formatting has to go. This could take a while, so I bet you’re looking for a quicker method. (Of course, undo only works if the formatting steps were the last things done.)

The truth is that you do have choices about what you clear from a cell without all the extra steps. Ready to see how?

Good—then let’s look at our options.

The first thing you need to do is to highlight the cells to be affected.

Next you’re looking for the Edit menu, Clear choice.

Clear brings up a submenu with 4 options.

image

“All” will clear out everything—and I do mean everything—data, formatting, comments and all.

“Formats” will remove all formatting—the cell’s contents and any comments will not be affected.

“Contents” is the same as the Delete key. It will remove the cell’s contents (data, formulas, labels, etc.) only and leave intact any formatting and/or comments.

Side Note: Another quick way to clear contents is to highlight the cells and right click.

image

Choose Clear Contents from the pop up menu that appears.

“Comments” removes all comments attached to the highlighted cells. All cell contents (data, formulas, labels, etc.) along with formatting are not affected.

So, we clearly have some choices. The questions is to delete or to not delete.

~ April


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/clearly-weve-got-some-options/