How to Format a Zip Code in Microsoft Excel

When entering numbers into Microsoft Excel, leading zeros are removed by default. This can be problematic for ZIP codes, phone numbers, credit/debit card numbers and IDs that you type into a cell. We are going to explore some options on fixing this Excel behavior.

If you want to keep a leading zero on the fly, you can enter an apostrophe (‘) before you enter the number that begins with zero. Excel treats the number as a text field. The apostrophe (‘) is not displayed and calculations will still work. But who wants to do this every time, there has to be a better way.

This is for Excel for Office 365 Windows and Mac versions. Other versions of Excel will be similar.

Create the Excel Sheet

Create a simple Excel sheet like the example below:

Zip Code Format 1
Excel Sheet for Zip Codes

Setup the Zip Code Format

  • Select a cell or range of cells to format; in my case G2 thru G6
  • Click “Ctrl+1” to load Format Cells dialog. Also, you can right click and select Format Cells.
  • Select the Number tab
  • Select Custom from the Category list
  • In the Type box, type in 00000 for a five digit zip code or 00000-0000 for a nine digit zip code. This allows leading zeros to be placed in the cell, you only have to enter the Zip code numbers. This is not intuitive, you think you have to select a format from the list. Refer to the following image:
Zip Code Format 3
Setup Excel Sheet format

Using the Special Zip Code Format

You can also click Special, then select Zip Code or Zip Code + 4. In Google Sheets, this special Zip code format is not available, but you can enter the format of leading zeros. See the following example:

Zip Code Format 2
Excel Special Zip Code format
  • Click OK to apply the format. The 00000 or 00000-0000 format is saved in the Type list for future use.

This will only effect Zip Codes that are entered after the format is applied.

You can also format the Zip Code as Plain Text. Anything you enter will show exactly how you typed it in text.

To do this:

  • Select your data range
  • Press “Ctrl+1” to launch the Format Cells dialog box
  • On the Number tab, click Text

What about Zip Codes entries that have more than 5 digits? We can use a Conditional Format in an adjacent column to flag the invalid Zip codes. I used the formula; if the length (cell reference)>5 is True then present an “Invalid Zip” message, if the expression is False, then no message is presented.

Flagging Invalid Zip Codes

  • Create a column adjacent to the Zip Code and label it Error Message
  • Set the Conditional Format for the first cell adjacent to the Zip Code. In my example, it is cell G2
  • Type in this formula, =IF (LEN(your cell reference)>5,”Invalid Zip”,””)
  • Copy this formula, then highlight a range of cells, then Paste

See the following image for the Invalid Zip message related to cell G2 and G6, both have more than 5 numbers. An important note, Excel lets you enter as many digits as allowed, there is no truncation. The template of 00000 formatting is for adding leading zeros if the number of digits is less than 5.

Zip Code Format 5
Flagging Invalid Zip Codes screen

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath


How to Reset Your Windows 10 PIN

If you forget your Windows 10 login PIN, you won’t be able to retrieve it. However, you can change it. If you don’t use a PIN, normally you would signin using a Password. There are other signin options, but the PIN and Password are the most commonuly used.

Using the PIN makes it much easier and faster to login. Before resetting you PIN, I advise you to create a Password Reset Disk.

I was using the guidelines in this post to reset my PIN. I canceled out of the process. That prompted Windows 10 to delete my PIN. I attempted to login with my PIN, but it was gone. Then, I tried using my Password, but I had the wrong Password. After spending an hour or so trying to login and reading help guidelines on my iPhone, I finally entered the correct Password and got past the Windows 10 login screen. In resetting your PIN, DO NOT CANCEL the process.

Even though this post is about resetting your PIN, you should create a Password Reset Disk to avoid the above nightmare.

Windows has a built-in application called Forgotten Password Wizard. This Password recovery tool is what you would use to create your Password reset disk.

This is for Windows 10 devices. To follow this blog post, you will need your Microsoft account Password and Windows 10 login Password.

