How to download the tools tab for MS Excel?
Question
I am looking for the Data analysis option for random number generation for my stats assignment. It should be in the tools tab, but there is no tools tab in MS Excel 2007. Can someone please guide me with this?
Answer
Data analysis is in DATA tab as the last item
is it possible to export data from MS Excel to MS word by pressing a button?
Question
Hi, I want to put a 'print' button on each row of my excel file, so that when the print button is pressed, a report is created in MS Word or Excel, which contains some of data from that particular row inserted into a predefined template. Does anybody have any ideas?
Thanks, but could you please say how it is possible to write the code in VBA? or guide me to some sites which have explained this?
Answer
VBA, and / or macros.
VBA = Visual Basic for Applications.
You could possibly do this in Access as well.
Why are all sessions of MS Excel closed down when I close one?
Question
You don;t have any problem opening more than one new session of MS word with the same name or having one close down all the others, so why does this happen with Excel. I use MS office 2002.
It even remembers where you last were in the page whereas MS word does not.
Answer
which X do you click
there is a small gray x and a larger one. the larger one closes the entire program and the smaller one closes the document or worksheet.
Is it possible to use a MS Word Document as a Form to insert data to an Excel spreadsheet?
Question
I am looking to create a form inside MS Word 2010, what I want it to do is when I type info into it, and press a button, it will save data into an MS Excel 2010 document. Is this even possible?
Answer
No
You can do it completely within Excel though.
http://spreadsheets.about.com/od/datamanagementinexcel/ss/090717_data_form.htm
In MS Excel how can i hide rows using a macro that are protected?
Question
I want to use a macro to hide and another to unhide rows in ms excel. But i also want to protect the sheet. The macro can't hide/unhide the protected rows. Is ther any way i can achive the level of protection for these rows and still have macros able to hide/unhide them?
Answer
Simple, write your macro to unprotect, hide, protect to hide rows
and unprotect, unhide, protect to unhide rows