Spreadsheet

  Thomo1 18:56 07 Mar 05
Locked

This is incrediably simple but i can remember how to do it.

I want to make 2 headers on my spreadsheet. i want row 1 to be split into 2 main cells that have 5 separate columns underneath. (if that makes sence).

Eg. Row 1 -------------------I-------------------

....Row 2 ---I---I---I---I---I---I---I---I---I---

....Row 3 ---I---I---I---I---I---I---I---I---I---

etc, etc.

The - stand for the column width and the I stand for the column boxes.

How do i get Row 1 to be split into 2 main cells but underneath the cells left normal???

Using Microsoft Works spreadsheet.

  TonyV 19:12 07 Mar 05

Thomo1

If you select the cells you want to form the colums, then click on Format/Cells/Alignment then Merge cells. (I assume you are using Excel.)

  TonyV 19:14 07 Mar 05

Thomo1

Should have said, on the First row that you want splitting into two!

Hope this helps
.
TonyV

  Thomo1 19:14 07 Mar 05

ah hah thats y i cud not remeber how to do it. I dont have excel. I knew merge cells existed but i couldnt find it and thats y. I was trying to do it using a normal MS works spreadsheet.

Any ideas on how i can manage it without excel???

it at all.

thanks

  TonyV 19:30 07 Mar 05

Thomo1

It's basically the same in Lotus 123, wording is different, but the end result is the same! (Range/Range Properties/Alignment/Align across Columns. Then click on the Central Alignment.) Is there nothing in the Formatting or Range Properties in your programme that will give the same result?

I do not know the Works version of Excel, but thought it would have been something very similar.

Good luck!!

TonyV

  Cannuck 19:38 07 Mar 05

Are you trying to keep the titles as you scroll down?
If so all you do is "freeze" beneatn the titles.
This is under "Format"

  Cannuck 19:57 07 Mar 05

Don't know if I am reading you right.
Do you want a main title, then subtitles, with the data filled in below?
If so you can "split" the screen 4 ways or you can "freeze" both columns and rows.
If you want the title of each section to be in the middle of its side of the sheet, just go to "format", "alignment", and the bottom one is "center across section". This gives you the title in the middle of that side, no matter how long or short.
You get these commands from the "Format" on the top bar, not right clicking.

  Thomo1 23:31 07 Mar 05

Tony - all making central alignment does is write the text from the middle not the left on my version of Works. I dont have the excel spreadsheet only the Works spreadsheet.

This is what i am wanting. (see diagram in 1st post)

Row 1, Column A = Daily Targets

Row 1, Column B = Weekly Targets

Row 2, Column A = Day

Row 2, Column B = Target

Row 2, Column C = Actual

Row 2, Column D = +/-

Row 2, Column E = Running Total

Row 2, Column F = Week Number

Row 2, Column G = Target

Row 2, Column H = Actual

Row 2, Column I = +/-

Row 2, Column J = Running Total +/-

Row 3, Column A = Monday

Row 4, Column A = Tuesday

Row 5, Column A = Wednesday

Row 6, Column A = Thursday

Row 7, Column A = Friday

Row 8, Column A = Saturday

Row 9, Column A = Sunday. Row 9, Column F = Total

Row 11, Column A = Total

Eg. Row 1 ---Daily Targets--I--Weekly Targets---

....Row 2 DayITargetIActualIetcI---I---I---I---I

....Row 3 MonIetcI---I---I---I---I---I---I---I---

....Row 4 TueIetcI---I---I---I---I---I---I---I---

The "I" indicates the cell.

  Thomo1 23:41 07 Mar 05

Managed it, just had a play with it and had to format text to fill from center but instead of typing str8 into the cells, i had to first click on them all then click the text box.

Resolved

  TonyV 23:44 07 Mar 05

Thomo1

I see what you are trying to do and thought that by merging the cells as I suggested earlier then aligning them in the centre of the merged cells would look better. But if you say it can't be done in Works then I'm not sure what else you can do.

Sorry

TonyV

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…