Posted to microsoft.public.excel.programming

Richard[_27_] Richard[_27_] is offline

external usenet poster

Posts: 1

Change references ALL at once

Is there a way to select a group of cells and change all of the cell references from RELATIVE to
ABSOLUTE. I tried F4 but that just changes the cell format.

TIA,

Richard

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
Cannot change Series references	Robert Baer	Charts and Charting in Excel	4	April 20th 09 12:04 AM
change formula references from one tab to another	[email protected]	New Users to Excel	1	November 3rd 08 06:04 PM
Change tab a fomula references	Shoney	Excel Discussion (Misc queries)	2	February 14th 08 07:43 PM
How to change lookup references	Guy Yeakley	Excel Worksheet Functions	1	January 25th 06 02:24 PM
Code to change references	Steve[_27_]	Excel Programming	0	August 4th 03 11:43 PM

All times are GMT +1. The time now is 07:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us