+ Reply to Thread
Results 1 to 4 of 4

Move to the top or bottom of a column which has blank cells in

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Swindon, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Move to the top or bottom of a column which has blank cells in

    Hopefully I'm being a little dim here, but I'm having trouble moving to the top or bottom of a long column of numbers because there are gaps in there.

    Is there an easy way to do this, either with a keyboard shortcut, menu selection or vba? Ctrl + Arrow Key only moves to the top or bottom of the range, not the whole column.

    Thanks in advance.
    Last edited by Impos2004; 07-31-2013 at 09:37 AM.

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Move to the top or bottom of a column which has blank cells in

    as far as moving to the top or bottom of a column that has spaces, the best that i know is just to hold down ctrl+arrow and keep it held till you get to the bottom. Ctrl+home will bring you to cell A1 and ctrl end will bring you to the farthest right and farthest bottom you have filled in on your worksheet. you could write a simple macro to do this for you and prgram it to be a shortcut key stroke though.
    Regards,
    amotto

    If I helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Morgantown, West Virginia, United States
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Move to the top or bottom of a column which has blank cells in

    What I do is scroll (using the scroll bar, for speed) to below the bottom of the column's filled-in values, then ctrl+up arrow to get to the end of the last range. Vice versa for the top of the column. Otherwise, if you have an adjacent column that is fully filled, you can always navigate to the top/bottom of that column and just arrow over one column.

  4. #4
    Registered User
    Join Date
    06-10-2013
    Location
    Swindon, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Move to the top or bottom of a column which has blank cells in

    The full details are as follows....

    A have a range of field headings from A1 to AA1, down the right hand side (column AB) I have a 60199 customer numbers (though this is dynamic). In this table, under the headings there are a "random" assortment of numbers.

    In another worksheet, I would like to list the customer numbers in column A, and next to each one indicate the heading of each of the columns where one of the "random" numbers ocurred.

    e.g. workbook 1

    Heading 1 _____Heading 2_____ Heading 3 _______Customer Number
    4 ___________________________2345 __________00045671
    2342____________ 5 _________________________00045672
    _______________345345 ________54 ___________00045673

    e.g. workbook 2

    Customer Number
    00045671 Heading 1 Heading 3
    00045672 Heading 1 Heading 2
    00045673 Heading 2 Heading 3

    I can use an Index Match or something to identify the "random" numbers with no trouble, but I don't actually want those, I need the heading name above the "random" number to be returned.
    Last edited by Impos2004; 07-31-2013 at 10:44 AM.

+ 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] Auto highlight cells in a column and move it to the bottom of another cell with a macro?
    By L2012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2012, 07:44 AM
  2. Replies: 2
    Last Post: 09-10-2012, 03:02 AM
  3. Add exception for blank cells/move new data to bottom of sheet
    By MATT-C in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2010, 09:58 AM
  4. [SOLVED] Move to bottom of Column
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2005, 02:40 PM
  5. Shortcut to move to bottom (last) cell in a column
    By Frustrated in forum Excel General
    Replies: 1
    Last Post: 09-20-2005, 11:05 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