Top 10 Microsoft Excel for PC Questions & Answers

Microsoft Excel for PC Logo

Question

  • 25,208 People Helped

CSV file to Import correctly into Excel 2003

Hi there people

I have a csv file with some stats in , seperated by a semi-colon (;) . When I open the file , it opens directly to Excel but all in one column. Is there any way to get Excel to give me the option to open it as delimited ?

Urgently need assistance please.

Thank you

Posted by on

Answer

  • Most Helpful of 1 Answers

Rudils,

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.

kpenguin

Posted on Nov 22, 2007

Question

  • 17,073 People Helped

Indian Rupee format in Excel spreadsheet

How to get figures in the Indian rupee format

Posted by on

Answer

  • Most Helpful of 6 Answers

Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00

Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0

Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

Posted on May 14, 2009

Question

  • 10,876 People Helped

how to select all sales entry in tally 9 and how to delete it

i have no idea to slect all sales entry in tally 9

Posted by on

Answer

  • Most Helpful of 4 Answers

Select all sales entry one by one by pressing space bar, & after selecting all the entries. Siply press Alt+D. all the selected Entries Deleted at once.
Note:- This feature is available on in original Tally Users not for Crecked Tally.

Sachin Sharma
Axis Convergence Pvt Ltd
Noida

Posted on Sep 04, 2009

Question

  • 9,265 People Helped

Excel file opens in read only mode

a friend of mine has an excel file that opens in read only mode, what does he change to be able to open the file in edit mode?

Posted by on

Answer

  • Most Helpful of 4 Answers

Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.

Have a Great Day!

Posted on Jan 28, 2009

Question

  • 6,888 People Helped

cursor stuck in MS Excel

When I open microsoft excel, running in windows xp on a pc, the cursor is stuck in the cell it happens to be in when the spreadsheet is opened. If the mouse is moved, without holding down either button, whatever area it passes over is highlighted, as if the left mouse button were pressed.

Posted by on

Answer

  • Most Helpful of 4 Answers

Tools menu.
Options.
Edit tab.
Enable the check boxes for "Edit directly in cell" and "Allow cell drag and drop"
OK.

This might have happened if you had opened up a excel with macros enabled!

Posted on Jun 20, 2009

Question

  • 5,326 People Helped

Microsoft Excel Temp Files

Excel creates temp files when I open a document but then doesn't delete them after closing the file. HELP! Thanks. Running XP btw.



Posted by on

Answer

  • Most Helpful of 3 Answers

I just finished with Trend Micro help support and they solved this problem for me. Open the main console for Trend Micro. Click on Viruses & Spyware Controls. Click on the "settings" for Protection Against Viruses & Spyware. Click on Advanced Settings. Under the section for "What Should TMIS Check for Threats" click on the circle for "Specify Targets that you choose". Click on "Select" next to "Ignore Specific Files & Folders". Then Add and folders of files that you do not want Trend Micro to check and make backups for. That solved my issue...hope it helps you too.

Posted on Feb 05, 2009

Question

  • 5,089 People Helped

how to use vlookup in openoffice using different sheets

have being facing problems using vlookup in openoffice while using different sheets. am looking for sample solution

Posted by on

Answer

  • Most Helpful of 5 Answers

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Posted on May 12, 2009

Question

  • 4,703 People Helped

"Not enough memory to run microsoft excel."

"Not enough memory to run Microsoft excel. Please close other applications and try again." is the error message when I try to open Excel. System has enough Free storage capacity. I tried after closing all other applications... still no use. Also tried renaming the msohelp.exe with .old extension. Could not find Mso9intl.dll and Msoffice.exefiles to rename with.old extension.
Tried reinstalling, uninstalling and repairing Office XP yet issue persists.
Please help on this issue.

Posted by on

Answer

  • Most Helpful of 1 Answers

it is conflicy with win xp updates.
check your ram.
go to device amanger then advanceced increase your virual memory to 1.5 *your rammmeory.

Posted on Jan 03, 2009

Question

  • 4,643 People Helped

can't reopen circular reference file in excel

How to open an excel file that contain a circular reference. When I open it, it show a warning excel security. There's an option disable and enable...What should I do?? Need ur help A.S.A.P...Thanx b4

Posted by on

Answer

  • Most Helpful of 2 Answers

  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Posted on Nov 05, 2008

Question

  • 3,938 People Helped

sumproduct or conditional sumif with multiple criteria in vba code...

Can anyone of you excel vba wiz and gurus tell me what's wrong with this code, I keep getting a Run-Time error '13': Type Mismatch error with this code.

Private Sub CommandButton1_Click()

Sheets("summary").Range("g74").Activate

Dim i As Integer
i = 74
For i = 74 To 80

ActiveCell.Offset(0, 1).Value = WorksheetFunction. _
SumProduct(--Sheets("stock card").Range("a2:a3351").Value = Sheets("summary").Range("a" & i).Value, _
--Sheets("stock card").Range("b2:b3351").Value = "", _
--Sheets("stock card").Range("e2:e3351").Value >= Sheets("summary").Range("$g$84").Value, _
Sheets("stock card").Range("k2:k3351").Value)

ActiveCell.Offset(1, 0).Activate

Next i
End Sub

Also, I would like to be able to use the "conditional sumif" function using multiple criteria arrays in lieu of the above "sumproduct" function...is this possible???

Thanks in advance, any help is most appreciated...
Jay

Posted by on

Answer

  • Most Helpful of 1 Answers

i'll just reply to your conditional sumif query.

yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:

{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria

initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))

then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.

Posted on Nov 18, 2008

670 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Excel for PC Excel

  • Excel for PC Excel

Most Popular Question

excel 2007 document recovery repeating

  • Computers & Internet
Loading...