Creating a Password Reset Disk

  • In the Cortona search box, type in Control Panel
  • Open the Control Panel
  • Click User Accounts
  • Click User Accounts. Refer to below image:
Win 10 Password Reset 1
The Settings User Accounts screen
  • Insert a flash drive
  • Click the link Create a password reset disk. This will open the Forgotten Password Wizard. See below image:
Win Password Reset 2
Starting the Forgotten Password Wizard
  • To start, click Next. The wizard will walk you through the process. You will be asked to select the flash drive from a drop down menu where you want to store the reset disk. Click Next to proceed.
  • Then you will be asked to enter your current Windows Password. Enter your Password and click Next. See following image:
Win Password Reset 3
Entering your current Windows Password
  • You will be presented with a progress bar; once it reaches 100%, click Next, then click Finish. Refer to below image:
Win Password Reset 4
Finishing the Forgotten Password Wizard

At this point, you can check for a file called userkey.psw on your designated flash drive. See below image:

Win Password Reset 5
Locating your new Password Reset file

You can now remove the flash drive, label it and store in a safe place.

Using the Password Reset Disk

The next time you are locked out of your PC, plug in your USB flash drive and click Reset Password link. You may have to attempt your login a few times before you see the link. Select your disk from the drop down menu and click Next. You will be prompted to type your new Password and a Password hint. When you are done, click Finish.

You should now be able to sign into Windows with your new Password.

Reseting Your Windows 10 PIN When Not Signed In

This assumes you already have a PIN for your Windows 10 login. If not, refer to the section below about adding a PIN. Its best to change your PIN while you are logged on. If you are locked out of your PC and you have a PIN, you should see I Forgot My PIN link on the login screen. If so, click the link. You will be asked to enter your Microsoft account Password and how to send a new code. Once you have the code, input it and click Verify. Enter your new PIN twice and now you can use the new PIN when logging into your device.

Resetting Your Windows 10 PIN When Signed In

  • Click the Start button
  • Click the Settings tile (the one with the gear icon)
  • Click Accounts
  • Click Sign-in options. Refer to below screen:
Win 10 Login Pin 1
The User Accounts sign=in options screen
  • Click Windows Hello PIN. See following image:
Win Login Pin 2
The Windows Hello PIN screen
  • Click I forgot my PIN link

You will be presented with an Are You Sure screen. Please read the info about resetting you PIN. If you are sure about doing this, click Continue. Refer to following image:

Win Login Pin 3
Are you sure you want to do this screen

At this point, DO NOT CANCEL the process. Next, you will be asked to enter your Microsoft account Password. Enter your Password and click Sign in. See following image:

Win Login Pin 4
Entering your Microsoft account Password

Now you will be asked to enter your new PIN twice. then click OK. Refer to below image:

Win Login Pin 5
Verifying your new PIN

You now have successfully changed your PIN. Simply use it the next time you login into Windows 10 on your device.

Adding a Windows 10 PIN When Signed In

Remember my nightmare story about losing my PIN. I finally got back into Windows through my Password. Adding a PIN is similar to resetting your PIN while signed in. Follow the steps preceeding the first screenshot above, then:

  • Click Windows Hello PIN. See following image:
Win Login Pin 6
The Windows Hello Pin screen
  • Click the Add button
  • Enter your Windows 10 login Password and click OK. Refer to below image:
Win Login Pin 7
Entering your Windows Password

Now you will be asked to enter your new PIN twice. then click OK. See following image:

Win Login Pin 8
Verify your new PIN

You now have successfully added a PIN. Simply use it the next time you login into Windows 10 on your device.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath



How to Switch to the New Facebook Interface

Facebook’s new website interface change is not well known. At some point, it will probably be the new standard. The interface is getting a visual overhaul that almost everyone can access. You can now update to this brand new, less cluttered design with the click of a button. If you don’t like the change, you can easily switch back to the classic interface.

This if for a desktop/laptop, Macs and smartphones supporting Facebook

