For The Love Of Software

Create One Adobe File From Several Small Adobe Files

2009-10-28T09:07:00.004-07:00

Did you know...

You can create one main pdf file in Adobe Standard or Adobe Professional with a very simple method.

No pictures needed to illustrate this...

Open Adobe Standard or Professional
Click on file
Click on create pdf
Click on from multiple files

You will get a window that will allow you to add files.

Navigate to the location where you have saved your files
Select all of the files you want to include (you can select non-contiguous files by holding down the Ctrl key as you click on each one)
Use the Up and Down arrows to put the files in the order you want them to appear in your new document
Click on Next
If the files are in the order you want them, click on Create (if not click on back and rearrange them)

You will then save the document and your new adobe document is complete with all the little parts into one big document in the order you want them.

Doesn't work for you?
Email me at grandberry@gmail.com

We help you like your computer.

Word 2007 Tabs Tips and Tricks

2009-07-24T09:11:00.015-07:00

Did you know...

it is easy to set tabs in Word 2007?

First, you need a little information. This is the tab selector button with the left tab showing.

It is found between the horizontal ruler at the top of your page and the vertical ruler on the left side. You need to be sure your ruler is showing. If it is not click on the View tab...

Click on Ruler

See? There is the selector tab to the left of the horizontal ruler

When you click on the tab selector button it changes. It toggles through the various types of tabs available to you. There are several, we will only talk about the most common:

Left- it is the default tab showing most of the time (unless you change it). When you set a left tab the text will move to the right as you type

Center-the text will center over the tab

Right-the text will move to the left when you use the right tab

Decimal-the text will align over the decimal point, generally used for dollar amounts

To set a tab, simply get the type of tab you want showing on the tab selector and then click on the ruler where you want the tab

If you were typing a list like this:

You would set a left tab for the first column, a center tab for the second column, a decimal tab for the third column and a right tab for the fourth column. The tabs on your ruler will look something like this.

To remove a tab, simply click and drag the tab off the ruler onto the page. It will go away.

As with all things in Microsoft, there is another method. You can open the Tabs setting window and set your tabs there if you know where you want them on the ruler.To open the Tabs setting window click on the selector arrow on the Paragraphs group (found on the Home Tab)

The Paragraph formatting window will pop up, you then need to click on the Tabs button at the bottom.

The Tab setting window opens, here you can simply type in the position on the ruler and click Set.

You can also set dot leader tabs by selecting the dots under the Leader section.

The important thing to remember is that each time you enter a tab you must click on set before closing this window or the tabs will not be set for you.

You can also use the window to easily clear all tabs.

As always, if you have questions, feel free to send me an email

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments encouraged.

Word 2007 - Page Numbering Problem

2008-11-12T12:30:00.007-07:00

Did you know...

You can manipulate the page numbering for a document?

Here is the problem. The document has three introductory pages before the actual text starts:

Cover Page
List of Attendees
Table of Contents
Actual document starts on the 4th physical page.This exercise is to just start numbering on the 4th page, but make the number a ONE (1) not a 4.

This is a simple process, but requires a little knowledge of where things are in Word 2007. Here are the steps to follow to accomplish this task.

You must insert a section break after each page.

At the end of the text on the Cover page--Go to Page Layout
Click on Breaks

Click on Section Break NEXT PAGE (Do this for each page that may have different numbering. In my sample, I did it for the first 3 pages)

Click on Insert
Click on Footer

Click on Edit footer

Click on Next Section. You will see "Same as Previous" on the right side of your footer. Same as Previous is evil. Take it off by doing the following step.

Click on Link to Previous so it doesn't look highlighted any more. See the before and after pictures.

Repeat the last two steps for Page 2 and Page 3 (That is: Next Section and take off Link to Previous)
After doing that for the first 3 pages, you should be on Page 4 and you want it to be number 1
Click on Page Number
Click on Format Numbers

Tell it to START AT 1.
Click OK

Click on Page Number
Click on Current Position
Then Click on Plain Number

If you did it right, you will only have a page number on page 4 and the number should be a 1.

Once the number code is in the document, it will give you continuous numbering on subsequent pages without any further effort on your part. You can also center it, change the font, make it bold, etc.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments encouraged.

Word 2003 and 2007 - Automatic Numbering

2008-08-27T07:52:00.007-07:00

Did you know...

that Microsoft Word has automatic numbering?

To turn on automatic numbering in Word 2003 or 2007 click on the automatic numbering icon

This will turn on automatic numbering and each time you press enter at the end of an item you will get a new number. Like this:

