[jaws-uk] Re: Dragging cells containing formula, number or date series in Excel

  • From: "Ankers, Dave (UK)" <Dave.Ankers@xxxxxxxxxxxxxx>
  • To: <jaws-uk@xxxxxxxxxxxxx>
  • Date: Tue, 4 Dec 2007 09:11:21 -0000

Tom,

What are you trying to do? The instructions below work with formula too,
automatically changing the cell co-ordinates to suit.  If you are trying
to do something different, let me know.
HTH

Dave

For David,

I'd like to know how to do the cell with formula copy.

If you could post it, thanks,

Tom


----- Original Message -----
From: "Ankers, Dave (UK)" <Dave.Ankers@xxxxxxxxxxxxxx>
To: <jaws-uk@xxxxxxxxxxxxx>
Cc: "Brian Hartgen" <brian.hartgen@xxxxxxxxxxxxxxxxxxxxx>
Sent: Tuesday, December 04, 2007 8:54 AM
Subject: [jaws-uk] Re: Dragging cells containing formula, number or date
series in Excel


>
> All,
>
> thanks to everyone who has responded.  The Edit/Fill does indeed do as

> I wish.  Basically select the blank cell next to the cell with the 
> formula, press control+E for edit, Press I for fill, and if the cell 
> you want to copy the formula to is on the right of the cell containing

> the formula, press R for right.  Conversly if the cell you want to 
> copy the formula to is below the cell containing the fomula, press D 
> for down and vice versa.
> If you wish to copy a series across or down a spreadsheet, such as 1 2

> 3 etc type 1 2 3 in the first three cells, and select all the cells 
> you wish the series to fill, including the first three.  You can 
> easilly do this by selecting the first cell and pressing F8 to turn on

> selection mode, then use the arrow keys.  Then press control+E for 
> edit, I for fill, and then S for series.  Tab through the dialog box 
> and select Trend, and ensure either row or column, depending on which 
> one you want is selected and click ok, job done.  There are more 
> options I have to explore using the fill feature, and will save them
for another time.
> Hope that helps.
>
> Dave
>
> Dave:
>
> I have already seen a couple of answers on the list, but I think that 
> you may be talking about copying a cell with a formula in it down a 
> column or across a row to replicate that formula in either the column 
> or row - is this correct?
> If so, I will go through it with you.
>
> David
>
> Hi All,
>
> A useful feature in Excel, using a mouse, is left clicking on the 
> bottom right corner of a cell or range of selected cells that contain 
> a series of numbers, dates or formula and dragging them either down or

> across the spreadsheet.  This is very useful if the cells contain 
> formula, as the cell co-ordinates automatically change in the formula.

> Can this be done using the keyboard via JAWS keystrokes?
> Any help much appreciated.
>
> Dave
>
> ********************************************************************
> This email and any attachments are confidential to the intended 
> recipient and may also be privileged. If you are not the intended 
> recipient please delete it from your system and notify the sender.
> You should not copy it or use it for any purpose nor disclose or 
> distribute its contents to any other person.
> ********************************************************************
>
> ** To leave the list, click on the immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** jaws-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on the
> ** immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.503 / Virus Database: 269.16.13/1169 - Release Date: 
> 12/3/2007 22:56
>
> 

** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq


** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to 
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq

Other related posts: