Home
Accounting Packages AccountingCoach
Add Accounts
Free Stuff What's New
Free Newsletter
Free Spreadsheets
Instructions
Customize Sheets
Accounting Basic Accounting
Accounting Terms
Accounting Principles
Journal Entries
General Ledger
Cash/Accrual
Petty Cash
Accounting Software
Financial Statements
Business Create a Logo
Deductions
Schedule C
Estimated Taxes
Budget Tips
Business Receipts
Recordkeeping
Debt Collection
Payroll Set Up Payroll
Payroll Taxes
Form 941
W-2
1099-MISC
Resources Office Supplies
Build a Site
Privacy Policy
Disclaimer
Resources/Links
Contact Information About Me
Contact Me
FAQ

Excel Spreadsheet Tips to Customize Your Free Excel Spreadsheets


Let’s start out with some basic excel spreadsheet tips for customizing your free excel spreadsheet.

  • SAVE an original copy.
  • Look at the bottom tabs.
  • Click on the first tab.

Give the Heading Some Personality :

Excel Spreadsheet Tip #1: Color

  1. Select the Heading. (Click anywhere in row 1 and holding the button down go down to row 4 to select heading)
  2. Click on the drop down list(pointing down arrow) on the fill color icon (looks like a tipping paint can).
  3. Choose which color you want for your heading.

Excel Spreadsheet Tip #2: Font

  1. Your heading should still be selected (if not…see instructions above).
  2. Click on the font color drop down list (looks like a “A”) and choose font color.
  3. Click on the font drop down list and choose which style of font you like (in the 2007 edition, you can see your heading change as you scroll down the different styles).
  4. Click on the font size drop down list (next to the font) to choose size.

Excel Spreadsheet Tip #3: Inserting a Logo or Picture into your Free Excel Spreadsheet

  1. Insert a couple of columns by selecting columns A &B and clicking insert.
  2. Select cell B3,...on the Insert tab, in the Illustrations group, click picture.
  3. A pop up box that says Insert Picture will appear, if your picture or logo is not in file they opened, click on the drop down list at the end of the bar that says Look in: and find your file.
  4. Click on picture or logo and click insert.
  5. Grab hold of the resizing little white circles on the picture and resize it to desired size. (I always grab the right bottom resizing handle.)
  6. Click in the middle of the picture (pointer will turn to a 4 way arrow) and move pix where you want it.
  7. With the picture still selected you will notice in the ribbon bar above you see a pink Picture Tools and under it Format. There is a lot of fun stuff you can do to your picture in this tab.

    In the example picture above...in the Picture Styles group...I clicked on the arrow in Picture Effects, Soft Edges, 10 point to make my picture blend in better.

  8. I also could have faded it out by clicking the Recolor arrow in the Adjust group, then click on the 3rd icon under Color Modes and washed it out ...or changed the whole color underLight Variations. Play with it till you get it how you want it on your free spreadsheet software.


Return to BasicAccountingHelp’s Home Page from Excel Spreadsheet Tips


footer for excel spreadsheet tips page