+ Reply to Thread
Results 1 to 2 of 2

Is there an easy way to lock all formulas to the specific cell?

  1. #1
    Forum Contributor
    Join Date
    07-16-2008
    Location
    USA
    Posts
    142

    Is there an easy way to lock all formulas to the specific cell?

    Is there a way to lock all formulas to the specific cell easily on a sheet? For example:

    A1 = $A$1
    B2 = $B$2

    Instead of doing each one manually or using the edit/replace function, is there any other way of doing this that will apply the $ to all formulas within a sheet?

    Thanks.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,791

    Re: Is there an easy way to lock all formulas to the specific cell?

    A macro like this could do it

    Please Login or Register  to view this content.
    Alf

    Ps You should add Office version in you profile as answers can differ based on this.
    Last edited by Alf; 09-12-2013 at 07:39 AM. Reason: Better code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I have to lock specific cells whch contains formulas.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 11-12-2012, 08:03 AM
  2. Replies: 0
    Last Post: 07-03-2012, 05:42 AM
  3. lock cell reference in formulas
    By jayne1986 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-03-2009, 08:41 AM
  4. Lock fill colour to specific cell
    By mattsson_karl in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-27-2008, 11:09 AM
  5. [SOLVED] How do I lock cell formulas???
    By John - Menifee, CA in forum Excel General
    Replies: 2
    Last Post: 05-15-2006, 07:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1