K2E Canada Office Tips February 2019
|
Summary: Here is a really good keyboard shortcut that will expedite the deleting of a row or column:
The 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 Ctrl+- (that is Ctrl and the minus sign at the same time). Excel deletes the row or column from your worksheet that you have selected. |
Word Tip
Making Backup Copies of a Word Document
Summary: By default, Microsoft Word does not make backup copies of your files. Instead the old file is deleted after the new file is written to your hard drive. If you want Word to keep backup files here is how to do this:
When that is done Word will save a backup copy with the file extension .wbk in the same folder as the original document. With Excel 2016 and subsequent saving the file to SharePoint online or OneDrive will automatically create versions of the file. To open version history click on the file tab and under info click version history. |
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
Securing an Excel Workbook
Summary: Excel allows you to encrypt and password-protect workbooks. Here's the video tip from the webinar K2's Road to Excellence with Excel Part 7 and Adagio.
|
|