| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I freeze 3 different columns?
I have this
columns =sum(b3+c3+d3)/3 total is in h3 1st I would like to add a new daily number in b3. I would like the numbers in c3 & c4 to shift right on enter with c4 actually deleting or dropping off. The new total would be b3-d3 2nd I have the same situation "on the same sheet"! I have =sum(e3+f3+g3)/3 total is in I3 I'd like to add a new daily number in e3 and have f3 & g3 shift right with the old g3 number deleting or going away What I have is, 2 sets of 3 columns that add then average, on the same sheet. I would like to enter a new daily number on the left of each set, clearing the 3rrd number on each. OOO..Kay.. Is this possible... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Freeze Multiple Rows/Columns | Excel Discussion (Misc queries) | |||
| Freeze rows/columns in Excel | Excel Worksheet Functions | |||
| freeze other columns when columns have been frozen already | Excel Worksheet Functions | |||
| Freeze Two Columns | Excel Worksheet Functions | |||
| How do I freeze the widths of columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
