Well, If I were starting from scratch, before entering any monthly data, I would either; • Format, create the formulas, set the layout specs, etc. For the first sheet, then use Jim's Move or Copy suggestion to generate the 2nd sheet. Use Command+Y to repeat the action for each additional sheet, or • After creating the first sheet, hold the Option key while dragging the sheet tab to the right to duplicate the sheet -- release the mouse button & Option key when the pointer shows a 'page' icon, then use Command+Y to repeat the operation for each additional sheet, or • Generate the 12 blank sheets, select all 12, then apply the formatting & set the layout specs, etc. It would then be just a matter of naming the sheet tabs & adding anything specific to each of the 12 sheets. In an existing workbook, either of the first 2 approaches will work. Your current method does not give the desired result because when you copy only the content & formatting of the cells is copied. The standard Copy command does not pick up such things as Layout, Print & other Page Setup [Headers/Footers, Orientation, etc.] specifications of the sheet being copied.

Also, if you just want values you can copy the sheet select all - copy - paste special - values to have values only. If you want to do it all during the copy rather than rely on the end user to perform those steps, well, I've been working on that. The simplest workaround I found was to copy the rows or cells you want from the one workbook, then paste them in a new blank sheet of the workbook you want to ultimately insert them into, the re-copy them from that new sheet, right-click the location you want to insert them on the worksheet, and the 'Insert copied cells' option should now show up. Windows 10 for mac free.

Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J. How to print on both sides for mac.

To fulfill this step with a keyboard shortcut, check out. There are two options that I am aware of and both (unfortunately) require two steps.

Option 1 • With a single cell selected, hit Shift + Space to select the row. • Hit Control + Shift + + (Plus Sign) to insert a row above the current row. Option 2 • With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row. • Hit Enter to accept the default of Shift Cells Down.

If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row. This inserts a new empty row. To copy the row, you just need to hit Ctrl+ C between the steps one and two.

This way the content gets automatically pasted after step two. So, this option works great, but only if you're working within the same workbook. I ended up here because the 'Insert copied cells' option does not exist if you're trying to paste rows/cells from another workbook. The simplest workaround I found was to copy the rows or cells you want from the one workbook, then paste them in a new blank sheet of the workbook you want to ultimately insert them into, the re-copy them from that new sheet, right-click the location you want to insert them on the worksheet, and the 'Insert copied cells' option should now show up. Choose that, and you're done!