General

How can I remove the previous lock cells and keep the new ones.
Could you please help me?... I locked and protected the cells A1:H20 in the sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect these cells and locked and protected the cells A21:H40 instead. However, for some reason the cells A1:H20 are still lock and protect. How can I remove the previ... 19 Feb 2010 12:08

Copy worksheet into current workbook
This is a new problem I'm having. In the past I've been able to copy worksheets into the existing workbook and am now getting the following error. Microsoft Visual Basic: File not found: 'C:\Docume~1\[computer name]\Locals~1\Temp\VB24.tmp This is only happening in particular workbooks, as I am able to copy ... 19 Feb 2010 11:00

Cash flow projection with breakeven chart
Looking for a cash flow projection worksheet with a chart that will show at some point in sales growth will the company run out of cash. Another words during rapid sales growth inventory and AR must be funded requiring cash so at what point will growth deplete cash. Thank You ... 19 Feb 2010 08:45

macro to copy formats
Hi I am getting a list of data from other department having columns from A to J and around 1000 records. in this list column "J" contains name of clients and there may be 5 to 20 records of each client. I have another Master list of Clients in which I have given separate font and/or cell colour for each cl... 19 Feb 2010 09:53

Cannot copy selected cells
Hi, HELP! If I open a new workbook , copy or add text into multiple cells and then do a Shift to highlight the block of cells the flashing lines around the cells dissapear and I don't have enough time to do a Ctrl C to copy them! It doesn't matter if it is new text, copied text from email or another workbook.... 19 Feb 2010 13:17

cell formatting in excel - more than 1 character at a time
all cells in excel 2003 are now accepting only 1 character, alpha or numeric when I go to type 2003 , for instance, the 2 shows, but then when I try to add the 0, the 2 disappears. ... 18 Feb 2010 19:38

excel 2003 cell formatting
All of a sudden I can only type one number (or Character) in a cell. Say I'm wanting to type 2010, I type the 2, but when I go to type the 0, the 0 appears, but the 2 disappears. Is this fixable by going to the preferences? If so, how? Thanks in Advance, ... 18 Feb 2010 19:38

custom text filters?
i am trying to filter out entries by using the "text filter > custom filter" option. my problem is that i don't how to use more than 2 custom filters. i was expecting to see an "add new filter" button or similar, but i dont see anything like that. ... 18 Feb 2010 19:38

How do I insert borders in every cell in a column
Please help Thanks Steve ... 18 Feb 2010 18:30

Display No Data in Pivot
I am using Excell 2007, and I have create a pivot table, and I have a number of reps that I want to display in my pivot and their sales amounts. In my data table, I have created "dummy" rows with the reps names, but sales $ are blank because they haven't sold anything. I want their name to show up in my pivot... 19 Feb 2010 21:07