Author Archives: Lance Whitney
Templates can give your spreadsheets a healthy head start. Do you often struggle to create and customize certain Excel spreadsheets a specific way? Maybe you’re attempting to set up a budget or record expenses or put together a schedule. And you’re trying to format your spreadsheet piece by piece but it’s not quite working. Well, struggle no more. Instead let Excel do the hard work for you. How? Through templates. A template can give your spreadsheet the right look and layout right from the start so you’re not spending hours trying to format it manually. Excel comes with a variety of templates, and you can download more from Microsoft. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You can master the intricate and sometimes slippery art of copying and pasting in Excel. Here’s how. Copying and pasting in Microsoft Excel can be tricky. You may want to simply copy the contents of one cell to another. Or you may want to be selective about what you copy, choosing to copy the entire cell, just the data, just the formula, just the formatting, or a combination of items. But for whatever reason, the copy and paste isn’t working the way you want, and you keep having to redo it until you get it right. The good news is that you can avoid many copy and paste problems in Excel. What’s the secret? Let’s check it out. For our purposes, I’m using Excel 2016 through my Office 365 subscription. But copy and paste works the same no matter which version of Excel you use. Let’s walk through how to copy blocks of information as needed. Launch Excel and create a spreadsheet called Household Expenses. In the first row, type the following headers, one in each cell: Groceries, Electricity, Phone, Cable, Credit Card. In the second, third, and fourth rows, place numbers with decimal points in each cell to represent … Read More
Building an electronic form isn’t difficult, if you follow the right steps. You need to create an electronic form that’s easy for people to fill out but that can’t be modified by anyone but yourself. No problem. Microsoft Word can handle that challenge. You can create a form in Word complete with the necessary fields, graphics, and other content. You can create a form from scratch but you’ll find it easier to start with a built-in template for a form. From there, you customize the form if necessary. You can control or limit the type of content people can add to a specific field. And you can protect your form so people can’t alter it beyond filling in the fields. Let’s look at how to create a form in Word. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Word’s Find and Replace has a lot of tricks up its sleeve. Here’s how to take advantage of them. You’ve probably used Find and Replace in Microsoft Word to look for misspelled words and other mistakes and replace them with their corrected versions. But there’s more to Find and Replace than just replacing text. You can enable certain options, such as matching the case and looking for whole words. You can find and replace special characters, such as paragraph marks, dashes, and page breaks. You can replace special formatting, including fonts and paragraphs. And you can combine many of these options in one single search. For this article, I’m using Word 2016 as always, but Find and Replace works the same over the past few versions of Word. To start, launch Word and open or create a long document with multiple paragraphs and pages of text. Ideally, the document should contain graphics and special formatting. But if you don’t have such a document, you can still follow along with me. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You can protect your Word documents from prying eyes and itchy fingers. You’ve created a critical Word document, one that you wish to keep private or that you want to share with only certain people. But perhaps you don’t want others to be able to edit the document, and you certainly don’t want it to fall into the wrong hands. How can you protect your document? Word offers a few options: You can finalize the document to alert people not to edit it. You can encrypt the document with a password so only people who know the password can access it. You can restrict the type of editing others can perform on the document. You can add a digital signature to the document to ensure that no one can tamper with it. And you can employ more than one of these tactics to truly secure your document. Let’s look at the many ways you can protect your Word documents. As always, I’m using Word 2016 here, but the options for protecting a document are the same for the prior couple of versions of Word. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to … Read More
You can safeguard any data in Excel from a single cell to an entire workbook. Here’s how. You’ve created a spreadsheet in Excel that you plan to share with other people. But you may not want everyone to be able to view, edit, or reformat all the data. No problem. Here’s a list of what you can do: You can protect anything from a lone cell to a full workbook. You can hide a cell, a row, or a column so no one can see it. You can lock a cell so no one can edit it. You can protect the entire worksheet to put your security into effect. You can hide a specific worksheet. And you can protect an entire workbook by marking it as final, encrypting it with a password, or adding a digital signature. As usual, I’m using Excel 2016 via my Office 365 subscription. But the options for protecting your data should apply equally to the prior couple of versions of Excel. To start, open or create a spreadsheet with enough data to stretch several columns and rows. Make a copy of that worksheet so you have more than one sheet. Change some of the data … Read More
Mail merge can save you plenty of time when you need to address multiple envelopes or labels. You have envelopes or labels that you want to address to many people. You can do that individually, or you can do it much quicker through a mail merge in Word. The mail merge feature lets you create an envelope or a series of labels and then merge that file with dozens, hundreds, or thousands of names and addresses. Using a list or table of names, you populate your envelope or labels with fields to insert each name and address. But Word’s mail merge can be tricky. How can you use it simply and effectively? Let’s check it out. I’m using Word 2016 here, but mail merge is available in any version of Word and works the same over the past few versions of the program. You can merge different types of files, including email messages, documents, and directories. But envelopes and labels are the most common formats for a mail merge, so we’ll focus on those. If you want to try out a mail merge on your end, you’ll need a list of names and addresses stored in a Word table, an … Read More
Your Word Tables can look better if you know how to properly format them. You probably already know how to create tables in Microsoft Word. But formatting them is another matter. Formatting a table not only gives it the right look but can also make it easier to use. Maybe you’ve struggled with table formatting in the past, or perhaps you’d just like to learn all the different ways you can format a table. Your options abound in Word. You can create a table with a certain layout. You can apply border styles either to the whole table or to individual rows or columns. And you can give your table a snazzy new look by selecting an entire table style. Let’s go over the process for formatting tables in Microsoft Word. As always, I’m using Word 2016 through my Office 365 subscription. But the process for formatting tables is similar across the past few versions of Word. Let’s start by launching Word with a blank new document. Click on the Insert ribbon and then click on the Table button. Word offers three ways to create a table. You can insert a table by moving your mouse cursor over a specific … Read More
You can automate a host of time-consuming tasks via macros. Do you find yourself running the same laborious and repetitive commands and tasks in Microsoft Word or Excel? There must be a better way, you say to yourself. And there is, with macros. Through a macro, you can record or create a series of commands and tasks in a Microsoft Office application. Then, whenever you want to run those commands, you just trigger the macro. You can create macros to automate just about anything in a program like Word or Excel — apply special formatting, change the layout, insert objects. Macros can sound intimidating if you’ve never ventured into their territory. They’re stored as mini programs using the Visual Basic for Applications (VBA) language. But you don’t need to be a programmer to use macros. You can record the macro by performing the various commands step by step. You can then edit the macro to make any changes. Let’s check out how to use macros to save time in Microsoft Office. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Your emails can look more appealing with the right themes and stationery. Do your messages from Microsoft Outlook look dull? Maybe you’re trying to promote a product or service in your emails or you just want to wow recipients with a certain style to your emails. And your regular messages just seem blah, at least visually. Can you spruce them up? Sure, you can format each email individually with specific fonts, colors, and other attributes. You can tap into styles to touch up your emails. Or you can rely on themes and stationery. Through themes, you can paint your emails with a specific visual style. You can choose from the built-in themes and create your own themes. Using themes and stationery, you can set up your messages with specific fonts, colors, backgrounds, and other elements. You can choose to apply your stationery to selected individual messages or to all new HTML emails you compose. Let’s see how you can spruce up your Outlook messages with themes and stationery. For this article, I’m using Outlook 2016 via Office 365, but the process for using themes and stationery is similar in the prior few versions of Outlook. This article is part of … Read More