1. To get this number click on the automatic numbering icon. Then press enter
2. You will get a number 2., followed by a tab. When you press enter again
3. You will get a number 3., followed by a tab.

If you want multi level numbering, in Word 2003 you must go to Format and then click on Bullets and Numbering as shown below.

You can then select the outline tab as shown below and select the outline numbering style you want. Just click on the style you want and then press OK.

In Word 2007, there is an icon on your Home ribbon for outline numbering. You can simply click on it to take the default outline style. The outline style is the icon right next to the automatic numbering icon.
If you need more choices, click on the more arrow on the right side of the outline numbering icon and make selections from the options there. Just click on the one you want and the automatic numbering will begin.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Controlling Page Number Word 2003 and 2007

2008-08-13T11:08:00.007-07:00

Did you know…

You can control page numbering in a Word Document?

So, you want to put a number on the bottom of your page in a Word document, but you don’t want a number on the first page and you want the second page to start with the number 1.

In Word 2003:

Click on View from the Menu Bar
Click on Header Footer (The Header Footer toolbar will appear)

Go down to the footer by clicking on the Switch Between Header and Footer icon on the toolbar.

Click on Page Setup

Click on the Layout Tab
Put a checkmark in different first page (this will allow you to have page numbers on all the pages except the first page.)

Click OK
Put the cursor where you want the page number on the second page footer, click on the the Insert Page Number icon

Now, select (or highlight) the number in the footer on the second page

Click on the Format Page Number icon

Tell it to start at 0 (This will tell the document that the first page is 0 so the second page will start at 1)

Click on Ok and check your page numbering now.

In Word 2007

Click on Insert from the Ribbon (The Header Footer Toolbar will show up on the ribbon)

Click on Footer

Select the option closest to what you want
Click on Different First Page

Now, select (or highlight) the number in the footer on the second page

Click on the down arrow on the Page Number icon
Select Format Page Number from the drop down menu

Tell it to start at 0 (This will tell the document that the first page is 0 so the second page will start at 1)

Click OK and check your page numbering now.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Microsoft Word 2003 and 2007 Table Tabs

2008-08-08T09:09:00.000-07:00

Did you know…

That you can align the numbers so the decimals all line up in a table?See how the numbers in the total column do not line up?

Here’s what you do.

1. Put the cursor above the column with the numbers you want to align until you get the little black down arrow and CLICK ONCE to select the entire column.

Your column will now be highlighted.

Now, you are going to set a tab. In the corner of the window between the two rulers on the left side*, you will find a little tab box. It probably has a Black line in it shaped like an L. That is a Left tab. You are going to click on that until it changes to a decimal tab. Here is what it looks like…

Next, you are going to put your cursor over the ruler above the column you want to align by decimal and click once. This will place the tab on the ruler and align the numbers in the column you have highlighted.

Kewl, huh?

*Can’t see the ruler? Click on View and then click on Ruler.

Give it a try.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Outlook 2003 and 2007 Signature

2008-08-05T09:59:00.005-07:00

Did you know...

You can create a signature for your Outlook e-mail messages that will show up every time you start a new e-mail or reply or forward a message?

Here's how...

To create a signature in Outlook:

Click on Tools
Click on Options
Click on Mail Format
Click on Signatures
Click on New…
Give it a name so you can find it later if you need
Click on Next
Enter the text and signature you want

In Outlook 2003

Click on Finish
Click on OK
In the box next to Signature for new messages be sure the signature you just created is listed there. If you want the signature to show up on replies or forwarded messages as well, be sure it is in that box too.

In Outlook 2007

In the same window where you created the signature you have a box to put the options in

Be sure the signature you want is showing in each of the appropriate boxes. You can have one signature for new messages and another for replies and forwards. Notice my signature for new messages is "With sig" and my reply or forwarded messages signature is "Sandi." They are two different signatures.

Now, each time you start a new e-mail message the signature you chose will be there. If you don’t want the whole signature, you can delete it from the message. It is just text in the message and can be edited like any other text in the message.

Give it a try.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Microsoft Word 2003 or 2007 Table Columns

2008-07-28T07:24:00.008-07:00

Did you know...

If you have a column in a table that goes off the edge of the page, there is a simple way to get it back on the page?

See how the column disappears off the right side of the page?

Here is what you do...

1. Put the cursor right above the column you need to get back onto the page until you get a little black down arrow.

2. Now, put the cursor between the last two columns until you get the little resizing arrow. It is a double line with an arrow pointing left and an arrow pointing right. DOUBLE CLICK.

