Free Microsoft Excel 2013 Quick Reference

How to stop Excel from changing the cell properties?

Hi everyone,

I've just started using Excel for some small spreadsheet I need to have,
and I've stumbled upon a little problem.

Whenever I enter some text in a cell (for example August 2004), Excel
converts it to a 'date' format (aug/2004) which is not what I want.

How can I stop Excel from making these conversions, and tell it to keep
what I type?

Thanks in advance,


Post your answer or comment

comments powered by Disqus
Does anyone know how to stop excel from changing cell values when copying and pasting to a different location? I have tried using absolute but that doesn't seem to help.

I have data over time for different categories. when i change de reporting
time frame i want the chart colors to stay the same. Or when i change the
scope in categories i still want the categorie chart to keep its color.
How to stop excel from reformatting the colors?

I have an xy chart that plots Date vs. SVI. The SVI column has a
conditional formula that if the condition is met it will display a value,
otherwise it will display a blank cell.
Even though the cells appear blank they really contain a formula and excel
plots them in the chart as zero values. Is there a way to stop excel from
thinking that the value of the cell is zero? I don't want it to plot this
values. Please help.
Thank you

Microsoft Excel for XP (2002, I believe)
I'm a simple user of this program, but I cannot figure out how to STOP Excel
from changing my input to a date. I am trying to do a chart of yarn setts,
and when I type into the cell "12/2" (without quotes), and hit the tab to
move to the next cell, Excel continues to change my input to Dec 2. How do
I stop it from automatically changing my input to a date? The data I am
referencing is NOT dates!

Any help would be MOST appreciated!


In Excel 2002 10.2614.2625, I have a worksheet in which I never want
to see the contents of any cell underlined, ever.

To implement this, I can press Ctrl-A to hi-lite the sheet, then Ctrl-
U (either once or twice, depending on whether cell I'm sitting on is
already undelined) to kill all underlines thruout the sheet.

Henceforth, Excel behaves very well and doesn't underline new input--
even URLs, which is nice.

BUT, it always undelines newly-inputted hyperlinks. For example, if I
enter =HYPERLINK() into a cell and press Enter, the thing
is then underlined, and I gotta de-underline it. And I've got hundreds
of the little buggers.

Is there any way to stop Excel from doing that?

Thanks much.



How do i stop Excel 2007 from deleting leading zeros permanently and not having to change the number type.

eg. 00123 -> 123

Also is there a way to stop Excel from change long numbers eg. 321312321303 to 3.21E+10.


I want to stop Excel from dropping the leading zero, permanently and forever. I know I can format as text and or put in some special number formatting, but the data I work with this quickly becomes a pain. I just want Excel to retain those leading zeros, surely there is a way, an option somewhere that can be changed.

Thanks ahead of time for any help you guys can give me.

How can I stop excel from changing a date that I type (i.e 2007) back to
2005? I need the date to be in the future! But I can't figure out how to stop
it from changing to 2005. Please help.

I was wondering how to stop excel from reformatting a formula that you put in a cell like if in A1 you type =average(B2:B4) then you insert a row inbetween row 1 and 2 it will then automatically change the A1 formula to =average(B3:B5). I have tried adding a $ and it still does it. I want it to keep averaging B2:B4 if new data is added and not have to go back up and change the formula back to what it was to begin with.

Thanks for any help anyone has.

I am looking for an answer to how do i stop excell from turning the last five
digits in a 20 digit number

I have a number of cells containing formulas that I would like to copy. However, I do NOT want excel to change the cells within the formula. Is there a way to easily prevent excel from doing this, or do I have to go into each cell and add a $ before the value that I don't want changed?

This issue was present in Excel 2000, but only happened once in while. Since
upgrading to 2003 this issue seems to happen to me once a day.

Excel gets into a state that rows and columns are being selected
automatically by moving the mouse. Once in this state, nothing can be
selected within Excel and the only way to kill the process is CAD

No button or wheel on the mouse is used, EXT or Scroll are being used. It
occurs when Excel is opened and the mouse is click on any cell. Once Excel
is in this state, the only solution is to CAD and then reboot the entire
system. My system is not the only one experiencing this issue so
reinstalling I do not believe will fix this problem.

Has anyone experienced this issue, and if so, how did you fix it?


I use Excel to manage my database files. When a cell contents get long, Excel automatically wraps the cell!

There has got to be a macro script I can apply when the worksheet is opened.

The cell wrap was unchecked, however, the wrapping happens automatically.

When this happens, I get a very long cell that is annoying. I have to manually uncheck the wrap each time to have a managable spreadsheet whose cells are not longer than the displayed page.

