FabSwingers.com mobile

Join us FREE, we're FREE to use

Web's largest swingers site since 2006.

Already registered?
Login here

Back to forum list
Back to The Lounge

Excel help

Jump to newest
 

By (user no longer on site) OP   
over a year ago

Can someone help me with a simple excel issue please

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Depending what it is i can try

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Possibly

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Go on then OP what’s the problem?

Reply privatelyReply in forumReply +quote
 

By *emini ManMan
over a year ago

There and to the left a bit

All ears - have a fair grasp of simple excel

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Ooooooooo proper geek talk

Reply privatelyReply in forumReply +quote
 

By *emini ManMan
over a year ago

There and to the left a bit


"Ooooooooo proper geek talk "

Pivot table

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Most Probably, but google and YouTube are probably your best friend on what ever it is.

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago


"Ooooooooo proper geek talk

Pivot table "

Damn... semi time

Reply privatelyReply in forumReply +quote
 

By *alandNitaCouple
over a year ago

Scunthorpe


"Can someone help me with a simple excel issue please "

Are you going to tell us what it is?

Cal

Reply privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

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.

Reply privatelyReply in forumReply +quote
 

By *harpDressed ManMan
over a year ago

Here occasionally, but mostly somewhere else

Sorry, replace column with row

Reply privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

By *layfullsamMan
over a year ago

Solihull

[Removed by poster at 05/01/19 11:00:41]

Reply privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

PC World is your friend

Reply privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

By (user no longer on site)
over a year ago

Does your boss want this on his desk first thing Monday morning?

Reply privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

By *harpDressed ManMan
over a year ago

Here occasionally, but mostly somewhere else

[Removed by poster at 05/01/19 11:07:25]

Reply privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

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 privatelyReply in forumReply +quote
 

By (user no longer on site) OP   
over a year ago

And the excel problem solver was Big Jd my guys a legend thank you Big Jd and everyone who’s actually tried to help.

Reply privatelyReply in forumReply +quote
 
 

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 privatelyReply in forumReply +quote
Post new Message to Thread
back to top