|
Related Topics:
| Preventing Duplicate Entries Across Sheets - Anyone know how to prevent duplicate entries of numbers. e.g. I have two sheets. I want to make sure that the same number is not entered more than once. Thank you.
Easiest way to remove duplicate items or compare lists - I have recently purchased the assets of a failing company. Now I have a bunch of customer lists in several different Most of the lists are in paper format some customers are in the database as well. I am using excel to sort out..
Excel Macro Problem - I just upgraded my Mac to Office 2004. I am trying to open some older Excel files that were created on a PC that have Macros in them. The opened fine in Office X. They open fine but when I close the Excel file it says the Excel has quit. It..
unicode characters - read only error ? - Using an Excel 2001 file across a Mac network under OS 9. Getting the following error from networked users: file has unicode charaters that could not be converted to the active codepage. Since some data has been lost, the workbook is being marked..
Consecutive numbering - numbering (Excel: mac 2001 but will also have to run on PC 2000) Entries in C2 (starting at a row, in this instance R11) are numbered (1, 2, 3, 4, etc) in C1 I generate the numbers manually by typing..
|
|
|
Next: Is there a way to get custom fill colors for tabl..
|
| Author |
Message |
External
Since: Feb 04, 2008
Posts: 46
|
(Msg. 1) Posted: Wed Feb 20, 2008 8:47 pm
Post subject: Can I duplicate a row?
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Feb 11, 2005
Posts: 579
|
(Msg. 2) Posted: Thu Feb 21, 2008 8:36 am
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 2/20/08 11:47 PM, in article ee8e3d8.-1.RemoveThis@webcrossing.caR9absDaxw,
"kevs1@officeformac.com" <kevs1.RemoveThis@officeformac.com> wrote:
> Currently, I insert a row, then copy and paste. Cumbersome. Anyway to
> duplicate a row? thanks.
>
> Kevs
> OFFICE 2004
> MAC OS 10.4.11
What if you copy the row, and then select copied cells from the insert menu?
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom |
|
| Back to top |
|
| |
External
Since: Jan 30, 2007
Posts: 17
|
(Msg. 3) Posted: Thu Feb 21, 2008 9:29 am
Post subject: RE: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Kevs -
I'd sure like to know what type of work you do...
99.9% of the questions on this type of issue are from people looking to
*remove* duplication & you're looking for an easier way to *generate* same:-)
Regards |:>)
Bob Jones
[MVP] Office:Mac
"kevs1@officeformac.com" wrote:
> Currently, I insert a row, then copy and paste. Cumbersome. Anyway to duplicate a row? thanks.
>
> Kevs
> OFFICE 2004
> MAC OS 10.4.11
> >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
External
Since: Feb 04, 2008
Posts: 46
|
(Msg. 4) Posted: Thu Feb 21, 2008 12:56 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Excellent Bob 1 (Greenberg) that did it.
Bob 2 Jones, I do photography and have workbooks with names. Actually this case was instance of a music file with CD's that are spread out over different casstte tapes. Hence need for same row, except with one differnt entry in one column. >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
External
Since: Feb 11, 2005
Posts: 579
|
(Msg. 5) Posted: Thu Feb 21, 2008 4:14 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 2/21/08 3:56 PM, in article ee8e3d8.2 RemoveThis @webcrossing.caR9absDaxw,
"kevs1@officeformac.com" <kevs1 RemoveThis @officeformac.com> wrote:
> Excellent Bob 1 (Greenberg) that did it.
>
> Bob 2 Jones, I do photography and have workbooks with names. Actually this
> case was instance of a music file with CD's that are spread out over different
> casstte tapes. Hence need for same row, except with one differnt entry in one
> column.
You are welcome. I guess I am now Bob 1 Greenberg.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
External
Since: Feb 04, 2008
Posts: 46
|
(Msg. 6) Posted: Thu Feb 21, 2008 4:41 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 04, 2008
Posts: 46
|
(Msg. 7) Posted: Sat Feb 23, 2008 4:28 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jul 20, 2005
Posts: 1758
|
(Msg. 8) Posted: Sun Feb 24, 2008 9:03 am
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
No - Just select the cells in the number of consecutive rows before you
paste.
Good Luck |:>)
Bob Jones
[MVP] Office:Mac
On 2/23/08 7:28 PM, in article ee8e3d8.5 RemoveThis @webcrossing.caR9absDaxw,
"kevs1@officeformac.com" <kevs1 RemoveThis @officeformac.com> wrote:
> New discovery Bob:
> The insert copied cells goes away after one pass.
>
> So if I want to duplicate the row 4 times, I have to deselect and do the copy
> 4 times. any ideas? thanks. >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
External
Since: Feb 04, 2008
Posts: 46
|
(Msg. 9) Posted: Sun Feb 24, 2008 12:21 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Bob J
think you misunderstood.
I want to basically duplicate one row 4 times, lets say,
So I copy the row,
then
insert copied cells, and that copies once,
the I go back to the view menu to do it again, but now copies cells is gone. >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
External
Since: Jul 20, 2005
Posts: 1758
|
(Msg. 10) Posted: Sun Feb 24, 2008 3:48 pm
Post subject: Re: Can I duplicate a row? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
No, you misunderstood:-)
If the content is in A17:F17 select & copy as usual. If you want to
duplicate the content into cells A25:F30 select that range of cells before
doing your Insert Copied Cells command.
If you actually meant you want to go from one row to another separate,
non-contiguous row & repeatedly use Insert Copied Cells then No, you can't
do that. The only suggestion I can offer is to use the regular Paste command
instead instead - once you copy, select the first cells to paste into, them
use Control+I followed by return followed by Command+V & repeat the process
in as many distinct locations as necessary. (IOW, Insert Copied Cells isn't
as directly related to Paste as it would seem.)
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 2/24/08 3:21 PM, in article ee8e3d8.7 DeleteThis @webcrossing.caR9absDaxw,
"kevs1@officeformac.com" <kevs1 DeleteThis @officeformac.com> wrote:
> Bob J
> think you misunderstood.
> I want to basically duplicate one row 4 times, lets say,
>
> So I copy the row,
> then
> insert copied cells, and that copies once,
> the I go back to the view menu to do it again, but now copies cells is gone. >> Stay informed about: Can I duplicate a row? |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in
