Hi Everyone, I have set conditional formatting for a range for column: =MOD(ROW(),2) and choose grey color, so that the row will appear as one white and the...

I'm trying to copy HTML code into excel. I've tried copy, paste special, text. But it doesn't paste the code - it pastes the result of the HTML. Any...

I have 10 work books 7 columns in each of 60 to 100 rows (variable). The last column counts the work a number between 1 and 20. How can I select only the rows...

I have a table that is created by copying and pasting text from a pdf file. The problem isthat when the text is pasted into excell it does not recoginzed...

When I cut and paste from our Financial Records System, the numbers will paste like 88.00 when the actual numbers are 88.23 (example) yet when I copy and...

Dear Sir, I have an opportunity to use MS Excel 2003 extensively at my work place recently. Previously I was using Corel Quattro Pro Spreadsheet. I...

I often get list that I need to cut and paste into cells from emails where a person's last name is first, what is the easiest way to switch the format to read...

Hi, Last week, Mr. Don Guillett provided me with this formula to cut a Named Range and paste the Named Range one cell/row below. It works perfectly when I...

I'm using the "Right" function to modify an account number, when I copy the formula, and paste it in the cells below, the cell reference changes...

Hello all, I am attempting to cut and paste an entire row from a change action from one worksheet to one named "Closed" with the current script: Public Sub...

Hello all, I am attempting to cut and paste an entire row from a change action from one worksheet to one named "Closed" with the current script: Public Sub...

I have 30 rows of numbers the range is: d6:g35, j6:m35 (with h6:i35 blank). Each week I copy and paste one row of numbers to c59. Can you provide a macro that...

Folks, Can you help me make my mind up on how to go about moving small blocks of data from nearly 88 worksheets to one central worksheet. I'm trying to learn...

I need to take the right 2 characters of a string and cut and paste them to another column. For example: I have "ABC1" in coulmn J and I need to move the "C1"...

I would like to cut and paste pictures in excel 2003 as I did with excel 2002. It won't let me do that since I have upgraded. It is more stepes to insert a...

When I cut dates from Excel files downloaded from our organization's web site and paste them into a new file, they change. 9/1/98 becomes 9/2/95, etc. It...

how do i cut and paste just the subtotal lines from an excel worksheet without carrying all the data on the sheet?

When I run subtotals sometimes I need to transfer the subtotals to a new worksheet to run different formula's on them. The only way I seem to be able to cut...

Hi - I receive spreadsheet reports weekly that have several thousand records. I subtotal these reports to derive subtotals for specific customers. I...

Does anyone out there know of a way to protect a formula from alteration by the cuting and pasting of another cell (that is a cell that the formula...