How to Change the Default Font Color in Windows 7

Would you like to make all your text in Windows 7 uniform across the board? This tip will help you change your default font in Excel, Outlook, and the other Microsoft Office programs. It will also change the default font for your folder names in your Windows boxes, etc. Beware, though, it will change everything! [...]

How to Change the Selected Text Color in Windows 7

Is it hard for you to see the gray highlighting that appears when you select text? You might be selecting text in Word, Excel, Outlook, or another Microsoft Office program. Or, you may be highlighting text on a webpage. Well, there’s a way to change the default highlighting color in Windows 7. Unfortunately, though, I [...]

How to Change the Homepage and New Tab Page in Google Chrome

Would you like Chrome to open to the same page every time you start the browser, click on the Home button, or open a new tab? Here’s how to make Chrome do just that: Setting the Page that Appears when you First Start Chrome. 1. Open a Chrome window and navigate to the page you [...]

How to Color Tabs in Excel

You can spruce up a workbook by coloring its worksheet tabs. There are several ways to do it. For this exercise you need a workbook with at least three tabs. Here’s the easiest way: Right click on the first tab you want to color. Hover your mouse over Tab Color in the menu that pops [...]

How to Center a Title in Excel

Have you racked your brain trying to center a title on a spreadsheet? Here’s a beginning exercise on learning how to type a title, format it,  and then center it: Click in cell A1 to make it the active cell. A black border will appear around it. Look down at the lower left-hand side of [...]

Parts of the Excel Screen

Let’s learn some Excel lingo. Go ahead and open your Excel 2010 or 2007 program if you haven’t already done so. Here’s what you’ll see: The ribbon. This is the wide strip across the top of your screen where all the buttons are. The ribbon consists of various tabs. These include Home, Insert, Page Layout, [...]

How to Print in Excel 2010

Printing in Excel can be very tricky. This tutorial teaches how to print a spreadsheet so it actually looks good. There are a few ways to setup a spreadsheet in Excel 2010. We’re going to use the print settings in the Page Setup dialog box because to me that’s the simplest way. To access this [...]

How to Create a Simple Macro in Microsoft Word

Creating a macro in Microsoft Word isn’t as hard as you might think. It’s really just a bunch of steps you need to perform in an exact order. This tip provides an example on how to do it: Let’s say you write a lot of business letters, and you’d like to end them the same [...]

How to Combine First and Last Names in Excel

Let’s say you have two columns. Column A has people’s first names, and Column B has last names. You want to combine the first and last names into the same column. Here’s how: First we’ll insert an empty column to the right of Column B.  To do this, move your mouse arrow directly on top [...]

How to Format Dates in Excel

The default format for dates in Excel is kinda weird, at least for the United States. If you don’t change the format, the dates look like this: Unformatted Dates No worries. You can change the format to something normal looking in no time. This tip shows how to do it in both Excel 2010 and [...]