Can you "Group" Cells?? Need a little Help!

  • Thread starter Thread starter modicon2
  • Start date Start date
M

modicon2

Can anybody tell me if you can "Group" cells?
I have got a row or 3 rows depending on which column your looking a
(some columns have the 3 rows of cells merged into one cell). I wan
to make all the cells in this row grouped together so they can b
easily copied/paste by one click (selecting the "grouped" row).

I've created a list that people will be able to add to. I've locke
the cells that I don't want them to have access to, but they need to b
able to copy last row down so they can enter their information. I wan
to make the copy process as idiot proof as possible.
Perfer that they can click once on the row (which selects all cells
and select copy / then paste on the next blank row and all of th
formats (in particular - row height) are also copied below.

Anyhelp, would be greatly appreciated!
Thank
 
Suggest that you use a "named range" for this.

By grouping, if you really mean "merging", is not a good idea.

Simply select all the pertinent cells, and then click in the name box.
Type in a short, easy to recall name (such as grp1, or grp2), and then hit
<Enter>.

Now, when it comes time to perform a copy, just click the little arrow in
the name box, and click on the desired name, and all the cells are selected,
ready for copying.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Can anybody tell me if you can "Group" cells?
I have got a row or 3 rows depending on which column your looking at
(some columns have the 3 rows of cells merged into one cell). I want
to make all the cells in this row grouped together so they can be
easily copied/paste by one click (selecting the "grouped" row).

I've created a list that people will be able to add to. I've locked
the cells that I don't want them to have access to, but they need to be
able to copy last row down so they can enter their information. I want
to make the copy process as idiot proof as possible.
Perfer that they can click once on the row (which selects all cells)
and select copy / then paste on the next blank row and all of the
formats (in particular - row height) are also copied below.

Anyhelp, would be greatly appreciated!
Thanks
 
Have you considered Data / Form - You need to be inside the table, or name the
table Database, and the name will be automatically extended to cover the new
rows. You can then hit data / Form from anywhere on that sheet. Just hit new
on the dialog box and all they have to fill in are the constants - Formulas will
be done automatically.
 
Not sure if it matches your needed but try the Merge tool (white icon with
<-a->). Select the cells to be merges, click the tool. In XL2002/2003
re-click to unmerge. As always, make a backup of file before experimenting.
Bernard
 
Thanks for the reply Ken,

I've never used the Data/Form but it looks interesting.
It will not let you data/form on a merged cell.
See attached xls.file The Title Description column needs to be 3
seperate cells to keep the text nice&neat. Maybe there is a way to
enter the text with wordwrap=on that will sepearate Title1 & Title2 &
Title3.

Can You create a cell that will call the data/form up automoatically
(kindof like a pushbutton)?

Thanks,
Again

Attachment filename: forumpost.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=412944
 
Type Title1 then hit ALT + ENTER to get a line feed.

Type Title2 then hit ALT + ENTER to get another line feed.

Type Title3 and ENTER.

Set the cell for word-wrap and centered text.

Gord Dibben Excel MVP
 
Another neat tip, but I need to make the sheet as user input friendly as
possible. I'm afraid that most people entering information want hit
the "alt + enter".

I may have to modify my sheet so that I don't have any merged cells.
It just seems to make the data easier to read, that why I originally
created it with the merged cells.


Thanks Again
 
Have you tried:
<Format> <Cells> <Alignment> tab,
And in the "Horizontal Window", scroll down to
"Center Across Selection" ?
This will give *exactly* the same appearance to text entered into "Merged"
cells, without all the problems connected with "Merged" cells.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Another neat tip, but I need to make the sheet as user input friendly as
possible. I'm afraid that most people entering information want hit
the "alt + enter".

I may have to modify my sheet so that I don't have any merged cells.
It just seems to make the data easier to read, that why I originally
created it with the merged cells.


Thanks Again
 
I love this site! Another cool tip that I didn't know about.
This works good for text spacing in different columns but my tex
problem is in the same column.

I'd like to have one "row" of information but one of the cells wil
have 3 lines of text.

_______________________________________
Item | Description |
------------------------------------------------------------
| Title1 |
1 | Title2 |
| Title3 |
--------------------------------------------------------

I want to create a row that an user can input the 3 titles and the
will seperate them on their own line.

I realize my diagram doesn't look anything like I meant for it to, bu
it's the best I can do.

thanks agai
 
I never claimed to be overly bright, but I don't see your problem.
The way you've designed your sheet looks fine.

Unmerge all your cells, then simply enter the data for columns A:E in row 5
!
Eliminate the cell borders, and the appearance is the same as merged cells.

Let the user enter the data in F4 & F5 & F6 in the normal way.

What am I missing ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


I love this site! Another cool tip that I didn't know about.
This works good for text spacing in different columns but my text
problem is in the same column.

I'd like to have one "row" of information but one of the cells will
have 3 lines of text.

_______________________________________
Item | Description |
------------------------------------------------------------
| Title1 |
1 | Title2 |
| Title3 |
--------------------------------------------------------

I want to create a row that an user can input the 3 titles and they
will seperate them on their own line.

I realize my diagram doesn't look anything like I meant for it to, but
it's the best I can do.

thanks again
 
And just for the record, if it can be avoided, I will never ever ever ever ever
ever ever ever ever ever ever ever use merged cells. They are the biggest PITA
that I can think of. <Gets off soapbox> :-)

Re the button:-

Sub ShowDataForm()
ActiveSheet.ShowDataForm
End Sub

and just assign to a button.
 
Back
Top