LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sabrina
 
Posts: n/a
Default How can I use fill hand to copy the fomula in this case?

Here is my fomula:
B1: =sheet2!A1
B2: =sheet2!A4
B3: =sheet2!A7
B4: =sheet2!A11
.........

Is it possible to use fill handle to copy the fomula automatically in my
case?, If so, how? Thanks.

Sabrina


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The fill feature in Excel that gives option to fill or copy KAHelman New Users to Excel 1 July 29th 05 07:47 PM
To copy fomula jojo Excel Worksheet Functions 7 July 21st 05 07:45 PM
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM
Set default in auto fill options, I always want to copy cell, som. OSHAman Excel Discussion (Misc queries) 2 March 25th 05 11:22 PM
3-d reference not adjusting when using Fill Handle to copy down gall Excel Worksheet Functions 3 November 24th 04 06:42 PM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"