Brian You may know this, and not the same thing but there is another useful function in Excel in 'paste special' to rotate a sheet, (columns and rows don't have to match), it's called transpose - used when you want to flip a spreadsheet, i.e. swap the column headers with the row labels and move the remainder of cells to match accordingly.
1. Be careful to select all the cells you want to change 2. Right click and select copy from the menu displayed 3. Decide where you want your results to appear, different area of the same sheet, but usually a fresh sheet 4. Select a cell which will become your new top left corner and right click it 5. This time select the transpose box from the menu, then OK and your modified sheet will appear 'transposed' Useful if you have been adding to a spreadsheet and suddenly realise you have gazillions of columns and relatively few rows and want to print portrait in A4, or display a spreadsheet in a report Richard M800RGN+8 ________________________________ From: Owen Jenkins <[email protected]> To: mogtalk2 <[email protected]> Sent: Saturday, 12 May 2012, 23:22 Subject: Re: [mogtalk2] Miscellany & NonMog, FAO C Shearing, Excel, Matrices Yes please. Cheers, Owen. >From:Brian Cowell [mailto:[email protected]] >Sent: 12 May 2012 22:30 >To: mogtalk2 >Subject: Re: [mogtalk2] Miscellany & NonMog, FAO C Shearing, Excel, Matrices > >Colin, Ray, Tim et al > >Thanks for all the inputs. > >We are off to Truro in the morning, with the caravan (without the Morgan) for >a fortnight. >So will investigate matrices when we get back. > >On another topic; I did an article 'The Apparent Speed of Wheels on TV' for >'Miscellany' that was not published. Would anyone like me to put it on here? > >Cheers, Brian >View posts on The Mail Archive >http://www.mail-archive.com/[email protected]/ >Modify Your Subscription >No virus found in this message. >Checked by AVG - www.avg.com >Version: 2012.0.2171 / Virus Database: 2425/4993 - Release Date: 05/12/12 View posts on The Mail Archive http://www.mail-archive.com/[email protected]/ Modify Your Subscription ------------------------------------------- View posts on The Mail Archive http://www.mail-archive.com/[email protected]/ [http://www.mail-archive.com/[email protected]/] Modify Your Subscription: https://www.listbox.com/member/?member_id=22459785&id_secret=22459785-4a39ddf8 Powered by Listbox: http://www.listbox.com
