I have a large spreadsheet, and I want to split it up to varios pages- no problemThe problems start as the pages are formatted- different widths,heights etc (no graphs).When I copy a section and try to paste it to a new page or a new spreadsheet, the data copies OK, but the formats do not.I have tries varios paste specials and none of them seem to work to what I want.Any suggestionsTerry
Try pasting then click in the area you copied from, click the Format Painter (paintbrush icon) then select your pasted area.
I tried VoG's suggestion and some formats copied but column widths did not. (I use an older version of Excel so that could be an issue).You could just copy the whole spreadsheet to a new worksheet and delete the rows and columns which are not required. Might be tedious if you are splitting into many pages.
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.