+ Reply to Thread
Results 1 to 2 of 2

Remove space which appears above the spreadsheet when copying from one sheet to another

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    Stratham, West Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Remove space which appears above the spreadsheet when copying from one sheet to another

    When copying data from one sheet to another, a blank space sometimes appears above the spreadsheet with the numbers 1 to 8 in a vertical array on the top left.
    How is this blank space removed?
    Thanks
    EddyWirbelstrom

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Remove space which appears above the spreadsheet when copying from one sheet to anothe

    Sounds as though the data has been grouped by column(s). Not sure why you wouldn't see it on the Source sheet but you can on the Target.

    Ctrl-8 hides and unhides Grouping/Outlining. If it is Grouping/Outlining, you can use Data | Ungroup to remove it.

+ 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] Remove duplicates when copying a row from one sheet to another
    By JTH2016 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-10-2016, 03:52 PM
  2. Replies: 8
    Last Post: 11-09-2013, 11:21 AM
  3. [SOLVED] How to remove empty space, unable to make pvot, because pvot calculate empty space
    By vengatvj in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 10-29-2013, 12:43 PM
  4. Remove Space between number and letter on excel spreadsheet
    By BowHunter09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:06 PM
  5. [SOLVED] If Cell Starts with a Space, remove that space
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 09-29-2012, 01:52 PM
  6. Copying chart from one sheet to another and remove links
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2012, 10:41 AM
  7. Copying Rows from a spreadsheet to a new spreadsheet if text appears
    By Fferjay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2011, 05:18 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