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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks