Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
Ihave a small spreadsheet I created in a worksheet. I need to copy this
spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
If you want a character check box, click INSERT on the menu and select
SYMBOL. In the SYMBOLS dialog box, click the SYMBOLS tab if necessary and change the font to Wingdings 2. Locate character 82 in the displayed list of characters. The characters are sequentially ordered frmo left to right/top to bottom and the lower-left corner of the dialog box displays the font name followed by the character value. If you want real checkboxes right click on any toolbar and select CONTROL TOOLBOX. -- Kevin Backmann "oceanmist" wrote: Ihave a small spreadsheet I created in a worksheet. I need to copy this spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
Oops, I posted this to the wrong question. Please excuse...
-- Kevin Backmann "Kevin B" wrote: If you want a character check box, click INSERT on the menu and select SYMBOL. In the SYMBOLS dialog box, click the SYMBOLS tab if necessary and change the font to Wingdings 2. Locate character 82 in the displayed list of characters. The characters are sequentially ordered frmo left to right/top to bottom and the lower-left corner of the dialog box displays the font name followed by the character value. If you want real checkboxes right click on any toolbar and select CONTROL TOOLBOX. -- Kevin Backmann "oceanmist" wrote: Ihave a small spreadsheet I created in a worksheet. I need to copy this spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
Yes, you can copy a range and paste it down the spreadsheet. Just select the
range you want to copy, press Ctrl^C to copy the range to the clipboard, then select the range to copy it to and press Ctrl^V to paste the range into the area selected. However, you must be sure that the range you select to copy to is an even multiple of the rows that you are copying from. For instance, if you want to copy the range A1:D30 you could paste it into ranges like A1:D60 or A1:D300, but the paste will fail if you try to paste it into a range of A1:D61 or A1:D301. HTH, TK "oceanmist" wrote: Ihave a small spreadsheet I created in a worksheet. I need to copy this spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
so I have to go through these motions to copy it say, 30 times?
"T Kirtley" wrote: Yes, you can copy a range and paste it down the spreadsheet. Just select the range you want to copy, press Ctrl^C to copy the range to the clipboard, then select the range to copy it to and press Ctrl^V to paste the range into the area selected. However, you must be sure that the range you select to copy to is an even multiple of the rows that you are copying from. For instance, if you want to copy the range A1:D30 you could paste it into ranges like A1:D60 or A1:D300, but the paste will fail if you try to paste it into a range of A1:D61 or A1:D301. HTH, TK "oceanmist" wrote: Ihave a small spreadsheet I created in a worksheet. I need to copy this spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Copying Spreadsheet
Assuming data is in A1:F30
Right-click on A1. Drag across to F1 then drag down as far as you wish. i.e. down to row 300 Release button and select "Copy Cells" Gord Dibben MS Excel MVP On Tue, 19 Sep 2006 12:02:01 -0700, oceanmist wrote: Ihave a small spreadsheet I created in a worksheet. I need to copy this spreadsheet repeatedly down the spread sheet. For example, the form is 30 rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60 and row 61-90 and so on. Is there an easy way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) | |||
EXCEL 2003 VIEWER SPREADSHEET DIFFICULTY | Excel Discussion (Misc queries) | |||
Launching specific spreadsheet from Desktop in Excel 2003 | Excel Discussion (Misc queries) |