Dilbert and Human Interaction
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Enabling the New Interface

Note! This post relates to a PC, other devices will be similar. If you don’t see the new Facebook option then Facebook has yet to rollout the change to your device.

Fire up your device and log in to your Facebook account.

Next, click on the down arrow in the top-right corner of the interface. Select the Switch To New Facebook option. The page will refresh and the new interface design will load. Refer to below image:

Facebook New 1
Switch to the new Facebook option

A welcome message will appear the first time that you switch to the new Facebook design. Facebook claims that the redesign has faster loading time, cleaner look and bigger text. Additionally, Facebook now includes a dark mode that you can enable whenever you want.

Additionally, this update comes with a user-friendly redesign of the Groups tab and an overhaul of the News Feed. See below image:

Facebook New 2
The Welcome message for the new interface

Simply click the Next button. You will see the following image allowing you to select how yout interface will look.

Facebook New 3
Selecting your interface look

Just click the Get Started button. That’s it, you are all set with the new desktop interface. If you aren’t a fan of the Dark mode, you can switch back to Light whenever you like.

Switching Back to the Classic Interface

Once you’ve enabled the new interface, you can always revert the change from your Facebook account’s front page. Just click on the down arrow in the top-right and then select Switch To Classic Facebook. See following image:

Facebook New 4
Reverting back to the Classic interface

At some point in the future, Facebook may decide to roll out the new design permentally for all platforms. If so, reverting back to the classic interface will no longer be an option.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

How to Use Spotify with Siri on iPhone

If you’re running iOS 13 or higher, you can directly ask Siri to play your favorite playlist, song or an artist on Spotify. iOS 13+ expands third-party support for Siri which now includes Spotify. This means you can get Apple Music style playback controls with Siri on your iPhone. Here’s how to set it up.

If you already have the Spotify app installed, and you’re logged into your account, all you have to do is start talking to Siri. Say “Play the Beatles on Spotify”.

This is for iPhone or iPad running iOS 13 or above

Dilbert Goals
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Enable Spotify Access to Siri

As this is your first time using Spotify with Siri, it will ask for permission to access your Spotify data. Simpily tap the Yes button. Refer to below image:

Siri and Spotify 1
Giving permission to access Spotify

Spotify will start playing the music you requested. You’ll see a Now Playing widget playback control on the Siri screen.

You can also control the Siri access for Spotify from your iPhone.

  • Open Settings
  • Select Spotify
  • Select Siri & Search. See following image:
Siri and Spotify 2
Accessing Siri and Search

At the bottom of the screen, toggle on the Use with Ask Siri feature to enable Siri access for Spotify. Refer to below image:

Siri and Spotify 3
Toggle on the Use with Ask Siri

Control Spotify on Using Siri

Once Spotify is connected to Siri, you can use it to play any song, album, artist or playlist. You can also get specific about albums and years of release.

Below are some Spotify commands you can use with Siri:

  • Play [song name] on Spotify
  • Play [album name] on Spotify
  • Play [artist name] on Spotify
  • Play on Spotify
  • Play my liked songs on Spotify
  • Shuffle on Spotify
  • Play the latest album by [artist name] on Spotify
  • Play [genre] music on Spotify

Other than these, you can use the standard playback controls in Siri as well. For instance, you can ask Siri to play, pause, skip, repeat, shuffle or go to the previous track. Refer to below image:

Siri and Spotify 4
The playback control

On your iPhone, you can also open Spotify and see what is playing at the bottom of the screen. See below image:

Siri and Spotify 5
Accessing Spotify to see what is playing

The following image is an example of using the Spotify command Play Easy Listening on Spotify:

Siri and Spotify 6
Listening to Easy Listening on Spotify

For now, Siri only supports playback features in Spotify. You can’t use Siri to interact with the app. For instance, you can’t search for something like a song in Spotify using Siri. You also can’t use Siri to add a song to a playlist either.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

