Numbers make the world go round. Excel’s become indispensable for crunching numbers – so why not make the most of the application? This is part two of our collection on mastering Microsoft’s flagship spreadsheet program. (Part one is here.) Email subscribers will have the full text of all these articles: Avoid Copy and Paste Problems in Microsoft Excel Use Templates to Enhance Your Excel Spreadsheets”}”>Use Templates to Enhance Your Excel Spreadsheets How to Use Multiple Worksheets in a Microsoft Excel Workbook How to Work with Large Spreadsheets in Microsoft Excel We’re taking a quick summer break and will be back with new content on Tuesday, June 12, 2018.
Numbers make the world go round. Excel’s become indispensable for crunching numbers – so why not make the most of the application? We’ve got a wealth of how-to articles on optimizing the ways you work within Excel, and we’ll be spending this week collecting them in one place. This way, you get a comprehensive how-to that will allow you an easy reference for mastering Microsoft’s flagship spreadsheet program. Email subscribers will have the full text of all these articles: How to Sort and Filter Your Data in Microsoft Excel How to Work With Formulas in Microsoft Excel How to Protect and Secure Your Data in Microsoft Excel Helpful Free Add-ins for Microsoft Excel We’ll have more great Excel content on Thursday. …This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Having difficulty getting Office 365 to behave? These tips and tricks can help. You use or are trying to use Microsoft Office 365 but are running into problems with it. Maybe it’s not activating properly. Perhaps it’s installed and activated, but a specific program such as Outlook isn’t working right. What can you do? One option for activation issues is to run a tool called the Activation Troubleshooter. For those issues and other problems, you can always try to run a repair or reinstall of Office 365. Another move to use a free program from Microsoft named Microsoft Support and Recovery Assistant for Office 365. Also known as SaRA, the Support and Recovery Assistant runs a series of tests to look for glitches and maladies in Office 365. If it finds something amiss, the program can try to fix the issue or tell you how to fix it yourself. The one limitation with SaRA is that it works only with accounts that use Office 365 on the backend, such as Office 365 for Business or Education. Office 365 for Home and Outlook.com aren’t supported. If you use Gmail, Yahoo Mail, your ISP’s email, or some other service on the backend, … Read More
Columns can be challenging, but you can master them with the right techniques. You’re creating a Microsoft Word document that you think may work better if formatted into columns. Fine, but columns can be tricky. You have to decide how many columns to use and how and where to apply them. And columns can often run amuck by breaking at the wrong places, not continuing correctly to the next page, or not stopping where you want them to stop. You often have to play around with the columns to coax them to come out right. Believe it or not. columns can be easier. If you know how to create and customize your columns, you should be able to get them to work and look the way you want. Why even fuss with columns? You may be creating a newsletter or brochure in Word and need to format your document in columns for printing. You may be writing a report that has to adhere to a column format. But even a regular document formatted in columns can be more inviting and easier to read than one in which the text stretches across the entire width of the page. The steps I … Read More
These tips and tricks can help you more easily handle a huuuuuge spreadsheet. You’ve created an Excel spreadsheet that stretches beyond what you can see on the screen, maybe one that encompasses hundreds of rows or columns. And now working with and navigating that spreadsheet has become slow and clumsy. Do you need to pare down your spreadsheet? Nope, don’t change it. Instead, you can tap into various tools and features in Excel to use and move around your big spreadsheet. Here’s what you can do: Certain keyboard shortcuts can hop around your spreadsheet in the blink of an eye. You can also name cells or ranges of cells to move to them by name. You can filter the data in a row to see only certain content. You can freeze specific rows and columns, such as header rows, so they’re always visible. And you can split your spreadsheet to see more than one area. Let’s check out the different ways to work with large Excel spreadsheets. I’m using Excel 2016 for the examples here, but you should be able to apply the same tricks in the past couple of versions of the program. To start, load Excel and create … Read More
One of the great strengths of Windows Secrets is the depth of expertise the writers bring to the Windows platform and the applications on it. One of our regular writers, Lance Whitney, has repeatedly plumbed the depths of Microsoft Office, and repeatedly emerged with how-to stories that help us do more with less effort. Today’s newsletter collects some of his best pieces on Microsoft Word in one place — this way, you get a comprehensive how-to that will allow you an easy reference for mastering Microsoft’s flagship word-processing program. Email subscribers will have the full text of all these articles: Format Your Microsoft Word Documents with Templates How to Boost Your Productivity in Microsoft Word Eight Tips For Tweaking Your Word 2016 Experience Try These Top Add-Ins for Microsoft Word How to Recover a Lost Word Document And one last programming note: This newsletter is taking a spring break. Regular publication will resume on Tuesday, April 10, 2018. …This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Kicking off your mail merge in Outlook offers some advantages. You may have run mail merges directly in Microsoft Word. But did you know you can also start them from Microsoft Outlook? Sure. Microsoft Word still runs the actual mail merge, but you can trigger the mail merge in Outlook, then go to to Word to complete it. Okay, so why start a mail merge in Outlook instead of Word? In Outlook, you can directly view and access your contact list. And if you need to send a form email, Outlook can handle that task. Maybe you have a form email that you want to send to friends and family. Perhaps you need to distribute a certain email to a larger number of colleagues. Or possibly you’ve created a promotional email that you want to send to potential customers or clients. Whatever the reason, Outlook can help. I’m using Outlook 2016 and Word 2016 as usual. But you should be able to replicate the process in the prior version or two of both programs. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You can edit PDF files without having to shell out big bucks for the full Adobe Acrobat program. Someone has sent you a PDF file for your review or responses. Now you need to fill out text fields, add a signature, or insert comments to the file. Perhaps you’ve discovered a typo or other error that needs to be corrected or changed on your end. Or maybe you need to delete or rearrange pages in the file. Yes, you can edit the file with the full version of Adobe Acrobat. But that’s an expensive program, especially if you don’t need it on an ongoing basis. Instead, you can turn to some free tools to edit the file. The free Adobe Acrobat Reader is designed mainly for displaying PDF files, but you can perform basic maneuvers, such as adding text, highlighting specific areas, and inserting your signature. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Last week, I had one of those situations occur that sent me searching for a utility to back up the various data I copy to my Windows 10 clipboard as I work. As you know, Windows only holds the last item you copied to the clipboard in memory, so once a new item is copied to the clipboard then the previous data is flushed out and no longer available. This is standard behavior and works for most of us, and it isn’t an issue until the moment you find that you really need a bit of data that was in the clipboard prior to copying your latest image or text into the temporary storage memory on Windows. Like I said earlier, the way the clipboard normally works is by overwriting each successive excerpt as you copy it. At BUILD 2017, Microsoft shared details about a feature they were planning to ship as part of the Fall Creators Update, Cloud-powered Clipboard. The concept behind it was that the data you copied into your local devices clipboard temporary storage would be made available across all your Windows 10 devices. Unfortunately, that feature did not ship in Windows 10 Version 1709 and based … Read More
Here are several maneuvers that can help you juggle a lengthy Word document. Your latest Microsoft Word document has ballooned to dozens or perhaps hundreds of pages. And working with such a lengthy document can be slow and awkward. Thankfully, Word offers several options and features that can ease the pain of navigating, organizing, and viewing a long document: You can add page numbers to keep track of the pages. You can set up a Table of Contents to display different sections. You can zoom out to view multiple concurrent pages and turn on Split View to view different parts of the document at the same time. You can enable the Navigation Pane to more easily see and jump to a specific page. As usual, I’m using Word 2016 via my Office 365 subscription. But all or most of the features I cover here should work the same in the past couple of versions of Word. Open Word. Ideally, you’ll want to have a long document in front of you as I go through the different options. If not, just follow along. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.