General

rearrangimg data in excel2007 for merging into word 2007
Dear sir/madam, I quite regularly have to create a list of numbered labels which are printed on a 10 label sheet in word 2007.the list of numbers is created in excell and then merged into the mailmerge area of word Is there a formula that I can use in excel where I create the list that will re order the list fro... 25 Apr 2010 13:17

Report Back on 2007 No es Bueno!!!
Ok - so we started at my company with 2003, and I created a site to report numbers for sales on our intranet sharepoint, and everything was great! Now, with switching to 2007, it no longer automatically reports back to the other sheets!!! It's creating a bit of confusion for the people trying to view the report... 25 Apr 2010 15:36

insert an order number when another sheet opens
I have a form and every time I open it I need it to create a new number. Is this possible. also if I put it a number that does not correspond to an other number can it give me a warning. Thank you so much for your help Carmen cbucco(a)buccocouture.com ... 25 Apr 2010 12:10

Coloring cells using VBA in excel
I have drop downs on some cells - i have the code below that is meant to color the drop down cell once set by the user - which i does. However, I want to be able to 'reset' all my drop downs to 'blank' and clear the exisiting colorising - I have been using -Range("B4:J33").Value = ""- to clear the cells, but th... 25 Apr 2010 14:25

Lost hyperlinks Excell 2003-HELP
I created hyperlinks for three adjacent columns (each cell has same link). I had to insert non-hyperlinked column in between and now the hyperlinks in the first column are dead. Creating these links was quite time consuming and I'm hoping I don't have to go through each cell to create new hyperlinks. Is there a way... 25 Apr 2010 09:56

unhide all columns
the excel sheet shows H and then it goes to M I need to show all the columns they are not protected I just dont know how to show/unhide them ... 25 Apr 2010 09:56

Converting irregular Word table to spreadsheet
I am using Office Professional Edition 2003 I want to convert a list of members of a club and their contact details into a spreadsheet database. The form of each record in Word is: membership type (in upper case), name, address, phone number (if any), fax (if any), email (if any), for example ACTIVE B... 25 Apr 2010 13:17

Date Format
I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham ... 25 Apr 2010 13:17

How do I view complete text content in an Excel Comment box?
When scrolling over comment boxes in Excel, I can only partially view note content. Is it possible to specifiy the size of the comment box OR is there any simple method available to view complete contents of comment box while scrolling over? ... 25 Apr 2010 12:10

How can I write a number in an Excel cell with zero at the begin
... 25 Apr 2010 05:31