Excel (1 Viewer)

Otis · Jan 14, 2021

Anyone know an easy way to find the dead centre of an Excel spreadsheet, so the one A4 page will then print out as two A4 pages, thus making an A3 printout.

That make sense?

I have a spreadsheet. Currently A4, but want to split it in two, so it is symmetrical and will print out as two halves, that when pushed together, will be one A3 sheet.

Is there a simple way?

Otis · Jan 14, 2021

I can copy the sheet to another sheet.

Columns are all.different widths so I can't be arsed to try and work it out.

Is there an instant way to split it in two, dead down the centre?

Otis · Jan 14, 2021

Googling just seems to conjure up only answers of centering cells and text.

Otis · Jan 14, 2021

It's Excel 2019. Should have mentioned that.

fernandopartridge · Jan 14, 2021

how many rows / columns?

Otis · Jan 14, 2021

12 columns, 12 rows.

Otis · Jan 14, 2021

Differing widths and lengths though

Doing it by trial and error at the moment.

Otis · Jan 14, 2021

Using print preview and widening columns and rows to try and find the dead centre that way.

Otis · Jan 14, 2021

I think I have actually cracked it the long way round.

Otis · Jan 14, 2021

Just thought there might be a "go to the dead centre" of the sheet.

fernandopartridge · Jan 14, 2021

can't you just do a 'set print area' on 6 x 12 rows and make it print a4

Houchens Head · Jan 14, 2021

Pixel count and divide by two. It'll take days but hey, I'm no ~~mathmact~~ ~~mathmeshion~~ ~~mashmethician~~ adder-upper!

Otis · Jan 14, 2021

fernandopartridge said:
can't you just do a 'set print area' on 6 x 12 rows and make it print a4

I tried that. Couldn't remember how to manually enter the print area and I couldn't select it, as some of the rows were merged. Done it anyway. Cheers, Fernando. Thanks for the input.

rob9872 · Jan 14, 2021

If your only requirement is for a hard copy, then use two separate tabs and print individually then join them.

Otis · Jan 14, 2021

It's what J have done, Rob. I just wanted them an exact match if possible. Text goes across cells and I was trying to get it so looked pretty cool together or in two parts.

rob9872 · Jan 14, 2021

Otis said:
It's what J have done, Rob. I just wanted them an exact match if possible. Text goes across cells and I was trying to get it so looked pretty cool together or in two parts.

No probs if you're sorted, but if you need anything else PM me and I'll send you my email address so you can send files. If you let me know what you need I can sort during my 'working day' then ping it back to you.

Otis · Jan 14, 2021

Cheers. Much appreciated.

Liquid Gold · Jan 15, 2021

Click view then page layout, it will show exactly how the page is going too print

Otis · Jan 15, 2021

Liquid Gold said:
Click view then page layout, it will show exactly how the page is going too print

Yes, did that. I did work it out, but just wondered if there was an instant click.

Cheers anyway.

Liquid Gold · Jan 15, 2021

Otis said:
Yes, did that. I did work it out, but just wondered if there was an instant click.

Cheers anyway.

You could also do the page break and then marge and centre your cells.

Otis · Jan 15, 2021

Yes. Great

I used to be pretty good on Excel, but I am embarrassed to say, I haven't used it for over 25 years.

Liquid Gold · Jan 15, 2021

I use it every single day, feel like I live in it.

Kneeza · Jan 15, 2021

Otis said:
Yes. Great

I used to be pretty good on Excel, but I am embarrassed to say, I haven't used it for over 25 years.

I detest it. I used to be very proficient in both Word and Access, but it's all probably changed since I retired ten years ago.
Excel was always to be avoided by numeric dummies like me.

Houchens Head · Jan 15, 2021

Kneeza said:
I detest it. I used to be very proficient in both Word and Access, but it's all probably changed since I retired ten years ago.
Excel was always to be avoided by numeric dummies like me.

I use Word most days at home. But when I was working (oh happy days!) I worked at Rolls Royce, Ansty. They used their own system called SAP. Confusing as hell at first, but over the years I doddled it. So much so, that people who were supposed to be far more superior to me in the company, were phoning me in my office to ask how they do such and such in SAP. And these were people who were on probably twice my salary!

Kneeza · Jan 15, 2021

