+ Reply to Thread
Results 1 to 13 of 13

Unwanted formatting

  1. #1
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Post Unwanted formatting

    Hey Forum

    I have just resently been past-and-cut som images from some SolidWorks pdf´s
    ever since i have had some strange formatiing, and i cant get rid of them.
    See attatched file.
    I have tryed to unistall office 365 and reinstal. But the problem still exists.
    Can anyone help.


    Regards, Tom
    Attached Images Attached Images

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Unwanted formatting

    Home - Editing - Clear - Clear Formats ?

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,194

    Re: Unwanted formatting

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  4. #4
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Unwanted formatting

    i have uploaded the file kapitalbov.xls
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,523

    Re: Unwanted formatting

    You added the file, but I don't see which cells contains a wrong format and what the right format should be (manualy in your file).
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  6. #6
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Unwanted formatting

    That is the true problem.
    It is not only Excel I have this problem with, all my Microsoft Office 365 are "strange"

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,523

    Re: Unwanted formatting

    What is "strange".

    Which cells should be differant, to your opinion?

    And how should they look like?

  8. #8
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Unwanted formatting

    Can you see the picture in the top of this thread??

    In my spreadsheet i have "black vertical lines" - i have been formatting

    and sometimes the green excel top menu turns black also

    Totally strange

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,523

    Re: Unwanted formatting

    I don't see those black lines in your file, if I open them.

    Did you also tried the solution in #2.

  10. #10
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Unwanted formatting

    no that does not work

  11. #11
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Unwanted formatting

    • Add more RAM memory
    • Disable/Enable (un-check/Check) Options - Advanced - Display -Disable hardware graphics acceleration and try how it works
    • Clean both TEMP folders (user and windows)
    Last edited by sandy666; 09-10-2017 at 10:58 AM.

  12. #12
    Registered User
    Join Date
    09-10-2017
    Location
    Odense
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Unwanted formatting

    Thank you sandy666
    Although I did not try you surgestions, as I discovered that my HD was almost full. So problem solved. Thx

  13. #13
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Unwanted formatting

    You are welcome

    That is why I said: Clean TEMP folders (probably there was a dozen gigabytes of garbage)

    I suggest: Reg Organizer
    Last edited by sandy666; 09-10-2017 at 04:09 PM. Reason: Reg Organizer

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Mask an unwanted total in a Pivot Table and problem formatting a large number
    By mlski4751 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-07-2016, 11:19 AM
  2. Unwanted Conditional Formatting
    By joyceprice in forum Excel General
    Replies: 10
    Last Post: 06-08-2012, 03:08 PM
  3. VLOOKUP unwanted date formatting
    By vicshippers in forum Excel General
    Replies: 13
    Last Post: 12-09-2011, 07:54 AM
  4. Conditional Formatting - blank cell gets unwanted format.
    By cheesysocks in forum Excel General
    Replies: 5
    Last Post: 12-03-2010, 10:56 AM
  5. Excel 2007 : Unwanted Conditional Formatting Rules
    By txdadoo in forum Excel General
    Replies: 1
    Last Post: 11-17-2010, 01:50 PM
  6. Unwanted formatting of downloads
    By BCB in forum Excel General
    Replies: 13
    Last Post: 04-09-2010, 07:13 PM
  7. Unwanted Formatting
    By hbt0@comcast.net in forum Excel General
    Replies: 1
    Last Post: 03-08-2006, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1