Question about Microsoft Office Standard for PC

1 Answer

Problem in copiying

We have a excel file containg 2000 records of customer.Just by entering name of the person we got the details of PhoneNo, and the address using vlookup.

If we required to get the data in other coloumns with the same excel file what is to be done?

Posted by on

1 Answer

Re: Problem in copiying

Sorry but your description doesnt help and it is hard to understand what you want to do

Posted on Nov 17, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

How to convert .shs file to .xls format in office 07.pls help......

1. Open a blank Excel workbook by selecting "New" from the "File" menu.
2. Drag and drop the .shs file on to the new workbook by highlighting the scrap file icon on the desktop and dragging it onto the worksheet. Alternatively, you can copy and paste. To do this, click the scrap file icon, and then right-click and select "Copy" from the pop-up menu. Left-click on the Excel workbook, and then right-click and select "Paste" from the pop-up menu. The information stored in the scrap file should now appear within the worksheet.
3. Save the file. Select "Save As" from the "File" menu, and then enter a file name in the box at the top of the window that opens. By default, Excel saves files in the workbook format native to the version. For versions prior to Microsoft Office 2007, this is the .xls format. If you have Excel 2007 or later and want to save the file as .xls, select this format from the "Format" drop-down menu below the box where you entered the file name.

Feb 11, 2015 | Business & Productivity Software

3 Answers

Lost Password excell word 2003/2010 All files unlocked gauranteed within 3 hours. I dont charge unless I open them. I will send you part of the document as proof. Confidence assured.

I cannot think of a better software than Office Password Recovery 5.0 for personal use. With the amount of passwords recovery solution, includes : word password recovery solution, excel password recovery solution, access password recovery solution.
still wait for what?download this software to unlock your excel password.

Sep 10, 2010 | Microsoft Word 2000 for PC

1 Answer

Dear Expert I am using Windows Vista TM Home Premium at my Notebook Pc( HP Pavilion dv-5) with Microsoft office 2007 since last 01 year. My excel files are not opening and I am receiving following message...

maybe you relocated the file itself, check first if the file you are opening is still in its original location on your hard drive, if not, manually open it by double clicking, do not open it inside microsoft excel.

Jun 02, 2010 | Microsoft Excel 2003 (06503995)

1 Answer

I cant open my excel file, it said " File couldnt be found. Check the spelling of the file name, and verify that the file location is correct." i opened it from its folder, so it couldnt be that i've...

it's possible that the folder where the file is located may have a very similar name or path to the one where you're trying to open the file from, inside excel. double check not only the file name but the entire file location
for instance
if you have
would be different from

the look very similar but the folder where one file resides is myexcelfiless and the other folder with the same name resides in myexcelfiles, the difference is only one letter.. so please double take your time double checking!

Mar 25, 2010 | Microsoft Excel 2007 Home and Student...

2 Answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks,...

You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.

Sep 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address

Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

1 Answer

Minimize Data Entry

I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Jan 02, 2009 | Microsoft Excel for PC

1 Answer


Step1. Start Microsoft Excelmag-glass_10x10.gif and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. $('.Article .Steps .Image').each(function(i,e){ e = $(e); e.find('img').error(function(){ $(this).unbind(); e.remove(); }); });
Tips & Warnings
  • Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
  • Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet

you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Business & Productivity Software

1 Answer

Restict closing the main form when some controls on the subform are empty

Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

34 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides