+ Reply to Thread
Results 1 to 4 of 4

Move DATA FILTER ARROW below cell text

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Hawaii
    MS-Off Ver
    2010, 2015, 365
    Posts
    8

    Move DATA FILTER ARROW below cell text

    I would like to move the filter arrow in a data list from the right of the text in the header to below the text. Is there a way to reformat the header so that the arrow is on a separate line?

    I'd like to avoid having the header text cut-off.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Move DATA FILTER ARROW below cell text

    I know of no way to do that, but if you try selecting the headers, click Home. Go to the cells group and select Format. From the drop down select Column width. You might need to experiment with values. 20 often works for me.

    It moves the drop down arrow further to the right.
    Dave

  3. #3
    Forum Contributor
    Join Date
    08-09-2012
    Location
    British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Move DATA FILTER ARROW below cell text

    I also don't like the drop down arrow covering part of the header.
    The arrow always appears in the lower right of the cells.
    I increase the height of the row and position the text at the top of the cells.

  4. #4
    Registered User
    Join Date
    06-20-2016
    Location
    Hawaii
    MS-Off Ver
    2010, 2015, 365
    Posts
    8

    Re: Move DATA FILTER ARROW below cell text

    Thanks NoSparks!

    This is simple and (now that you've given the advice) obvious solution. Great suggestion. Thank you for taking the time to review my post and send a reply. Much appreciated.

+ 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. Arrow Keys Move Window Not Cell
    By TOADSTOOL in forum Excel General
    Replies: 5
    Last Post: 01-25-2012, 02:19 PM
  2. Arrow Buttons move the whole page not to next cell
    By redsback55 in forum Excel General
    Replies: 1
    Last Post: 07-29-2010, 01:34 PM
  3. Replies: 6
    Last Post: 11-04-2008, 10:19 AM
  4. Replies: 1
    Last Post: 06-16-2008, 09:21 AM
  5. Can't move selected cell with arrow keys
    By madsett in forum Excel General
    Replies: 2
    Last Post: 10-26-2006, 04:30 PM
  6. [SOLVED] Arrow keys to move cell
    By Richard in forum Excel General
    Replies: 2
    Last Post: 05-01-2006, 05:25 AM
  7. [SOLVED] How can I move the active cell in Excel with the arrow keys?
    By Chuck T in forum Excel General
    Replies: 3
    Last Post: 12-12-2005, 11:45 AM
  8. [SOLVED] Selecing cntrl + arrow key to move to next populated cell
    By Craig in forum Excel General
    Replies: 2
    Last Post: 10-25-2005, 04:05 PM

Tags for this Thread

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