In This Issue
Technology Tips Video
Excel's Choose Function
Summer is finally here in Brampton but you wouldn't know it based on the weather we have been having. It has been cold and raining and I have only been out on our deck about half a dozen times.
I did my second conference session in 2017 last week at Sage Summit. My Excel Magic presentation was sold out and I had people sitting on the floor. It was great to visit with many old friends.
Registration for the 2017 Accounting Technology seminar is now open and we already have over 400 registrations, a new record. This is the 25th year that we have traveled from coast to coast presenting this one-day update on the technology that accountants, bookkeepers and their clients use. Because it is our 25th anniversary, we will be celebrating. Each attendee will receive the 25th Anniversary webinar edition of my favorite Excel Tips. Many cities sell our quickly so CLICK HERE
to register and hold your place.
Our monthly Excel Magic mini-webinars have been a great success. The next two sessions will be in July in conjunction with Intuit Canada and Adagio by Softrak. Every registrant will receive the recorded webinar so sign up today to ensure that you're on the list.
Summary: Here is a really good keyboard shortcut that will expedite the deleting of a row or column:
normal way to completely delete a row or column is to use Excel's menu commands or the tools on the ribbon. There is an even quicker way however. Merely select the row or column that you want to delete, and then press
and the minus sign at the same time). Excel deletes the row or column from your worksheet that you have selected.
Summary:Many printers available today have a number of different features, including letting you select the print quality. Here is how to use this feature:
You can print on different paper stocks, use different inks, and pull paper from different trays. Many printers also allow you to pick different levels of quality for output.
Print quality is measured in DPI, or dots per inch. This is a measure of printer resolution and means the number of ink dots that a printer can produce within a linear inch. Some Windows printer drivers allow you to specify which resolution you want to use for a particular print job. If your printer allows you to adjust this setting, you can take advantage of it in Excel in this manner:
- Display the Page Layout tab of the ribbon.
- Click the small icon at the bottom-right corner of the Page Setup group. Excel displays the Page Setup dialog box.
- Select the Page tab.
- Click on the Print Quality drop-down list to select the resolution of print quality you want to use.
- Click on OK.
Summary:Sometimes you need to move or copy graphic object in Excel. Here is how to do this:
To move an object, click on one of the lines that define the boundaries of the object. When you do this, you will see small boxes (handles) appear around the edges of the object. When the handles appear, point to one of the lines in the object-do not point to the handles. Click and hold down the left mouse button and move the mouse. The object is dragged along with the mouse pointer. When you release the mouse button, the object will stay at the new position.
When you want to copy a graphics object, select the object. Then, press
to copy the object to the Clipboard. You can then press
to paste the object in the worksheet. You can then move the newly pasted object to where you want it to appear.
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:
When you format a document in Word, there may be times when it is better to lay out your text in columns. This is often the case when you are producing a newsletter. 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:
- Position the insertion point at the beginning of the text that you want to appear in columns.
- Select the Page Layout tab for the ribbon.
- In the Page Setup group (Layout group in Excel 2016), click the Columns drop-down list.
- Pick the number of columns you want to use for the selected text.
When you do step 3 you can select the most common numbers of columns (1, 2, or 3). If you need more columns than these, click the More Columns option in step 4 and you will see the Columns dialog box where you can set up to 45 columns.
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.
K2E Canada Inc. is a leading provider of professional development seminars for the Canadian accounting world.
Each month we publish this free Office Tips e-mail newsletter. These tips will save you time and enhance the appearance of your Office files.
To subscribe to our K2E Canada newsletter
Your information is always kept secure and never shared.
K2E Canada Inc.