pivots

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivots

Pivots

resolvedResolved · Low Priority · Version 2007

Barbara has attended:
Excel Advanced course

Pivots

can i copy pivot table set ups x spreadsheets

RE: pivots

you can copy pivpt tables. Click on the top left corner which will highlight the table and use ctrl+C to copy. Paste using ctrl+V to paste it somewhere else. This will copy the data, it will no longer be a pivot table.


 

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips


Server loaded in 0.08 secs.