DH Templates

Trying to make an invoice template in Excel

How can I do the following a) make the borders, equations and formats remain, even when I clear the contents of the cells b) create a button that puts todays date in a cell c) put more rows in any bordered box without having to redo the boxed borders in "Format cells" d) create a button that will print information from my address box onto a seperate sheet in bigger font ready to stick on a parcel. I know you got better things to do but take pity, I'm British and one day you might need some mud or rain or stale biscuits or something.

Public Comments

  1. Glad to see you up an running. I still use graph paper and colored pencils. If I can help with that, let me know.
  2. http://www.editgrid.com/ or use a chalkboard.
  3. DURr-URH! I hope this is no help whatsoevA!
  4. F1 or Help menu? I know you can do addresses and labels in Word but not familiar with that function in Excel Tools Customize Commands Control Toolbox Command Button (not sure how to set command though, just format that cell that has the button) for d) maybe?? c) highlight the left hand row number for the whole row and insert rows?? or just highlight the cells within the border and insert rows. Sounds too simple. Good question. I prefer Excel to Lotus
Powered by Yahoo! Answers