Re: How to enter a two line column heading in excel

Tech-Archive recommends: Speed Up your PC by fixing your registry



Thanks for the tips!
Sharon

"JulieD" wrote:

> or if you have values in the column to the right or left of your formulas,
> simply double clicking on the + will fill the formula down.
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "gls858" <gls858@xxxxxxxxx> wrote in message
> news:elV82JVOFHA.3512@xxxxxxxxxxxxxxxxxxxxxxx
> > Sharon wrote:
> >> snip<
> >> Also, when I enter a formula that I want to continue in a column through
> >> its entire length, what characters do I use? Is there a fill down command
> >> for this?
> >
> > High lite the cell and put the cursor in the lower right hand corner.
> > It will turn into a + drag the + down the column.
> >
> > gls858
>
>
>
.



Relevant Pages

  • Re: How to enter a two line column heading in excel
    ... > High lite the cell and put the cursor in the lower right hand corner. ... > It will turn into a + drag the + down the column. ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Excel Text Function (Right, Left)
    ... fill down your column (move cursor over bottom right hand corner of the cell ...
    (microsoft.public.excel.misc)
  • Re: Indirect Row & cell formula
    ... number of where the cursor is at any particular moment. ... and the cursor is on A500 then the range I am wanting to find the maximum ... >> cell that the cursor is in at that moment. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Copying a formula
    ... your cursor on the lower right hand corner of C1 where the black box (the ... fill handle) is, your cursor will change to a black cross, click on that ... the formula from C1 to each cell below it, ...
    (microsoft.public.excel)
  • RE: how to enumerate?
    ... Click on that cell. ... Move the cursor to the lower right -hand corner of the cell (it will change ... "tendercare" wrote: ... Prev by Date: ...
    (microsoft.public.excel.newusers)