General

copy data in a cell if within a date range
"carrerapaolo" wrote: Column M is a listing of percentages Column A is various dates, anywhere from Jan 1, 1998 to the present. I need to copy the contents of let's say M3 into cell T3 is the date in cell A3 is any date in the year 2010. If the date is in another year, leave cell T3 blank... 19 Apr 2010 16:46

how dod I NOT select multiple cells at the same time
in some of my worksheets, when i use the mouse to select 1 cell I end up highlighting 4 cells everytime. What setting do I need to change so that only the cell I click on gets selected. ... 19 Apr 2010 16:46

I want to search "if cell a1 start with .. "
... 19 Apr 2010 16:46

how can I add an * to be the last character in a cell
I have 4,000 rows with data, and now realize I need an * to be the last character in all of the cells in Column A. Please help. ... 19 Apr 2010 17:48

Microsoft Excel
Can anyone please help me with the following error message: The cell currently being used contains a constant. There are no spaces before or after. ... 19 Apr 2010 17:48

Repeat formula
Hi again, thanks for the help, im trying to repeat a formula for all cells in a column, is there an easy way of doing this? Thanks James ... 19 Apr 2010 16:46

cell selection troubleshooting
Every time I open my excel doc and try to click on just one cell, it and the 4 below it are selected. It doesn't matter where in the document I click, either. I don't know how to undo it and wonder how I can fix this annoying glitch. Thanks in advance for any suggestions! Betty ... 19 Apr 2010 15:43

Disable macro selections under tools menu
I have macros to automate on a sheet and want to disable the option to run a macro under the tool selection on the menu bar. How would I do this? Thank you ... 19 Apr 2010 15:43

conditional formatting = or > cell reference + 2
I would like to set up CF to change the font color to red if the value (b2:b7) is = or greater than the cell reference (b:8)+2. What is the formula? Ex. only B7 would change to red font. A B 1Chart Dates 101 OR - Place Orders 2Mon 2/15 12.75% 3Tues 2/16 15.40% 4Wed... 19 Apr 2010 15:43

Data table with inputs from a differente worksheet
How can i create a data table in excel 2007, with inputs, formulas and calculation from a diferent worksheet? ... 19 Apr 2010 15:43