How to copy text to cells in same sheet.

September 14, 2010 at 09:09:52
Specs: Windows XP
I am trying to copy the text from cell E3 to H67 in Open Office spreadsheet. It is a registration form for our dance studio and I would prefer not to have to type in each student's name twice. Thanks.

See More: How to copy text to cells in same sheet.

Report •

#1
September 14, 2010 at 09:56:58
You could do something like:

In cell H67 put the formula

=E3

Then anything you type into cell E3 will be duplicated in cell H67,
But understand that if you make any changes to cell E3 then cell H67
will also change.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question