quick question about spreadsheets, I'm missing a couple of things

apprentice_tycoon

It's my self assesment tax spreadsheet that I'm filling in on Microsoft Works.

It's the first time I've used Microsoft Works for this tedius job, there are 2 things that would make it easier and I don't know how to correct them.

The system I used to use used to fill in the rest of the word for me so I'd type in 'b' and it used to fill in 'bank'

The second niggle is I can't seem to adjust the 00's after the decimal point. I type in 200.00 and it shows it as 200 - can I alter this?

Any help would be appreciated.

intel

Format Cells, Number for the .00 thingy. You will have to highlight the column first.

And you are on about autofill for the other thingy I dont know
if thats available in Works, do a Excel help for autofill maybe

chateauneufdupape

As intel says, for the decimal points go to Format>cells>number>number and scroll to 2, or Format>cells>number>currency if you want a "£" sign and two decimals.

For the autofill go to Tools>Options>Edit and tick the box for "Enable AutoComplete for cell values"

apprentice_tycoon

Thank you both - I've got the decimal point thing sorted so that's great but the autofill thing has defeated me. I looked at the tools>options>edit thing but it didn't have the autocomplete option, it must be on a different system to mine, I just learned how to drag the word 'bank' down all the columns so that's a bit less work but there is still cheque and paypal etc to type out!

tigermatt

apprentice_tycoon wrote:

Thank you both - I've got the decimal point thing sorted so that's great but the autofill thing has defeated me. I looked at the tools>options>edit thing but it didn't have the autocomplete option, it must be on a different system to mine, I just learned how to drag the word 'bank' down all the columns so that's a bit less work but there is still cheque and paypal etc to type out!

It probably isn't on Works' spreadsheet tool because it is a cut-down version of Excel with limited features. I guess you were using Excel before as Excel has the AutoFill feature.

still cheque and paypal etc to type out!

Can you use abbreviations - e.g. P for paypal, Chq for Cheque etc. then put a key at the top?