Excel Spreadsheets

[chokkie]

Hi techie Abers .... Mr. Chox is doing very well with his new-found Excel skills and he's very pleased with his work so far. Just wondering though - could someone please tell us how to insert extra lines in a spreadsheet, please - just a very simple way of doing it for tech-thickies like us two... many thanks, cheers, Chox.

[fiction-factory]

Go on the grey column on the left of the row where you want to insert and right click and select 'insert'

[JimF]

By "lines" do you mean "rows"? A spreadsheet typically consists of a grid of cells arranged in vertical columns and horizontal rows - is that what you mean?

[DTCwordfan]

fiction has it.....

[chokkie]

Yes, sorry I did mean a "line"..

[chokkie]

Yes, sorry I did mean a "row"

[Peter Pedant]

easy one this see above
BUT remember that it will be unformatted - real pain for dates if you dont like the jumping when 'May' goes wrong

Mike Girvins site Excel is fun is VERY good for excel skills

fr'instance inset row is control shift plus

no I am not mike girvin

[fiction-factory]

Good point, PP. Yes, when I insert a row I have to copy and past the formulae from the row above- another right click copy and paste job, and then also review the formula for the row below

[Peter Pedant]

o god I knew I had omitted something
formatting and formulae

[chokkie]

Thanks for all your help folks, much appreciated. It's easy when you know how, but we're only beginners! Cheers, Chox.

[Peter Pedant]

do Girvin
it is long and useful - - as the actress ....

[chelle7272]

there are some very good training videos on youtube for excel. Not that I'm saying no to ask on here, you alasy get the right help, but I find the visual really useful. Just search for excel tutorials, if you know whch version of excel you are using add that to the search to help you get results more suited to you.

[Peter Pedant]

jesus - hasnt he done it yet - its been two days !

[chelle7272]

I'm sure he has :) I'm just avoiding the million posts about Cummings and ahving a nose through technology instead!