Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm using Excel2007. For this case, I'm not using it to do any calculations; rather just a data listing (with repeated cell values: Thus, MsAccess is out of option).
To explain properly, whenever one types in a minus/dash sign (-), Excel will automatically insert the "name" of the highlighted cell (e.g. A1, B2, etc). Setting the data as 'Text', I could have just press 'Enter' to input the sign. However, as it is possible to input data directly into a cell, it would be unnecessary for me to press 'Enter' and just navigate to other cells with the arrow keys easily. I'm wondering if it is possible to do that? |
#2
![]() |
|||
|
|||
![]()
You need VBA .
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A macro that will inable/disable input message boxes by a cell'svalue | Excel Programming | |||
Disable Pop up "Continue typing in Office 2003 menu key sequence.. | Excel Discussion (Misc queries) | |||
Permanently Disable Auto Formatting of Cell Content | Excel Programming | |||
How do I input a minus time in an excel spreadsheet | Excel Worksheet Functions | |||
Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions |