Software gurus

[swissarmygirl]

When in doubt......F1 will give you Microsoft Office Help!

[Nitetimes]

:thinking:

When in doubt......F1 will give you Microsoft Office Help!

Be serious!!!...when has Microsoft ever helped with anything???

[swissarmygirl]

:thinking:

When in doubt......F1 will give you Microsoft Office Help!

Be serious!!!...when has Microsoft ever helped with anything???

Yeah...I made a funny!

I just didn't know the answer to your last question. You're gonna have to catch Kerry again in the morning.
Just make sure and save your spreadsheet.
Oh, right, Office 07.....use that round windows button up top to find "save"
It took me a while to figure that out....duh.

[Nitetimes]

I did save it, I actually did know where to find that.
Don't feel too bad, everyone I've talked to had trouble figuring out that there was something under that stupid button!!

[toypusher]

Just a quick note that you really need to LOCK the cells with the formulas to prevent someone from overwriting them and ruining your spreadsheet in the middle of your sale!! Just a warning!!

Almost forgot, want to explain this a bit more. Don't know how to lock it or even keep what I've got so far???

Hope I can explain this so you understand:

1 - Click on the cell you want to lock
2 - On the top menu select 'Format' then 'Cells'
3 - Click the 'Protection' tab on the popup window
4 - Click the 'Locked' box then follow the directions below it


To protect worksheet: (directions in case you missed them)

1 - Click the 'Tools' button on the top of the page then select 'Protection' then 'Protect Worksheet'
2 - Check the 'Protect Worksheet and contents of Locked cells'
3 - Then select the 'Select unlocked cells' and the 'Insert Rows' boxes
4 - Hit 'OK'

If it will not let you enter your data after doing this, then you have to go back to the cells that you want to input stuff into and make sure they are unlocked. You can highlight a whole section at a time to do this.

Actually you best be would be to select the whole worksheet and unlock all of the cells, then go back and just lock the ones with the formulas and then protect the worksheet.

[Nitetimes]

Okaayy, I'll have to go see if I can figure that out. All I gots ta do is figure out where formulas are, I think I remember where I put them.
Thanks!

[toypusher]

Okaayy, I'll have to go see if I can figure that out. All I gots ta do is figure out where formulas are, I think I remember where I put them.
Thanks!

When you put the cursor over a cell, if it has a formula, it will show up after the 'fx' in the space to the right.

EDIT: it will start with an '=' if it is a formula.

[bobhenry]

Don't do it the hard way let the computer do the work!

Excel column 1 initials
column 2 amount
enter as the sales come and at the end of the sale
click the a/z button this will alphabatize based on row 1
next insert a line immediatly after the last listing for each vendor and hit the autosum button and show it which cells to add.
Do this for each vendor you are done