+ Reply to Thread
Results 1 to 4 of 4

how to copy and past to the bottom of a spread with gaps

  1. #1
    Forum Contributor
    Join Date
    11-11-2010
    Location
    England
    MS-Off Ver
    Excel 2019
    Posts
    202

    how to copy and past to the bottom of a spread with gaps

    how to copy and past to the bottom of a spreadheet with gaps

    it has lots of gaps going down so whats the best way to highlight all the way to the bottom in one go?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: how to copy and past to the bottom of a spread with gaps

    Perhaps F5-Specal-Last Cell?

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: how to copy and past to the bottom of a spread with gaps

    Administrative note

    Still using XL2003 as indicated in your profile?
    If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
    Thanks

  4. #4
    Registered User
    Join Date
    04-05-2020
    Location
    Hannover, Germany
    MS-Off Ver
    MS Office 365
    Posts
    15

    Re: how to copy and past to the bottom of a spread with gaps

    Hi, I assume that you want to paste a formula/value in one column which has many gaps, you can try as follows:

    (1) make sure there is value in the last cell of that column
    (2) copy the formula/value that you want to paste
    (3) click the column you want to paste in (whole column)
    (4) press F5, click "special" in the left bottom, choose "Blanks", click "OK"
    ->then all the gaps in that column will be chosen
    (5) paste your formula/value

    Hope it works.

+ 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] Rows copying from bottom to top. need to copy top to bottom.
    By jafvortex93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2015, 02:07 PM
  2. Copy column with gaps
    By mrgson in forum Excel General
    Replies: 2
    Last Post: 05-09-2015, 11:59 AM
  3. Replies: 4
    Last Post: 02-19-2015, 12:37 AM
  4. Scroll to the bottom or top of range with gaps
    By labogola in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 12:27 PM
  5. Gant Chart with data spread past midnight
    By hcm in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-01-2013, 02:31 PM
  6. how to copy cells which gaps exist between?
    By Jared in forum Excel General
    Replies: 7
    Last Post: 07-27-2006, 10:21 AM
  7. [SOLVED] The word "calculate" is at the bottom of my spread sheet. why?
    By brooks o in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2006, 07:35 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