There’s a fair probability you spend the majority of your day working in Microsoft Office, literally Word, Excel, or Outlook.
That’s what you have to deal with, whether you want it or not. Rather than rage against the computer, learn to use its several easy tricks and solutions to make your day a little simpler by allowing you to work more quickly.
By the way, the instructions here are for Microsoft Office 2019 Professional Plus, but they will function in older or current versions unless otherwise noted.
First, Back Up Your Custom Formatting
You don’t have to add custom formatting to any document you make. Instead, use the Quick Styles feature to save your favorite document styling and have it available any time you start a new document.
Activate And Deactivate Track Changes
Maybe you’re working on a report and want your substantial improvements to be monitored but only your layout changes to be activated. There’s great news: by utilizing keyboard shortcut CTRL+SHIFT+E, you can easily switch track changes on and off.
Make A Link On The Highlighted Text
If you take the long way, finding useful hyperlinks can be difficult. Even worse, if you insert a long web connection directly into a document, the formatting can go haywire. Conversely, press CTRL+K while highlighting the text you want to become the connection. The dialog box for inserting hyperlinks will appear right away.
Continue From Where You Left Off
Returning to Microsoft Office 2019 Uk to put the final touches on the paper you worked on the day before? Don’t waste time scrolling back and forth to find the segment you were focused on. Simply open the file and click SHIFT+five; Word will automatically take you to the last spot you changed.
Easily Add Up The Numbers
By pressing in the very first blank adjacent cell and clicking ALT+= (the equals key), you can easily add out a whole column or row of data. Excel can then sum all of the figures it can identify in that row or column immediately.
Formulas Should Be Shown
Simply press CRTL+’ (the sensitive accent key, next to the “1” on most keyboards) to show which cells comprise an equation easily, or to see all the equations on a list. By clicking the same keys again, you can return to the values view.
Replace Texts Around A Worksheet
The CTRL+F shortcut for finding unique text in a text is well known. CTRL+H, on the other hand, opens the locate and replace dialog box in the Office 2019 Professional Plus, enabling you to substitute data in several cells at once.
Go To The Beginning Or End Of A Column
You’ve gotten a few hundred rows into a spreadsheet and have to get back to the first or the last cell. Scrolling is effective, but it takes time. Just go to the top of a column, click CTRL+ (that’s the up arrow), and to go to the bottom of a column, press CTRL+ (that’s the down arrow).
Make Use Of The “Go To Date” Feature
Don’t waste time looking for a suitable location for a potential appointment over the course of weeks or even months. The “Go to Date” dialog box allows you to jump right to the date you need. Simply press CTRL+G when on the calendar, and it will appear immediately.
Find more information relating to microsoft office 2019 professional plus here.
