LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default formulas showing up in an empty cell by themselves

I have a worksheet with many formulas for different cells based on the hour
of day. (S1-S8 for 0100-0800, T9-T12 for 0900-1200, U13-U1800 for 1300-1800,
T19-T23 for 1900-2300, S24 for 2400).
The problem is that the formulas are only input in the cells listed but in
the empty cells adjacent to cells with formulas the formula will input itself
when the data is input in the cell the formula above or beside it is looking
at/for. (T13 should be empty and is left blank when worksheet created but
when the data that U13 is looking at is input it seems like T13 is copying
the formula from T12 all by itself)
I have already remove the "allow data ranges to extend" selection in the
excel options area, I thought that worked but other users are still having
the problem. I checked their settings and they are the same as mine.

Any ideas? Please help!
Sorry, I tried to describe as best and clearly as I could!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
showing an empty cell instead of a zero in a formulated cell. Frustrated in AL Excel Worksheet Functions 1 January 31st 08 10:05 PM
Showing results in cell using formulas Jonathan Excel Discussion (Misc queries) 1 December 10th 07 06:29 PM
printing without zeros showing in a cell with formulas John Excel Worksheet Functions 3 October 28th 07 01:05 AM
Avoiding empty cells showing as zero in line chart without na() [email protected] Charts and Charting in Excel 2 January 3rd 07 12:59 PM
How can I chart a data series without showing empty cells? Brent Charts and Charting in Excel 1 January 19th 06 03:38 PM


All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"