+ Reply to Thread
Results 1 to 3 of 3

Fill series (by dragging the handle) without formatting?

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    98

    Question Fill series (by dragging the handle) without formatting?

    Hi,

    I can only seem to drag the handle to "fill series" WHILST also inheriting the formatting. How can I fill series + no formatting?

    Thank!

    Z

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    16,011

    Re: Fill series (by dragging the handle) without formatting?

    Copy > right click > paste formulas (fX).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: Fill series (by dragging the handle) without formatting?

    Quote Originally Posted by AliGW View Post
    Copy > right click > paste formulas (fX).
    Thanks Ali, but that doesn't fill series (1,2,3,4 etc), but rather just copies the exact values (albeit without formatting)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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