Home
Free Stuff What's New
Free Newsletter
Free Spreadsheets
Customize Sheets
Learn Basic Accounting Basic Accounting
Bookkeeping
Basic Terms
Journal Entries
General Ledger
Financial Statements
Learn Accounting
Small Business Accounting Accounting 101
Basic Principles
Cash/Accrual
Break-Even Point
Cost Accounting
Petty Cash
Software Reviews
Free Biz Software
Business Budget Tips
Biz Deductions
Schedule C
Biz Receipts
Recordkeeping
Estimated Taxes
Tax Planning
Payroll Set Up Payroll
Payroll Taxes
1099-MISC
W-3
Form 941
How To Build a Site
Choose Accountant
Office Supplies
Create a Logo
Evernote
Resources Resources/Links
Site Search
FAQ
Contact Information About Me
Contact Me
Terms of Use

Excel Spreadsheet Tips

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.

Other pages that may interest you:



Go to Basic Accounting Concepts from Excel Spreadsheet Tips


Looking for something?

Use SiteSearch



small business accounting software



AccountingCoach Pro

Master Accounting Package


Click Here for Details


Free Accounting Spreadsheets

when you...

subscribe to free newsletter:



Free Mileage Log Sheet

Free Mileage Log and what must be included on it.



How to Record Accounting Journal Entries

How to Record Accounting Journal Entries



Free Small Business Software

Free Small Business Software


Recommended Products

Outright - Free Yourself from Accounting



Site Build It!

Shoeboxed Works Great With Evernote