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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with ranges
Either formulas or results are shown - there is no mix and match.
You can removed the = sign or precede the formula with a single quote and the formula becomes a text string and is displayed. There is no build in support for doing this other than editing the cell. F4 applies to what is selected in the formula bar. Unless you are working on a multicell array formula or filling the range, it doesn't work on existing formulas in multiple cells. -- Regards, Tom Ogilvy "denny" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with ranges
How can I make a macro that uses <F2<Home<'<Enter
and will repeat itself downward for as long as cells are occupied...from any column you start it in |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with ranges
One way:
Option Explicit Sub testme() Do If IsEmpty(ActiveCell) Then Exit Do Else ActiveCell.Value = "'" & ActiveCell.Value ActiveCell.Offset(1, 0).Activate End If Loop End Sub denny wrote: How can I make a macro that uses <F2<Home<'<Enter and will repeat itself downward for as long as cells are occupied...from any column you start it in -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with ranges
Thank you. That worked perfectly!!! Please look at Shelling Out to Dos
"Dave Peterson" wrote: One way: Option Explicit Sub testme() Do If IsEmpty(ActiveCell) Then Exit Do Else ActiveCell.Value = "'" & ActiveCell.Value ActiveCell.Offset(1, 0).Activate End If Loop End Sub denny wrote: How can I make a macro that uses <F2<Home<'<Enter and will repeat itself downward for as long as cells are occupied...from any column you start it in -- Dave Peterson |
Reply |
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) |