+ Reply to Thread
Results 1 to 3 of 3

How to drag formula without changing format

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Georgia, United States
    MS-Off Ver
    MS Office 2013
    Posts
    12

    How to drag formula without changing format

    Hi guys,

    First off, thank you for all who respond to my posts! This community has been very helpful in helping me navigate through this powerful program.

    Anyways, is there anyway to drag a formula without changing the format of the cells? I have been using the CTRL+R (or D if its down) function which is useful, but changes the cell formats. I know that you can drag the formula from the bottom right of the cell, then click "fill without formatting" from the dropdown box. However, this is annoying. Is there anyway to do what I am asking?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: How to drag formula without changing format

    Use the right-click button on the fill handle when dragging down and then release and press "Fill Without Formatting" - only way i know of through the UI.


    Thanks
    Last edited by LukeGilfoyle; 05-17-2017 at 10:45 AM.
    If myself or others have helped, please add to our reputation by pressing the 'Star' icon below this.

  3. #3
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: How to drag formula without changing format

    If you want to use VBA then you can try this added to a button

    Sub Test()
    Range("A2").Select
    Range("A2,A" & Range("B65536").End(xlUp).Row).FormulaR1C1 = "=RIGHT(RC[5],7)"
    End Sub

    This will apply the formatting to all cells in Column A where there is data.

    Let me know

+ 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] Changing US date format to UK format - using a formula
    By menolas in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 10-27-2016, 07:07 AM
  2. Drag formula down without changing one of the references
    By twisted31 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2013, 07:31 PM
  3. drag offset formula with out changing values
    By cool_anu4u in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2013, 11:32 AM
  4. How do I click and drag a formula changing only 1 value?
    By scottghansen79 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-25-2010, 07:34 PM
  5. Replies: 3
    Last Post: 06-30-2010, 09:55 PM
  6. What a drag - changing the formula
    By KJG67 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2007, 12:56 AM
  7. Replies: 4
    Last Post: 09-29-2006, 01:51 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