Search Not Just Numbers

Tuesday, 27 May 2014

Excel Tip: Remove all formatting

Just a really simple tip this week, as the week started with a public holiday, both here and in the US. That means that you're either lucky enough to have the week off and not interested in spreadsheets at all, or, like me, you've got four days to fit in a week's work!

Have you ever inherited (I'm sure you wouldn't have created one yourself) one of those Excel files with wild formatting all over it? 5 or 6 different fonts in as many different sizes and number formats, and twice as many colours?

Here's a simple tip to strip it all away leaving you with the important stuff - i.e. the data in the cells.

First of all, highlight the range you want to clear (click in grey box in the top left corner of the screen, to the left of the A of the column headings and above the 1 of the row headings, if you want to select the whole sheet).

On the Home Ribbon, over to the right hand side of the screen (below AutoSum and Fill), there is a button called Clear (with a picture of an eraser next to it).

Click this and you will be presented with the following options:

  • Clear All
  • Clear Formats
  • Clear Contents
  • Clear Comments
  • Clear Hyperlinks
Click "Clear Formats" and this will remove all formatting from the selected cells.

That's it. Nice and clean so that you can start again!

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".


  1. Consumers are not going to fully understand features it offers should you not demonstrate it all all by yourself. Moreover, synthetic version Gucci sacks function pretty well during the aspect of chanel replica stability, take into account composed of more or less similar substances that will be applied to the very first sacks. Providers clearly show any hermes replica same exact consideration when those synthetic version Gucci sacks. Products you can control keys, stitching, zippers, options, ties or anything else most of are similar to the ones applied to earning any fake rolex genuine brands. Thus i don’t look at the cause of possibly not finding any synthetic version Gucci sacks anytime every aspect turns out to be which means that wonderful. For example numerous young girls, I like to arcade authentic substantially. This reveals towards a traits romance meant for prada replica wives, hardly any level the way in which ancient they're just. I usually plan to shop for specialist shopping bags meant for my best match together with my best loved ones. They're just relatively convenance together with chanel replica important. Which means that, Me possibly not junk the case.

  2. "People recognize FARSCAPE's Zhaan prada replica is actually an 812 gucci outlet year old Pa'u or priest
    me in the street now," says chanel replica Claudia Black, Farscape's Peacekeeper Aeryn Sun. "It's just been very strange, just to have that hermes replica validation each time we come over to America, that there is success attached to our efforts."