| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing a Formula
In my workshhet I add three columns. I would like to delete one of the
columns in a new worksheet. And add only two of the three. I know I can delete a colum, but in the formula all three cloumns remain. Is there a way I can delete that column from the formula , without editing each formula one by one? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing a Formula
if you highlite the range for the formula, type in the formula once, then hit Ctrl Enter, this will enter the formula in all the highlited cells and will reference accordingly -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=571216 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula changing | Excel Discussion (Misc queries) | |||
| Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
Linear Mode