How to Record a Zoom Meeting

Why take notes during a Zoom meeting when you can refer back to a recording of the entire call? Here’s how to record a Zoom meeting, whether you’re the host or not.

Important meetings need good records, and anyone who has taken notes knows that some details can be missed. The best way to preserve a record of a meeting is to have a video recording.

 That goes doubly for remote meetings, where distractions, tech issues and other problems can lead to you missing out on essential information.

If you are using an Enterprise account to host a meeting, you may not be able to record a Zoom meeting unless your IT team has given you permission. Be sure to check with your administrator before the meeting to grant you access if you don’t have it.

If using a PC or Mac, be sure your computer has a microphone and/or camera to use Zoom to its fullest. You may also use your smartphone to record the meeting.

This if for a PC, Macs, iPhone/iPad and Android devices that support Zoom

Dilbert and Future 1
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Accessing Zoom Settings

First, fire up Zoom and join an active meeting. Then click on your small profile photo in upper right-hand corner. This will open up the dialog options window. See below image:

Zoom Record 1
Zoom dialog Options window

Recording a Zoom Meeting

Next, click on the Settings option. The Settings options will be displayed. The Record video during screen sharing option should be checkmarked. Also, at the top of the screen is the location where your video will be stored upon completion. This folder was created when you installed Zoom. Refer to below image:

Zoom Record 2
Settings options for recording a video

By default, only the meeting host can record the meeting, but it’s easy to grant other participants the ability to do so. The meeting host can do so by clicking on Participants while in a meeting, looking for the More button next to an individual’s name and selecting Allow Record

Once in a meeting, those wanting to record only need to click the Record button to start capture, at which point the Record button will change into two buttons: One to Pause the recording and one to Stop recording.

When you’re done recording video, Zoom stores it temporarily in the location mentioned above. The video is encoded into MP4 format once the meeting has ended.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

How to Add an Excel Watermark to Your Sheet

In Microsoft Excel, you can add a watermark, sort of, to an Excel sheet. How to do this is not intuitive. In Microsoft Word you have templates to chose from such as “Confidential” or “Do Not Copy” for a watermark.

I am going to discuss one method; adding an image background as a watermark. We are going to insert an image which could be a photo or a company logo. Let’s see how to implement this watermark.

This is for Excel for Office 365 Windows and Mac versions. Other versions of Excel will be similar.

Your Excel Sheet

  • Create an Excel spreadsheet or use an existing one. Refer to my newly created sheet (Sheet1) below:
Excel Watermark 1
My Excel sheet
  • Click Insert>Text>Header & Footer
xcel Watermark 3
Inserting a Header in the middle column
  • Select Picture

Select Your Watermark

Select your option for inserting a picture. Refer to following screenshot

Excel Watermark 4
Options for selecting a watermark image
  • Select your image
  • Click Insert
  • You will see &[Picture] in the Header.
Excel Watermark 5
Your Header screen without the watermark being shown

View Your Watermark

  • Tap anywhere outside the Header to see your watermark. Refer to following screenshot for my selection of a logo:
Excel Watermark 8
My Excel sheet with a logo as a watermark

Formatting Your Watermark

To format the image:

  • Tap anywhere outside the Header
  • Click Insert>Text>Header & Footer
  • Select Format Picture. You will see the following screen:
Excel Watermark 9
Resize your watermark

From here you can resize the image

  • Click the Picture tab
  • Select the Color box and change it to the Washout option
  • Click OK. This allows the background image to be less intrusive.
Excel Watermark 10
Using the Washout option

Refer below to my final capture of the watermark screen:

Excel Watermark 11
My final screen with the watermark background dimmed in order to see the cells contents
  • Save your spreadsheet and close or exit Excel

For a Microsoft Word look-a-like watermark, use the WordArt feature in Excel.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help me out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

Online Conferencing Solutions

In this Coronavirus pandemic, many people are working from home. Our local TV news and weather people have live audio and video streaming from their homes for the daily news broadcast. Working from home has become the new norm.