The last column now fits on the page.

Give it a try.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Excel 2003 and 2007 -- Edit formulas

2008-04-09T13:21:00.006-07:00

Did you know...

You can edit formulas in 2 different places?

Anything you enter into a cell will show up not only in the cell, but also in the formula bar. Here is a picture of a formula entered into a cell and showing in both the cell and the formula bar. The result is in the cell the formula is in the formula bar.

If you look at the formula bar (next to the fx) you will see the actual formula. If you look in the cell you see the results.

Now, if you double click in the cell you will get a blinking cursor and be able to edit your formula right in the cell. It will look like this:

If you double click in the formula bar (next to the x √ fx) you will get a blinking cursor there and you will be able to edit in that box as well.

Give it a try.

Doesn't work for you? Email me at grandberry@gmail.com

We help you like your computer.
Comments welcome.

Excel 2007 -- Freeze Pane

2008-01-25T10:59:00.000-07:00

Did you know...

That you can make the top line on your Excel Spreadsheet visible all of the time no matter how far down the sheet you have to go.

You can do this in other versions of Excel, but as we all move from Excel 2003 to 2007, it can be confusing trying to find the command.

In Excel 2007 the "Ribbon" at the top changes based on what you are doing. Excel has no way of knowing when you want to freeze panes, so you have to go to the correct Ribbon to find it.

You will find it on the View Riboon. Here is what you do...

Place your cursor on the row below the row you want to show up all the time
AND
if you have a column on the left you need visible all the time, place the cursor in the column just to the right of the one you want always visible. Like this:

Click on the View Ribbon

Click on Freeze Pane

Select the option you want, I have selected the top options

In this illustration the first row and the first column will be visible all of the time no matter how far down on the sheet you go. Above you see Rows 1-7 and Columns A-E. If I move to Row 27 you will still be able to see the top row as shown below if the spread sheet grows and I need to add information in all the columns through Z, the first column of names will always be visible:

This feature has no effect on printing, it is strictly a viewing feature to make working in the Excel spreadsheet easier.

To turn off this feature, simply go through the steps listed above and select "unfreeze pane" rather than "freeze pane" (the option changes based on what you have done).

Doesn't work for you?

email me at grandberry@gmail.com

We help you like your computer.
Comments welcome.

Microsoft Word 2003 and 2007--White space

2007-11-14T19:04:00.000-07:00

Did you know...

Microsoft 2003 and 2007 will allow you to hide the white space at the top and bottom of your document?

Here is a sample of a document in Word with the bottom of one page showing and the top of the second page showing:

When you put your cursor right on the edge of either piece of paper, you get the "hide white space" option. It will look like this:

Once you have the cursor in position so you see the "Hide White Space" option, click one time and the top and margins will be hidden. Like this:

The margins are still there, they are just hidden. This view will help you align text, graphics, tables, etc. by hiding the white space temporarily. To get it back, simply click again in the same place.

Didn't work for you?

Send me an e-mail at grandberry@gmail.com and I will be glad to help you and answer your questions or post a question in the comments here.

We help you like your computer

Microsoft Outlook--Using Word as your e-mail editor

2007-10-01T10:55:00.000-07:00

Using Word as your E-mail Editor
Did you know that...

You can use Microsoft Word as the editor for your Outlook e-mail messages? If you do this, you will have all the editing features you have in Word when you are creating a message in Outlook.

To turn on that feature:

Open Outlook
Click on Tools
Click on Options
Click on the Mail Format tab at the top

In the top portion of the window you will have selections on how to set your e-mail editing options:

You can set the "Compose in this message format:" to either html or rich text.

Put a checkmark next to both options to Use Microsoft Office Word as your editor.

Click on Okay to close that window.

Now, when you open a new e-mail message you will have all of the toobars available that you normally find in Microsoft Word.

Doesn't work for you? e-mail me at grandberry@gmail.com. I'd love to help you.

We help you like your computer.

Microsoft Office 2003 Customize a Toolbar Button

2007-09-06T15:30:00.000-07:00

Did you know...

You can customize buttons on your toolbar, including macro buttons. Here are the simple steps.

Click on Tools

Click on Customize

Click on the Commands Tab

Click on icon you want to change

Click on Modify Selection

Put a checkmark next to Default Style

Click on Modify Selection again

Do one of two things:

Click on Change button image and select a predesigned image

Click on Edit button image and using the color boxes draw your own design

When finished close all windows and see the new and improved button you just created

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer

