I have been reading the help files, going thruogh every option,
and every possible thing I can thing of to find out how to stop
excel from changing my formula when I copy from one cell and
past to the next.
I want to copy column cells D4:D34 and paste them into E4:E34
with no change. I want it to be exactly the same. Excel seems
tho thing is okay to modify it for me and its driving me crazy.
When I copy the D4 formula of =SUM(Over!A1:A31)
and past it to E4 it auto changes to =SUM(Over!B1:B31)
I want it to read the same though. I need it to say exactly
=SUM(Over!A1:A31)that way i can do an auto replace and change
the word Over to Under. I have several colums to do this with.
I have a headache now and just realized I have spent 2 hours
looking for the answer. So mad. Please help?
Thanks so much anyone. I know the answer will be simple and
I will have to go bang my head on the wall. Sock it to me.
...with a button. You didn't think this would be an easy question did you?
I have a few spreadsheets that jam up my computer when auto calc is on. It's a pain to go to tools-options everytime I go into one of these which is often. Is there a way to get a button on my toolbar for turning auto calc on and off?
Thanks!
Hi,
I made formulas that expects cells to have text in form
"San Francisco 4, at Colorado 6" (without quotes). Now everytime I paste similar text to Excel, it splits it so that there's two cells, one with
"San Francisco 4", one with " at Colorado 6". That forces me to use a formula to combine the cells like =a1&","&b1
How do I turn that "auto split text to cells" feature off?
(If it takes VBA, it's totally ok. I've worked with VBA before.)
What line of code would I need to used to turn off the auto-calc upon opening a workbook?
Thanks,
Brian
i'm working on macros to manipulate a text file. the 1st macro parses the text file, next one sorts, ..... . The problem is, after the 1st parse when i paste the text data again (for further testing of next macros) , excel automatically parses the text (columns are split correctly, but formats are not what i want). i can close the file & reopen, but excel still does the parse automatically. the only way to 'reset' is to close down excel and restart... a real pain when you're testing code!
anyone know how to turn off this 'auto-parse' feature ?
I need help with auto correct.
Is it possible to turn off the automatic calculation for just one tab in the excel spreadsheet?
Thanks,
GoldFish
Hi,
I would like to customize the cell entry and how do I turn off the auto help feature in excel. for example, when I type "=" A I get a pop up with with all the functions start "A". Is there any way to turn off this feature? Please let me know. thanks
I know how to turn off auto-expansion by
"unchecking the Include new rows and columns in list option on the AutoFormat As You Type tab of the AutoCorrect dialog box."
how do you turn it back on?
Thank You!
Nicole
I am working w/ values that are interpreted as dates by Excel. The issue is that as I change it through code and have it displayed as I need it, I have to move it around to other locations w/in current sheet or to other sheets it gets reformatted to a date or serial number.
I was looking for a way to disable this feature as akin to turning off auto-correct feature. But have not found any method to do so. Can this be done in code?
thanks,
doug
