 |
By (user no longer on site) OP
over a year ago
|
It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
|
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
" It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
"
Do you mean insert a new row and keep it under the title? Or do you want an equation to do the scoring for you? |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site) OP
over a year ago
|
"Right click one of the column letters, from the pop up menu click "insert colunn", then press Ctrl+Y 4 times."
I see what you mean but I want the top
Line to stay the same and 5 new rows to be inserted between the middle row. |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
"Right click one of the column letters, from the pop up menu click "insert colunn", then press Ctrl+Y 4 times."
If you want to keep the same title over the rows/columns click on the box and drag it over the new boxes then from the top click the merge button this will keep the title and centre it over the top of the new rows/columns |
Reply privately, Reply in forum +quote
or View forums list | |
|
By *emini ManMan
over a year ago
There and to the left a bit |
" It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
"
If I've understood correctly you have three columns with titles - but one of those columns you want to split into 5 but keep the title above all five of them?
If so create the five columns and then on Row A (which I am assuming is where you have the titles) merge the cells above the five columns into one |
Reply privately, Reply in forum +quote
or View forums list | |
|
By *emini ManMan
over a year ago
There and to the left a bit |
"Right click one of the column letters, from the pop up menu click "insert colunn", then press Ctrl+Y 4 times.
I see what you mean but I want the top
Line to stay the same and 5 new rows to be inserted between the middle row."
Need to be clear whether you mean rows (horizontal) or columns (vertical) here?
If per my last you want 7 columns total but three titles (with the middle title being over the 5 middle columns) then easiest way to do that would be start with 7 columns then merge the middle 5 on the top line. |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
" It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
If I've understood correctly you have three columns with titles - but one of those columns you want to split into 5 but keep the title above all five of them?
If so create the five columns and then on Row A (which I am assuming is where you have the titles) merge the cells above the five columns into one"
Quite possibly massively over complicated for what you are ever going to use this excel for, but merging cells is actually really bad practice if you want to use formula properly in a decent size excel sheet.
It prevents some functionality and using the the table function in excel, which is much better than standard data entry for excel. You can get a similar result of a shared heading without the downsides of merging,by selecting the cells you would have merged and formating cells, alignment, ‘centre across selection’. |
Reply privately, Reply in forum +quote
or View forums list | |
|
By *harpDressed ManMan
over a year ago
Here occasionally, but mostly somewhere else |
"Right click one of the column letters, from the pop up menu click "insert colunn", then press Ctrl+Y 4 times.
I see what you mean but I want the top
Line to stay the same and 5 new rows to be inserted between the middle row."
Then right click the middle row and do what I said...
|
Reply privately, Reply in forum +quote
or View forums list | |
|
By *emini ManMan
over a year ago
There and to the left a bit |
" It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
If I've understood correctly you have three columns with titles - but one of those columns you want to split into 5 but keep the title above all five of them?
If so create the five columns and then on Row A (which I am assuming is where you have the titles) merge the cells above the five columns into one
Quite possibly massively over complicated for what you are ever going to use this excel for, but merging cells is actually really bad practice if you want to use formula properly in a decent size excel sheet.
It prevents some functionality and using the the table function in excel, which is much better than standard data entry for excel. You can get a similar result of a shared heading without the downsides of merging,by selecting the cells you would have merged and formating cells, alignment, ‘centre across selection’."
Well I've learned something new - thanks for that  |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
" It’s hard to describe but here goes!
I have 3 cells/rows with titles but in the middle row I want to split it into 5 separate rows so scoring can be added ie1-5.
If I've understood correctly you have three columns with titles - but one of those columns you want to split into 5 but keep the title above all five of them?
If so create the five columns and then on Row A (which I am assuming is where you have the titles) merge the cells above the five columns into one
Quite possibly massively over complicated for what you are ever going to use this excel for, but merging cells is actually really bad practice if you want to use formula properly in a decent size excel sheet.
It prevents some functionality and using the the table function in excel, which is much better than standard data entry for excel. You can get a similar result of a shared heading without the downsides of merging,by selecting the cells you would have merged and formating cells, alignment, ‘centre across selection’.
Well I've learned something new - thanks for that "
More than welcome, my job involves a fair bit of excel....  |
Reply privately, Reply in forum +quote
or View forums list | |
» Add a new message to this topic
