How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…
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---
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.
Should have said, on the First row that you want splitting into two!
Hope this helps
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.
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.
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"
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.
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.
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.
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.
This thread is now locked and can not be replied to.