Houchens Head said:
I use Word most days at home. But when I was working (oh happy days!) I worked at Rolls Royce, Ansty. They used their own system called SAP. Confusing as hell at first, but over the years I doddled it. So much so, that people who were supposed to be far more superior to me in the company, were phoning me in my office to ask how they do such and such in SAP. And these were people who were on probably twice my salary!

Isn't that some kind of resource planning fibbertigib? I seem to recall it being used elsewhere. Don't think it's specific to Royce, although they probably had their own custom GUI.
Unless I'm goong even dafter...

Liquid Gold · Jan 15, 2021

I thought it was database software. I used it at a job for a while and they sponsored the pitch side advertising at Man City so match of the day always reminded me of work.

Kneeza · Jan 15, 2021

Liquid Gold said:
I thought it was database software. I used it at a job for a while and they sponsored the pitch side advertising at Man City so match of the day always reminded me of work.

Could be. Pretty sure it was commercially available.

Houchens Head · Jan 15, 2021

Kneeza said:
Isn't that some kind of resource planning fibbertigib? I seem to recall it being used elsewhere. Don't think it's specific to Royce, although they probably had their own custom GUI.
Unless I'm goong even dafter...

It may well have been commercially available. I just remember it as being used with all Rolls-Royce parts, sales etc, from a small washer to an RB211 engine. Nothing left the plant without going through me basically. I was in charge of about £35million of stock in the warehouse. I was connected to every Rolls-Royce plant world-wide, including Mount Vernon USA, Saudi Arabia, Baku in Azerbaijan, Australia, etc. Also energy plants throughout the world, e.g. gas pipelines, gas turbines.
.
My old computer screen at Ansty.......

Kneeza · Jan 15, 2021

Two of my uncles left the plant. Did you say they could?

Houchens Head · Jan 16, 2021

Kneeza said:
Two of my uncles left the plant. Did you say they could?

I remember those two nee'er-do-wells! They left with a flea in their ear, I can tell you!

Kneeza · Jan 16, 2021

Houchens Head said:
I remember those two nee'er-do-wells! They left with a flea in their ear, I can tell you!

They were great blokes, and sadly missed. One from Wolston and one from Leamington Hastings. Irreplaceable

shmmeee · Jan 18, 2021

Kneeza said:
Isn't that some kind of resource planning fibbertigib? I seem to recall it being used elsewhere. Don't think it's specific to Royce, although they probably had their own custom GUI.
Unless I'm goong even dafter...

SAP is a data analysis tool I think we did a lesson on it at uni (hilarious, we’d all finished and a week later the tutor emails us going “come in for a SAP lesson, I forgot to teach it to you and it’s pretty important”).

@Otis don’t use a spreadsheet package to do desktop publishing.

Otis · Jan 18, 2021

shmmeee said:
SAP is a data analysis tool I think we did a lesson on it at uni (hilarious, we’d all finished and a week later the tutor emails us going “come in for a SAP lesson, I forgot to teach it to you and it’s pretty important”).

@Otis don’t use a spreadsheet package to do desktop publishing.

It's just easier than Word.

I do have Publisher too.

I have created a boardgame and because it has lots of pages with all the same row and column sizes and repeated data, I just found it much easier to copy and paste etc.

shmmeee · Jan 18, 2021

Otis said:
It's just easier than Word.

I do have Publisher too.

I have created a boardgame and because it has lots of pages with all the same row and column sizes and repeated data, I just found it much easier to copy and paste etc.

What’s the board game about?

Otis · Jan 18, 2021

shmmeee said:
What’s the board game about?

Nosy.

It's about staging a theatre production from scratch. So you start as a theatre company holding auditions, you recruit actors, then find a plot of land, then build a theatre and then sell tickets for the show. It's all a bit cutthroat though, as you are competing with the other production companies (players), who are also trying to do the same, and they can steal your actors and knock down your buildings and take your ticket sales. It's as much about trying to stop them, as it is, trying to get on yourself.

I've done it all in just five days though, so am working through it to see how it plays out and what works and what doesn't. Each row and column has slightly different gameplay and uses different dice

Played it once with friends and they really liked it and I didn't even have to pay them any money to say that.

Early days yet though and we haven't even managed to get round the whole board yet

Excel (1 Viewer)

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Fairly well known member from Malvern

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Fairly well known member from Malvern

Well-Known Member

Well-Known Member

Well-Known Member

Fairly well known member from Malvern

Well-Known Member

Fairly well known member from Malvern

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Users who are viewing this thread

Privacy & Transparency

Privacy & Transparency