If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple cell merging?
Is it possible to do multiple cell merging in a number of rows. EG. I want to
merge 3 cells across columns B C & D. But do this for 30 rows. Is there somewhere in Formatt where I can do this for 30 rows without losing all the border lines for all 30 rows? Or do I just have to formatt each section in each row? Thankyou your tips will be appreciated.. |
#2
|
|||
|
|||
multiple cell merging?
Think we could merge 1 row first, say B11, and format it to taste.
Then just select B11 and click the format painter icon (brush) to copy the format. Then "paint" the format by selecting B230 B230 will be similarly formatted as B11 at one go. The above said and done, a much better way is to avoid merging cells where possible. If we want to center headers across columns, say center the header in B1 across B11, we could select B11, click Format Cells Alignment tab, then select "Center across Selection" from the droplist under "Text alignment" Horizontal, and click OK. This would also provide the same desired visual, but w/o having to merge the cells. Using merge cells is known to cause inconveniences / difficulties downstream. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Coops" wrote in message ... Is it possible to do multiple cell merging in a number of rows. EG. I want to merge 3 cells across columns B C & D. But do this for 30 rows. Is there somewhere in Formatt where I can do this for 30 rows without losing all the border lines for all 30 rows? Or do I just have to formatt each section in each row? Thankyou your tips will be appreciated.. |
#3
|
|||
|
|||
multiple cell merging?
Thankyou Max.. Merry Xmas too you!!
Coops "Max" wrote: Think we could merge 1 row first, say B11, and format it to taste. Then just select B11 and click the format painter icon (brush) to copy the format. Then "paint" the format by selecting B230 B230 will be similarly formatted as B11 at one go. The above said and done, a much better way is to avoid merging cells where possible. If we want to center headers across columns, say center the header in B1 across B11, we could select B11, click Format Cells Alignment tab, then select "Center across Selection" from the droplist under "Text alignment" Horizontal, and click OK. This would also provide the same desired visual, but w/o having to merge the cells. Using merge cells is known to cause inconveniences / difficulties downstream. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Coops" wrote in message ... Is it possible to do multiple cell merging in a number of rows. EG. I want to merge 3 cells across columns B C & D. But do this for 30 rows. Is there somewhere in Formatt where I can do this for 30 rows without losing all the border lines for all 30 rows? Or do I just have to formatt each section in each row? Thankyou your tips will be appreciated.. |
#4
|
|||
|
|||
multiple cell merging?
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Coops" wrote in message ... Thankyou Max.. Merry Xmas to you!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter: Multiple values in a cell | pandora | General Discussion | 1 | December 6th, 2005 07:03 AM |
a unique cell value returns multiple cell values from another shee | grflded | Worksheet Functions | 0 | September 25th, 2005 04:21 AM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Can multiple cell results be displayed in a single cell? | FuadsCurse | General Discussion | 2 | May 18th, 2005 05:33 PM |
Combining data (numeric format) in multiple cells into one cell (t | GNAC SID | General Discussion | 2 | February 7th, 2005 04:09 PM |