How NOT To Use Powerpoint By Comedian Don McMillan

2007-09-06T13:15:00.001-07:00

PowerPoint Tips

Excel 2003 Macro Buttons Tips & Tricks August 2007

2007-08-01T10:24:00.000-07:00

Excel 2003 Macro Buttons

Did you know?

You can create a button (rather than just a keystroke) for macros you create in Excel?

Assuming you know how to make a macro...

After you create the macro,

Right click on the toolbar
Click on customize
Click on the commands tab
Select MACRO from the Left column
From the Right column drag the macro CREATE CUSTOMIZE BUTTON and drop it on a toobar
Right click on button and choose ASSIGN MACRO
Select macro from next window that opens
Close the customize window

You now have a macro button on your toolbar to complete a task with one click.

Next month, how to customize a macro button.

Comments welcome. Is there a tip you need to know, put it in the comments and I will include it in future Tips & Tricks.

We will help you like your computer.

Doesn't work for you? Send me an e-mail and I will help you.sandi@fortheloveofsoftware.com

Outlook 2003 Tips & Tricks July 2007

2007-07-01T14:44:00.000-07:00

Outlook 2003 Sent items

Did you know?

You can find copies of e-mail messages you sent in Outlook by opening the sent items folder.

If you do not see any e-mail messages under the sent items, send me an e-mail and I will give you instructions on how to make each message you send copy to your sent items automatically.

Comments welcome. Is there a tip you need to know, put it in the comments and I will include it in future Tips & Tricks.

We will help you like your computer.

Doesn't work for you? Send me an e-mail and I will help you.

sandi@fortheloveofsoftware.com

Word 2003 Tips & Tricks July 2007

2007-07-01T08:19:00.000-07:00

Microsoft Word 2003
Repair a damaged document.
Did you know?

Sometimes you have a Microsoft Word document that is corrupted and you want to try to save it but don't know how. Microsoft has provided one feature to assist you and it's easy to use.

Open Word
Click on File
Click on Open
Find the document to open and click on it ONCE
Now click on the pull down menu next to Open at the bottom of the window and select the option to Open and Repair. You just might get lucky and recover your damaged document.

Comments welcome. Let me know if you need a tip on something specific.

We help you like your computer!

Doesn't work for you? e-mail me at sandi@fortheloveofsoftware.com.

Word 2003 Tips & Tricks June 2007

2007-06-01T17:00:00.000-07:00

Microsoft Word 2003
Close All

Did you know that when you are in Microsoft Word and you hold down the shift key when you click on File - the option to Close a document changes to Close All and will close all documents you have open in Word at once. The Save option changes to Save All to save all documents at once?

If you accidentally select Close All don't worry if you have not saved a document. Microsoft will ask you to save the open documents one at a time when changes need to be saved. If you have previously saved changes the document will be closed without asking you to save.

We help you like your computer!

Doesn't work for you?

e-mail me at sandi@fortheloveofsoftware.com

Word Tips and Tricks May 2007

2007-05-23T13:07:00.000-07:00

Microsoft Word 2003
Page Setup

Did you know you can use Portrait and Landscape settings in the same document?

By default the document is set in portrait. If you have one or more pages you want to make landscape in the same document, do the following:

Select the pages that you want to change to landscape (or portrait) orientation.
Click on File
Click on Page Setup

Click the Margins tab.
Click Portrait or Landscape.
In the Apply to box, click Selected text.

Click Ok

Microsoft Word automatically inserts section breaks before and after the text with the new margin settings. Your document will be set up like this:

Need to know more about sections breaks? Look for a class on sections breaks coming in July at http://www.fortheloveofsoftware.com/

We help you like your computer!

Doesn't work for you? e-mail me at sandi@fortheloveofsoftware.com

How to get a screen shot

2007-05-01T13:00:00.001-07:00

Did you know...

You can make an image of any window on your computer with a simple keystroke?

How to get a screen shot of a window on your computer

1. Open the window you want a screenshot of
2. Hold down the Alt key and press the Print Screen button on your keyboard

3. You will not see anything happen (the image has been put on the computer clipboard waiting for you to paste it somewhere.
4. Now, go to Microsoft Word and open a blank document
5. Paste the image you just put on the clipboard by doing one of 3 things:

Press the Ctrl and V key together, or
Click on Edit and then Paste (in Word 2003) or in Word 2007 click on the Home Ribbon and then click on the Paste option, it is the first option on the Home Ribbon;
Right click on the document and select paste from the menu you get.

Give it a try.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.