General

Printing Option Buttons
I am using options buttons inserted from the Control Toolbar (Excel 2003). They function correctly and appear fine in the worksheet. When printed, the button graphic always is displayed in a black square. I have tried changing the backstyle and backcolor properties to no avail. What am I missing? -- terr... 19 Feb 2010 18:53

I love u
I love excel <3 :0 :p ... 18 Feb 2010 10:36

exel
what can i use this for? ... 18 Feb 2010 10:36

insert objects in .xlsx fails with message "cannot insert object"
When inserting objects into an excel .xlsx spreadsheet I sometime receive an error message reading "cannot insert object" with no other alternaive than to click OK. I have tried inserting .docx and .xlsx files and in both cases I get the error, there appears no consistency. Why am I getting this error and how c... 18 Feb 2010 08:21

How do i create macro for export excel data to word in to letters
Hi there, I wan to export excel data in to word to create a letter. I have to create more then 100 letters at a time. Therefore, it should be in macro by 1 click and it should be able to run and create the letters. Kindly please reply me with the guide line. Many thanks. Kind regards, Siva.G ... 18 Feb 2010 10:36

custom command
How can I get the paste special "Paste Formulas" as a separate command on the Toolbar similar to "Paste Formats" and "Paste Values" ... 18 Feb 2010 07:14

VB Coding
I have a spread sheet with all cells locked except B1. Spreadsheet is protected allowing access to unlocked cells. I would like to be able to step through the spreadsheet by "unlocking" the next cell when data is entered into B1 and for the cursor to move to that next cell. I would like this sequence to be ... 18 Feb 2010 08:21

how do i copy/paste in excel without pasting hidden lines
I've got a spreadsheet with various rows hidden but when i highlight and copy into another ss it also copies all the lines i've hidden. I'm sure there must be a way to only copy the lines i want! ... 18 Feb 2010 07:14

How do I edit directly in a cell - previously F2
In earlier versions pressing F2 enabled editing directly in a cell. How do I do this in 2007 ... 18 Feb 2010 07:14

Counting text which meets a criteria
Hi, I have a column which displays percentages from 10% to 50%. Next column displays a text which repeats several times in that column against each percentage. In the answer column, I am required to first state the number of occurance between a range of percentages and the number of occurance of the texts t... 18 Feb 2010 06:09