Office & Productivity Software forum

Question

need help for excel!

by siokeng / May 16, 2012 4:35 PM PDT

Anyone can help? I'm using Office 2007. Once I save the document and re-open, the format and wording everything in disorder. Anyone know how to solve this? I have to rearrange everything all the times.

Thanks~~

Answer This Ask For Clarification
Discussion is locked
You are posting a reply to: need help for excel!
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: need help for excel!
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

All Answers

Collapse -
Answer
Re: Excel
by Kees_B Forum moderator / May 16, 2012 6:32 PM PDT
In reply to: need help for excel!

Very strange. Does this happen on ALL workbooks, only ONE workbook or only ONE worksheet of ONE workbook?

Kees

Collapse -
reply~
by siokeng / May 16, 2012 10:50 PM PDT
In reply to: Re: Excel

only one workbook. All the other workbook is alright. Do you know why?

Collapse -
Re: only one file
by Kees_B Forum moderator / May 17, 2012 4:04 AM PDT
In reply to: reply~

Then the next question: what is the file type (extension)?

In a .xls or .xlsx file formatting is kept. A .csv file, which is by default opened by Excel also, only contains data and no formatting. So if you open a csv file, format it and save it as csv file again, all formatting you did is lost. So, whatever the type of the file, if you save it as .xlsx or .xls it should be opened correctly next time.

Kees

Collapse -
reply~
by siokeng / May 17, 2012 11:12 AM PDT
In reply to: Re: only one file

it's a .xls format. I can't recall when it starts to become like this.

Collapse -
Bingo. XLS? 2007's native is XLSX. link follows.
by R. Proffitt Forum moderator / May 17, 2012 11:14 AM PDT
In reply to: reply~
Collapse -
Answer
Recently fixed one like that.
by R. Proffitt Forum moderator / May 17, 2012 4:09 AM PDT
In reply to: need help for excel!

The details don't really matter (something to do with printer selections) but one of the fixes was to open the old document, then a new document (and mind you, if some can't swap document for spreadsheet they need more help than I can give today.)

With both old and new open I'll select all, copy in the old doc then paste that into the new document then save the new document.

Then I'll make a backup copy once in awhile just in case.
Bob

Collapse -
reply~
by siokeng / May 17, 2012 11:14 AM PDT

I will try to copy and paste into the new workbook. there's quite a few worksheet in it. Thanks for your advise.

Popular Forums
icon
Computer Help 49,613 discussions
icon
Computer Newbies 10,349 discussions
icon
Laptops 19,436 discussions
icon
Security 30,426 discussions
icon
TVs & Home Theaters 20,308 discussions
icon
Windows 10 360 discussions
icon
Phones 15,802 discussions
icon
Windows 7 7,351 discussions
icon
Networking & Wireless 14,641 discussions

Smartphone tip

Hoarding photos on your phone?

Those picture are hogging memory and could be slowing down your phone.