This is not only slowing down my work but making my hands tired and frustrated.

It is appreciated if anyone knows how to stop Excel from automatically wrapping the cells.

Thank you.

1. Is there a way to keep Excel from automatically opening this window when there are rescued documents in storage?

2. Is there a way to have Excel automatically save the Rescued documents for future viewing when I close the window (without getting the prompt and having to click "yes" every time)?

Thanks very much!

Hello friends,

I'm having a problem in my Macro. I'm using VBA. The problem is that i have stored the values from a row in a dynamic array. Now i want to paste these values in the cells of that particular row with an offset. But i dont know how to paste values from array into cells.

Any kind of help is appreciated.

Waiting 4 quick reply..


Does anyone know how to prevent excel from opening a new blank workbook on startup? My installation (Excel 2003) used to do that, but for some unknown reason it now opens a new spreadsheet called Book1.

It also used to retain certain settings, which it now fails to do. I think the two issues are related. For example, I want the Tools -> Options -> Calculation -> Iteration checkbox to remain checked. But ever since it started opening a new blank workbook on startup, it also overrides this setting. It is getting annoying to have to reset it every time I start up excel.

(The reason I have it set is because I have some intentionally circular calculations.)

Everytime I have a circular reference, an error message pops up, and then Excel loads the help entry in a new window. I like the error message, but is there any way to stop Excel from opening the new window without disabling the error message? I am moderately proficient with vba, so I am open to that kind of solution as well. Thanks!

I want to stop people from deleting a specific sheet in a workbook. The
reason for this is that it is a template with scripts and buttons attached to
it. I'm not looking to stop people from changing the sheet, just accidently
removing it.

I am typing names and addresses into an Excel spreadsheet. I have one person
whose first name is True. When I type it into the cell, it converts it to
TRUE. I know this is a function/formula, but how do I stop it from doing

When I have for example 2 sheets : sheet1 – data for chars, sheet2-the chart
If I change the data in sheet1 - when I go to sheet 2 it shows me (for a brief second) the chart before, then it changes to the new chart.

How do I stop excel 2007 from doing this?

Because when the data is constantly changing (for exp. Connected to external data) then when I go to the chart excel crashes every time

Can anyone please tell me how to stop Excel 2007 from changing the font size
every time I type a URL into a cell. I'm using a spreadsheet to track a
number of URLs that I'm creating for my job. The default font size for the
worksheet is 12. Everytime I type a URL into a cell, Excel converts it to
font size 7. Then I have to change the font size back to 12. I'm tracking a
lot of URLs and this is getting old.

I spent a fair amount of time reading online help, google results,
Microsoft's site, and some forums without finding an answer. I would greatly
appreciate any advice.


I'm working with the latest service pack of Excel 2000.
Every number I enter into any blank cell becomes that number's 100th decimal
value. For example, typing "2" in a cell results in "0.02" when I leave the
This did not used to happen, but I don't know what I did to make it happen,
nor what to do to stop it from happening.

I am using Excel 2007 and often cut and paste data in number and scientific
number format. The problem is that Excel will often decide that I need to
see a large number of numbers after the decimal place and will change the
width of the columns to fit that many numbers. I am working with a lot of
data and so I would prefer to keep all of my columns at a set width of 8.43
to reduce the clutter. It becomes really annoying to have to change the
column widths back to the size that I want each time I add new data.

Can anyone please tell me how to stop Excel from automatically changing the
column width each time new data is entered?

Thank you.

I wrote several macros with VBA code for specific tasks, which works well.
In order to for user to launch the macros easily, I created a custom toolbar
and assigned each macro to a toolbar button. Thus, user can click a button
to run a macro, instead of pressing ALT+F8 and then selecting a macro on the

This approach works well except for one thing: when user opens a new Excel
work book from the customized template with the macro embedded in it (or
open a previous workbook and save it to a new file name), the toolbar button
remembers previous workbook's name and load macro from that previous file,
even though the same macros are available in this workbook. This causes the
previously worked workbook being opened undesirably. Even worse, if the
previous workbook is not available (renamed, or moved, or deleted), clicking
the toolbar button causes error message saying "xxxxxx.xls cannot be
found....". However, if user press ALT+F8 to run macro, Excel uses the macro
in the file, as expected.

Does anyone know how to stop Toolbar Button to remember where the macro is
loaded from? What is the point for Excel to remember the last file name of a
macro and loads it from there even though the same macro is in current
workbook? The ideal situation is, after assign a macro to a toolbar button.
It should only remembers macro's name. When being clicked, it should only
look into current workbook, if macro exists, run it, if macro does not
exist, report error message.

No luck finding an answer? You could always try Google.