General
in [Excel]
|
Copying locked cells I have a ss with formula in locked columns and the whole thing protected to stop the formula being altered. When the user comes to the last row in which there is a formula she needs to copy this last row and paste into however many rows she needs to complete her figures. However the protection is not allowi... 22 May 2010 07:17
Default Cell format of existing Worksheets got changed automatical I am using MS Excel 2007. Most of my excel files saved with default cell format as General while creation; currently for the last two days when i open those files the cell content format is showing as currency format. Pls let me how to fix the same ... 21 May 2010 04:05
Why can't I open my "Excel" files immediately? Why can't I open my "Excel" files immediately? ... 21 May 2010 06:14
New Formula No.1 NO.2 result 1245585 245858 245858 1245585 Here In No.1,No.2 colum there. I want Union of Two cell values that is A2,B2 Unique values answer How can i Get In the C2 column that is reuslt. extracting the tha values at a time disply in result cell . ... 21 May 2010 06:14
Macro help!!! Hi, i need a macro that will save the workbook as html and insert an hyperlink in page and a script for password. I have the script, but i don't know how to make the macro to insert the code in the body of the html. Can this be done? Thanks! ... 21 May 2010 03:00
how to drag the cell to assign numbers by skipping one row each ti 1 skip 2 skip 3 skip 4 and so on... ... 21 May 2010 03:00
find the correct sum HI EXPERTS, i hope you and excel can do this. i have a master data with so many rows. i.e A B C D No Name City Values 1 Tony Tokyo 100 2 Bob Singapore 3081 - 5000 John India 6 total values more than 1,000,000 now my boss ask me to find values with total sum i.e 258,918 from data above. ... 21 May 2010 07:19
Excel - not everything is printing out? I tried to print out an Excel spreadsheet and only the color headings within the spreadsheet printed out. None of the B&W numbers in the individual cells printed out. I tried printing on two different printers and two different laptops, so I know it is not the black ink cartridge being low on ink. Help ple... 21 May 2010 01:56
Symbols used in excel Does anyone know where I can find a list of the symbols used in Excel formulas and what they mean? I am experimenting alot more with excel and having a usefull list would be great. ... 21 May 2010 09:31
remove row with some data not exact I have a spreadsheet that I want to delete the entire row if it contains 04-29-2010 but there is a time stamp that changes after that. How do I delete all the rows containing 04-29-2010 with random data after? Thanks in advance for your brilliance! ... 21 May 2010 11:43 |