This will continue after the crisis is over. Instead of going to an office or to a clients location, you will collaborate through an audio and video service.

I researched some web sites for the top call services. They have a similar mix of apps, just in a different order. Some of the web sites have organizations I never heard of. So, I like the ranking from Office Watch. Click here to read their review.

This is for modern web browsers and apps on Apple, Android and Microsoft platforms

Their top seven online call services are as follows:

  1. FaceTime – handles up to 32 people
  2. Skype – up to 50 people
  3. WhatsApp – handles 4 people
  4. Signal – one-on-one calls only
  5. Zoom and Meetings – up to 100 people for the free version; 1000 for their enterprise paid version
  6. Microsoft Teams and Live Events – can handle 4 participates, up to 10,000 for the paid version
  7. Google Hangouts – up to 150 people

I recommend Facetime or Skype for a small busines; Zoom for a medium business; and Zoom Meetings for a large enterprise. Facetime and basic Zoom are free. Click here to read the review of their rankings.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

What is God Mode for the Windows 10 Control Panel?

Sounds Almighty? God Mode is a special option long available in Windows that gives you quick access to most of the applets and commands from Control Panel. As such, God Mode is a useful time-saver that can spare you from having to hunt through different windows and screens to find the Control Panel command you want.

Since Microsoft no longer offers a convenient shortcut for Control Panel in Windows 10, God Mode can be a fast and easy way to access all of its core commands.

First, lets make sure you’re signed in to your Windows 10 computer with an account that has administrative privileges. By default, your own account should have the necessary rights.

This is for Windows 10 operating system

Checking Administrator Rights

To double-check:

  • Type Settings in the Cortana search bar
  • Click on Settings at the top of screen
  • Select Accounts
  • Select Your Info to make sure your account is designated as Administrator. See the below example:
God Mode Admin Rights
Administrator rights

Setup Folder Shortcut

  • Right click on an empty area of your Desktop/Laptop
  • Select New
  • Select Folder
  • Right click on the New folder and rename it to “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” without the quotes. Its best to copy and past this key into the Rename field. Note! There is a period after the word GodMode. See below image for an example:
God Mode Folder
God Mode folder name
  • Click or double click the icon to run

A window will open with all the accessible commands. The commands are organized by the Control Panel applet. You will see such commands as Administrative Tools, AutoPlay, Backup and Restore, and many more. See below screenshot for an example:

God Mode Commands
God Mode results

Some Tips

You can also Search for keywords using the Search box. Once you have located a command, double click to launch it. If you accidentally click the “X”next to the Search box, the Search will no longer be available.

Its best to leave the icon on the desktop. If you try to rename it, the God Mode may no longer work, especially in Windows 10.

You can click the More options drop down box to present a different view of the listing. In the following example, I have chosen to list the commands with a small icon in front of the command description.

God Mode with Small Icons
Displaying God Mode with small icons

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

How to Setup Contacts in Zoom

Is your business using Zoom for collaboration during the Coronavirus outbreak? Zoom has become a key tool for working at home and a top choice for vittual meetings. Zoom is free for one-on-one calls that last as long as you like. For three or more people, your calls are limited to 40 minutes. Zoom also has a paid version for an enterprise; it can handle 1000 people.There’s also a plan for small and medium businesses that supports up to 300 participates per call..

Click here for a detailed review of Zoom from PCMag Labs

Click here for setup and install of Zoom from Office Watch

Zoom Meeting’s free account is generous. You can host up to 100 people on a call for free and you can see as many as 49 people on an active call in a gallery-style view. There’s no limit on how many meetings you can host. 

So, how do we setup our contacts with coworkers using Zoom? In this post we offer insight on how to do this.

This post is for Windows 7 or greater, iPhone or iPad with iOS 7 or later, Android 4 or greater, Web browsers, Macs and the Zoom app or program

Dilber and Ted Talk
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Before you Begin

