Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off auto cell formating?
I use Office 2007 to keep track of my home finances. I list my monthly bills
in a spreadsheet. As I pay them I shade in the cell to tell me that the payment has been made. The next month I will enter a bill from the same company. I really like it when the auto text finish kicks in. How do I keep it from auto shading that cell? Earlier versions of Exel allowed me to turn that feature off. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off auto cell formating?
I cannot reproduce this problem. In A1:A3 I typed: dog, cat, bear and then
shaded A2 yellow. In A4 I typed a "c" and Excel autocompleted this to give "cat" but without shading. May I be bold enough to suggest and alternative: Insert a new column A and when you have paid this bill type an X in the A cell. This will let you do more things. 1) you can now use Conditional Formatting to colour the paid bill; you type X and the row or a cell gets coloured automatically - I will give details if you wish 2) you can easily add the unpaid bills: suppose column A has the X, B the company name and C the amount of the bill. Then =SUMIF(A:A, "<X",C:C) will tell you the sum of unpaid bills. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "TAZ" wrote in message ... I use Office 2007 to keep track of my home finances. I list my monthly bills in a spreadsheet. As I pay them I shade in the cell to tell me that the payment has been made. The next month I will enter a bill from the same company. I really like it when the auto text finish kicks in. How do I keep it from auto shading that cell? Earlier versions of Exel allowed me to turn that feature off. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off auto cell formating?
Thanks for the help. I use the X in my checkbook to indicate canceled
checks. I started a new speadsheet and did the dog, cat and bear and had no problem. I'll keep working on it. Thanks again. "Bernard Liengme" wrote: I cannot reproduce this problem. In A1:A3 I typed: dog, cat, bear and then shaded A2 yellow. In A4 I typed a "c" and Excel autocompleted this to give "cat" but without shading. May I be bold enough to suggest and alternative: Insert a new column A and when you have paid this bill type an X in the A cell. This will let you do more things. 1) you can now use Conditional Formatting to colour the paid bill; you type X and the row or a cell gets coloured automatically - I will give details if you wish 2) you can easily add the unpaid bills: suppose column A has the X, B the company name and C the amount of the bill. Then =SUMIF(A:A, "<X",C:C) will tell you the sum of unpaid bills. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "TAZ" wrote in message ... I use Office 2007 to keep track of my home finances. I list my monthly bills in a spreadsheet. As I pay them I shade in the cell to tell me that the payment has been made. The next month I will enter a bill from the same company. I really like it when the auto text finish kicks in. How do I keep it from auto shading that cell? Earlier versions of Exel allowed me to turn that feature off. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off auto cell formating?
I am having the same problem. Unfortunately, my spreadsheet is too big to
recreate. Was anyone able to solve this problem? "TAZ" wrote: Thanks for the help. I use the X in my checkbook to indicate canceled checks. I started a new speadsheet and did the dog, cat and bear and had no problem. I'll keep working on it. Thanks again. "Bernard Liengme" wrote: I cannot reproduce this problem. In A1:A3 I typed: dog, cat, bear and then shaded A2 yellow. In A4 I typed a "c" and Excel autocompleted this to give "cat" but without shading. May I be bold enough to suggest and alternative: Insert a new column A and when you have paid this bill type an X in the A cell. This will let you do more things. 1) you can now use Conditional Formatting to colour the paid bill; you type X and the row or a cell gets coloured automatically - I will give details if you wish 2) you can easily add the unpaid bills: suppose column A has the X, B the company name and C the amount of the bill. Then =SUMIF(A:A, "<X",C:C) will tell you the sum of unpaid bills. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "TAZ" wrote in message ... I use Office 2007 to keep track of my home finances. I list my monthly bills in a spreadsheet. As I pay them I shade in the cell to tell me that the payment has been made. The next month I will enter a bill from the same company. I really like it when the auto text finish kicks in. How do I keep it from auto shading that cell? Earlier versions of Exel allowed me to turn that feature off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Sum, how do you turn it off?? | Excel Worksheet Functions | |||
to turn off Auto editing of cell | Excel Discussion (Misc queries) | |||
how do i turn off auto fill? | Excel Discussion (Misc queries) | |||
How do I turn off auto correct? | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions |