At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
I created a workbook to record my Ebill confirmation pages. I take a screen copy of the confirmation page for each of my Ebills and paste them on separate worksheets, thus having a record of payments should I need them. All was fine until I opened up the workbook and it was all gibberish. If I open the file while in Excel, it show a screen telling me that the "Text Wizard" says the data is "Delimited". If I open from "Recent Items" in Vista, I get the gibberish of ramdom characters, punctuation marks, wingdings, etc. Suggestions?
You could try to change the whole workbook font to a known good one or do it a sheet at a time by doing a "select all" then setting the font.
It sounds as if though you are trying to import a web page including the HTML code which may well cause the problem you see.
I prefer to do that type of thing with a
"Get External Data"
"new web query"
which will put things into a sheet in such a way as you can use them in other calculations
Whenever you open the sheet it will go and get the latest information for you automatically so you can then select what you want and copy that to another sheet. to use to keep track of things.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
In Microsoft Excel, you can protect a single cell, group of cells on a worksheet or an entire workbook by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of password. Password to open the document: If it is applied then you have to give the correct password to open the workbook. Otherwise you cannot open the workbook. Password to modify the document: If it is applied then you have to give the correct password to modify the workbook. Otherwise your workbook is opened but you cannot modify the workbook. It means that your workbookbecomes read-only. To apply a password to MS Excel document, follow the given steps: First click on "Tools" menu and select the "Option" from drop down menu. A windows dialog box will appear, here select the "Security" tab. Enter first password in "Password to open" text box under "File encryption settings for this workbook" section and second password in "Password to modify" text box (if required) under" File sharing settings for the workbook" section then click "Ok" button of dialog box. Microsoft Excel will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters. Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one. Now close the file and then reopen to test the password.
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Excel Macro-Enabled
Workbook
.xlsm
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
Excel Template
.xltx
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Excel Macro-Enabled
Template
.xltm
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
Excel Add-In
.xlam
A supplemental
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
sheets.
Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)
1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.
2.) On the Window menu, click Arrange.
3.) Under Arrange, click the option you want.
To view sheets in only the active workbook, select the Windows of active workbook check box.
to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy
new work book
select cell edit/paste special/values
now do the formating/color/font/size etc in the new workbook and check if they work here
When you ask to print the page are you asking for more the one copy? If you are there is a collate check button next to the requested sets box, in the print dialog box. Make sure its not check. Collating the print means your PC sends a copy of the file for each requested copy. IE: you print one page and ask for six copies, your PC sends the file six times, one copy of the file for each print requested.
Also because your printing from a windows application IE: Excel you should be using the PCL print driver as apposed to a PostScript print driver. The time it takes to convert the file into PostScript for the printer to process it is time consuming.
Highlight and copy the text in the telephone directory PDF, paste it into excel and use the excel text to columns tool to justify the mess of text into the appropriate columns.
id say the delimited by spaces option would be the go with this one, though PDFS often have issues when trying this method.
You may need to pre clean the pasted data before putting it into excel with notepad using find and relace to remove double spaces and wierd charcaters.
1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.
The key is to import the data and not open the file directly.
1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.
I hope that helps. Please add a comment if it not clear.
×