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


How to Loop a PowerPoint Presentation

At times, you will want to entertain your guests before an event, like at a wedding or a trade show. You’ll want to loop your PowerPoint presentation so your guests aren’t staring at a blank screen. I have included a link to a sample slideshow using the loop feature.

Here is a link to a sample slideshow demonstrating the PowerPoint looping feature. I am using a presentation available from TechRepublic.

Lets examine how this is done.

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

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

Setting Up your Slideshow

First, open your PowerPoint presentation in which you would like to use the loop feature. Once open, navigate to the Set Up group of the Slide Show tab and select the Set Up Slide Show option.

The Set Up Show window will open. Check the box next to Loop continuously until Esc. After selection, click OK. Refer to below image:

Powerpoint Loop 1
Setting the Loop feature

When you play your slideshow, it will loop until you press the “Esc” key. Now we want to set up the presentation for automatic slide transitions.

Applying the Loop Feature

Navigate back to the Set Up group of the Slide Show tab and select the Set Up Slide Show option. There is one option you need to set, the Using Timings, if Present under the Advance Slides group.

Now, under the Show Type group, select Browsed at a kiosk (full screen). The Loop continuously until Esc option will be enabled automatically (we turned it on above) Also, select the Using timings, if present option. Select OK to proceed. See following image:

Powerpoint Loop 2
Setting the kiosk feature

By setting the Browsed at a kiosh (full screen) option, the Forward and Back keys are locked, thus allowing unattended playback without the fear of someone breaking it.

Setting Up Transitions

Now, lets setup the timings of your slides. Click on the Transitions tab and check the box next to After and set the timing for slide transition. In my example, I have the timining set to 10 seconds. If On Mouse Click is enabled, it won’t work because we have previously selected to loop the slideshow until the presenter has pressed the “Esc” key. To finish the loop feature, select the Apply To All option. See following image:

Powerpoint Loop 3

Now when you play your presentation, it will continuously loop until you press the “Esc” key.

Related

How to use the Dim feature in PowerPoint which is demonstrated in Slide 3 of the sample slideshow.

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

Want to Print Nonadjacent Ranges in Excel?

Normally, we chose an adjacent range of cells with headers for printing in Excel. However, there are occasions we want to print nonadjacent cell ranges. There are some of us who didn’t realize you could do this in a single print area. Let’s see how this is done.

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

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

First Method of Selecting Cells

One method is holding down the “Cntl” key while selecting the range of cells you want in your Print Area.

  • Select your first range of cells
  • Press and hold the “Cntl” key
  • Select additional ranges of cells
  • Release the “Cntl” key
  • Click the Page Layout tab
  • Click Print Area
  • Click Set Print Area. See following image for my selection of nonadjacent cells in Print Area:
Excel Print Area 1
Selecting nonadjacent cells Print Area

Please note that each range you selected will print on a separate page in the same order that you selected regardless of cells location. Also, your current page settings will apply to all your pages. For example, you are unable to mix Landscape and Portrait printing.

Second Method of Selecting Cells

Another method is adding nonadjacent cells to an existing Print Area.

  • Select a range of cells you want to add to your Print Area
  • Click the Page Layout tab
  • Click Print Area
  • Click Add to Print Area. Refer to below image:
Excel Print Area 2
Adding a nonadjacent cell range to Print Area

As with the first method, each range will print on a separate page in the order selected and with the same print settings.

Locate the Print Area

In the Name box to the left of the Formula bar, click it’s drop down arrow and select Print_Area. See following image:

Excel Print Area 3
Using the Name box to show the Print Area

Alternatively, from the View tab, click Page Break Preview in the workbook Views group to see the Print Area.

Click Normal to return to default Excel view.

Two Methods on Printing Your Ranges

You may not want each nonadjacent cell range printed on a separate page. You have two options:

  1. Move the cell ranges adjacent to each other and reset your Print Area
  2. Before printing, select the option to Ignore Print Area. The Active Sheet is now ready for printing. Your Print Area is still saved, you are just ignoring it. Refer to following image:
Excel Print Area 4
Ignoring the Print Area for printing

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