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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

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

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
>