I have 881 excel documents where I need to copy data from to a master document, the data is always in the same cell range A11-14 and D11-14, is there a way I can do this?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_228...
Hi, I have an Excel file with a certificate that is being generated using the tool from Office2003. Now I have upgraded to Excel2007. How do I install this certificate in the new environment.
Pl...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/12/2007 Grade: A Views: 0
In Excel 2007 how do you set it up to repeat formatting every 4 rows. i.e. highlighting the row.
Without using the auto table tools.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
How can i make the first 4 colums protected in excel 2007.No one should be able to move ,delete or edit them.Can i know the step by step way of doing this please.
Regards
Sharath
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I copy 20 rows * 2 columns, then past. Takes about 5 minutes before Excel finishes. What can I do to speed this up.
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_23049843.html
hI,
Save Excel every 3 min and even have an way to undo changes if required.Is this possible.
Regards
Sharath
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have information in columns A-Q. How would I dedupe all that information and place them into new cells?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/16/2008 Grade: B Views: 4
I have a list of numbers in column A. I have a list of numbers in column B. I want column B to look at column A. If a number in column B is found in column A, then it is deleted. The rest of the nu...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS Excel,
HTMLDate Answered: 01/23/2008 Grade: A Views: 8
I'm using Excel 2007 to present data from an OLAP data source. I've got a data set on my worksheet with 5 columns and 6 rows. When I make a chart, the horizontal and vertical are not the way I want...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS Excel,
OLAPDate Answered: 01/30/2008 Grade: A Views: 24
Need to tweak the following code to address these questions:
1. How do I get rid of the marks on the lines I tried xlXYScatterSmoothNoMarkers, but did not work
2. If I do not have Range(A1).A...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/15/2008 Grade: A Views: 0