Of course, you have already setup the app. Linking to other people in Zoom is necessary before you can call them. A person has to be added to your Zoom contacts list and they have to add you before a call is made.

Zoom contacts are separate from Outlook and other contacts list.

Zoom links people by matching email addresses. Some people have multiple email addresses; for example, personal and work or different ones for different purposes or multiple old email addresses.

Which Email Address to Use?

Before adding a person to your contacts list it’s a good idea to check with them on which email address they use to login to Zoom.

To check, they can click on their Zoom Profile in the top right where their name and address is displayed. Refer to below image:

Zoom Contacts 1
Locate the correct email address

Invite a Contact

To link with someone, in the Zoom app, go to the Contacts section, then click the plus “+ “symbol. See following image:

Zoom Contacts 2
Linking a Zoom contact

Enter the email address of the contact you want to add to Zoom. See below image:

Zoom Contacts 3
Adding a Zoom contact

Then you have two options:

  1. Add Contact – sends a contact request to that person’s Zoom account.
  2. Copy Invitation – copies to your clipboard with web link.  Paste that into an email or instant message.

Refer to below image:

Zoom Contacts 4
Web address for the Zoom contact

There is no need to paste the entire text, change it to suit you. The web link is the important part to pass along. Make sure you include the whole web link; it’s a long link using multiple lines.

Accept a Contact Request

If a participate adds you to their Zoom contact list, you’ll see a pop-up alert. See following image:

Zoom Contacts 5
Pop-up box for a contact request

Or open your Zoom app/web page. Under Contacts look at Contact Requests.  The request will be displayed with options to Accept or Decline. Refer to below image:

Zoom Contacts 6
Accept or Decline a contact request

As you can see above, the Contact Requests you’ve made will also appear with their current status.

What to Do Next?

Now that you’ve linked with someone on Zoom, you can call them (voice, video, text, etc). If someone wants to invite you into a Zoom meeting, give them you Zoom linked email address.

That’s it on setting up your Zoom contacts. Try it out.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help me out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath

How to Create Rolling Credits in PowerPoint

Do you need to give people credit for your PowerPoint presentation? If so, you can add these credits to your final slide by using the scrolling text animation feature. You can use an existing presentation or add this to your next one. In our example, we are using an existing PowerPoint slide show.

This is for PowerPoint for Office 365 Windows and Mac versions. Other versions of PowerPoint will be similar.

Setting Up the Slide

  • Open an existing presentation or create a new one
  • Navigate to the final slide
  • Click the Insert tab
  • Insert a blank text box by clicking the Text Box icon in the Text group. Your cursor will turn into an down arrow. After you click, the cursor changes to a crossbar. Click and drag the cursor to draw the text box. See followin image:
Rolling Credits 1
PowerPoint drawing the text box for the Credits

Entering Your Presentation Credits

  • Enter your credits. The text box will expand, if necessary, as you enter the names.
  • Highlight your entries
  • Select the Home tab
  • Since credits are usually centered, select the Center alignment icon in the Paragraph group. See following screen:
Rolling Credits 2
PowerPoint Credits completed and centered

Adding the Animation Effects

Now lets add the animation to the text box. With the textbox selected:

  • Click the Animations tab
  • Select Add Animation button in the Advanced Animation group. See following image:
Rolling Credits 3
PowerPoint about to add the animations
  • A drop down menu will appear. Scroll to the bottom and select More Entrance effects. The Add Entrance Effect window will be shown. See following image:
Rolling Credits 4
PowerPoint Add Entrance Effect drop down menu

Setting the Credits Animation

  • Scroll down to the Exciting group and select Credits. You will see the credits animation scrolling effect in the background.
  • Click OK to save your changes
Rolling Credits 5
PowerPoint selecting the Credits animation

The rolling credits will be added to your presentation. You may now view your slideshow from the beginning or from the current slide to see the Rolling Credits in action.

Thats it. You are finished.

I Would Like to Hear from You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong: Events and Aftermath