| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with ranges
1. In my old dos program, Lucid, I could mark a range and make it all be
LABEL, which meant it would move to the left and show the formula plus and apostrophe in front of it. In Excel, can I put an apostrophe in front of a whole bunch of cells at once? 2. Can I use <F4 to change a whole range from looking like- $A$1 to looking like $A1? 3. How can I show formulas in one range of cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct formula not working with ranges | Excel Discussion (Misc queries) | |||
| working with multiple consolidation ranges. | Excel Worksheet Functions | |||
| Named Ranges Not Working in Data Validation | Excel Worksheet Functions | |||
| Working with Ranges...Need help | Excel Discussion (Misc queries) | |||
| Problem Working with Named Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
