Posted to microsoft.public.excel.worksheet.functions

Shvraka

external usenet poster

Posts: 4

How to change step in formula

I would like to apply this formula to several cells in sheet:

=Sheet2!A1+Sheet3!A1

When I copy this formula to the next cell below it I would like it to show:
=Sheet2!A7+Sheet3!A7

next cell would be:

=Sheet2!A13+Sheet3!A13

BUT when i drag the fill handle it does not follow the step (6) I gave it to
follow?!

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
I Need a formula to evaluate a cell with + or - values	Bob in Oklahoma	Excel Worksheet Functions	6	October 31st 05 02:41 PM
Change formula to Indirect	Ronbo	Excel Worksheet Functions	3	October 10th 05 07:33 PM
Cannot change a formula	Richard F	Excel Discussion (Misc queries)	1	January 18th 05 01:57 AM

All times are GMT +1. The time now is 05:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us