K2E Canada Office Tips March 2019
|
Summary: There are times when you want to close all of your open Excel workbooks. Excel normally requires you to close each one individually. Here is how to close them all at once:
You need to add the Close All icon to your Quick Access Toolbar
The Close All icon will now be in your Quick Access Toolbar. To close all your open workbooks just click on the Close All icon. Note that you will still have to save any workbook that has been changed for which you do not have AutoSave turned on for. |
Word Tip
Adding Columns in Word
Summary: There are times in a Word document when you want your text split into multiple columns. Here is how to do this:
Word lets you to divide your page into as many as 45 columns (depending on other characteristics of your page). To add columns, do the following:
If you use the up and down arrows in the Number of Columns field of the Columns dialog box to set columns, you can only choose a range between 1 and 13 columns when you are using portrait-oriented letter-size paper. If you change to landscape-oriented paper, then you can use the control to go between 1 and 18 columns. Word sets the upper limit of the control so that no individual column on the paper will be less than a half-inch wide. If you change the printable area of your page (adjust the paper size, orientation, and margins), then Word adjusts the upper limit of the Number of Columns control. |
Vertical Divider
We hope that you are enjoying our monthly newsletter featuring tips that will help you to be more effective using Microsoft Office products.
More Ways to
Earn Verified CPD
Access the many courses from the leader in providing CPD to professionals throughout North America.
Video Tip
Using Flash Fill
Summary: If you are using Excel 2013 or later you can use the Flash Fill feature to save you time when you are trying to reshape imperfect data. Many times, you get data from somewhere that isn’t in the right format--
the text is all caps, phone numbers appear without dashes, or a bunch of fields are jammed into a single column. By providing one or two examples of what you are trying to do, Flash Fill uses heuristics to make a correction of the data in an adjoining column. Here's the video tip from the webinar K2's Road to Excellence with Excel Part 3 and Receipt Bank |
|