#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default cell references

Another way is to highlight the cells with formulae in and do CTRL-H
(Find & Replace):

Find What?: a15
Replace With: a17

then click Replace All. You can repeat this for other formulae which
might have different cell references.

Hope this helps.

Pete

Reply
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
Excel insits that I use absolute cell references Espen Excel Discussion (Misc queries) 6 January 5th 17 05:47 AM
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
how do i copy a formula when cell references r not together jon104 New Users to Excel 1 January 9th 06 03:25 PM
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM
Absolute cell references and subsequent problems. Pank Mehta Excel Discussion (Misc queries) 2 April 19th 05 11:38 AM


All times are GMT +1. The time now is 02:00 PM.

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

About Us

"It's about Microsoft Excel"