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 Tips

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.
  4. If your spreadsheet is locked (protected) you will need to "unprotect" your sheet. Simply click in the REVIEW tab and click Unprotect Sheet. There is no password on the newest spreadsheets so you will just see the icon change from Unprotect Sheet to Protect Sheet. You can then go back to  the Home tab and make your changes. (If you have an older spreadsheet and it states you must enter a password...the password is: bah.)

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:

Free Mileage Log...

Click on image above for more details.

Spreadsheet Reviews...

"I absolutely love the spreadsheets!!  Thank you so much! They are exactly what I needed."

Becky from Back to Natural

"Thank you so much. I have been stressing about doing this accounting stuff for my husband. Quickbooks was too complicated for his small business and these spreadsheets are just what I was looking for!!!"

Josi Michael

"I love your accounting spreadsheets- thank you!"

Sandra from the UK

"As a small business owner my expertise has always been in marketing and customer service. I have struggled with many different options for my bookkeeping.

Vickey's basic accounting help and ledgers have made my business so much easier!"

Kelly Howard

"Thank you for your free spreadsheet! It has helped me tremendously to track daily sales and get a grip on the full scope of what revenues are coming in and my expenses."

Gabby of Gumdrop Swap

Business mileage can be a very good deduction for your small business.

It can also be a nightmare, if all the IRS required information is not included in your mileage log.

See what must be included and get a free mileage log!