+ Reply to Thread
Results 1 to 7 of 7

How do I select (filter) a certain font size in Excel, so I can move it to different cells

  1. 12-22-2014, 03:52 PM #1
    Gene b
    Gene b is offline
    Registered User
    Join Date
    12-22-2014
    Location
    Midwest
    MS-Off Ver
    2007
    Posts
    5

    How do I select (filter) a certain font size in Excel, so I can move it to different cells

    I need to move only the cells that have the data in font size 16 from column B to column C. The other font sizes in column B are 11 and 12.
    How do I do that in a couple moves?
    I have over five thousand entries in that worksheet.
    Thanks!
    Reply With QuoteRegister To Reply
  2. 12-22-2014, 04:30 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    What do the 16 pt data have in common?
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 12-22-2014, 04:36 PM #3
    Gene b
    Gene b is offline
    Registered User
    Join Date
    12-22-2014
    Location
    Midwest
    MS-Off Ver
    2007
    Posts
    5

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    Dates
    I.e. Birth dates
    Reply With QuoteRegister To Reply
  4. 12-22-2014, 04:42 PM #4
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    Select column B copy and paste in column C. Click on Find, click on Format and choose 11. Click on Find All. Ctrl + A to select all that was found. Click the X to close the dialogue. Hit DELETE. Reselect column C and click on Find, click on Format and choose 12. Click on Find All. Ctrl+A to all that was found. Click the X to close the dialogue. Hit DELETE.....done!
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  5. 12-22-2014, 04:53 PM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    you can call =GET.CELL() using name manager in an xlsm workbook
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  6. 01-03-2015, 03:07 PM #6
    Gene b
    Gene b is offline
    Registered User
    Join Date
    12-22-2014
    Location
    Midwest
    MS-Off Ver
    2007
    Posts
    5

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    Thanks a Lot for your help!!
    Reply With QuoteRegister To Reply
  7. 01-03-2015, 03:27 PM #7
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How do I select (filter) a certain font size in Excel, so I can move it to different c

    Thank you for the feedback.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move and size with cells greyed out- form control checkboxes move after printing 2010
    By Duffy1974 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2012, 09:19 AM
  2. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  3. [SOLVED] Unable to copy the source formatting (border, font size, font colour, merger of cells etc.
    By Jeetu_pa84 in forum Excel General
    Replies: 15
    Last Post: 05-31-2012, 10:34 AM
  4. Changing the font size in a filter drop down.
    By Ray Joos in forum Excel General
    Replies: 2
    Last Post: 12-12-2008, 01:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1