| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting Function blanks adjoioning cell
Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in, inserting the '=' sign blanks out both the cell I'm working on and the one to the left. Of course, there are workarounds, but is there a way to not have to 'work around' this problem? Maybe I should add, often the cell in question is from another page, which can make its address rather long. Dave |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting Function blanks adjoioning cell
I'd just format the formula cell to left-justify temporarily, if required
-- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "Dave" wrote: Occasionally, when I want to insert a cell address for a cell that is immediately to the left of the one I am trying to put a formula in, inserting the '=' sign blanks out both the cell I'm working on and the one to the left. Of course, there are workarounds, but is there a way to not have to 'work around' this problem? Maybe I should add, often the cell in question is from another page, which can make its address rather long. Dave |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting Function blanks adjoioning cell
Thanks Max - I'll give that a try
Dave "Max" wrote in message ... I'd just format the formula cell to left-justify temporarily, if required -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "Dave" wrote: Occasionally, when I want to insert a cell address for a cell that is immediately to the left of the one I am trying to put a formula in, inserting the '=' sign blanks out both the cell I'm working on and the one to the left. Of course, there are workarounds, but is there a way to not have to 'work around' this problem? Maybe I should add, often the cell in question is from another page, which can make its address rather long. Dave |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting Function blanks adjoioning cell
Welcome, Dave.
-- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "Dave" wrote in message ... Thanks Max - I'll give that a try Dave |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting Function blanks adjoioning cell
On Jul 11, 8:53 pm, "Dave" wrote:
Occasionally, when I want to insert a cell address for a cell that is immediately to the left of the one I am trying to put a formula in, inserting the '=' sign blanks out both the cell I'm working on and the one to the left. Of course, there are workarounds, but is there a way to not have to 'work around' this problem? Maybe I should add, often the cell in question is from another page, which can make its address rather long. Dave If I'm understanding you correctly, you could also turn off "Edit directly in cell" in the Options. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are blanks being ignored by my MIN function? | Excel Worksheet Functions | |||
| growth function with blanks | Excel Worksheet Functions | |||
| Inserting blanks or changing dimensions | Excel Worksheet Functions | |||
| Adding a Function to a cell when inserting a row from a macro | Excel Worksheet Functions | |||
| cell ref in function formula change when inserting additional colu | Excel Worksheet Functions | |||
Hybrid Mode
