clear formats

  1. R

    'Clear Formats' does not clear all formats when only a part of text string is formatted in a cell.

    I use Excel 2013. The option "Home > Clear > Clear Formats" does not clear the formats when a part of text string is formatted in a cell. Please find a screenshot below and let me know, is there any option available to clear formats in such cases? Thank you in advance.
  2. P

    multiple formats in spreadsheet causing error in pivot table values

    Hi, thanks for reading. I'm editing several supplied spreadsheets which have been compiled from many horrible locations. There is a format diffefence in the main sheet (i cant clear it with Shift Ctrl * or format paste) It is causing my pivot table to return multiple values for the same item...
  3. P

    VBA Clear Formatting in all columns AFTER first blank column

    Morning, I am trying to write the code to clear all formatting in all columns after the first blank column in the current active worksheet. Example: Current worksheet has text in columns A:K, but the formatting continues beyond K, and I'd like to clear the formatting in all columns...
  4. S

    Excel 2007 default format issue

    Hi all, I have a clear feeling I'm missing something fundamental here, so apologies in advance... I have an excel spreadsheet containing 2 sheets: 1: Raw Data - The Raw data tab is formatted how I want it, i.e. Dates as dates, Numbers as numbers etc 2: Pivot Table - The Pivot table shows as...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top