In How to share a single Excel worksheet or tab we explained how to send or share a single Excel worksheet or tab from a larger workbook. That’s OK as a one-off measure to send out a sheet but how can you do it easily as a share or ongoing collaboration?
A style is a collection of formatting choices combined under a single name. Any word or even a single letter has a collection of formatting settings as well. Font: size, color, bold/italic/underline/strikethrough/subscript/superscript, highlighting and more. Position: Left, Center, Right, Justified. List: bullet, numbering. Line Spacing, Borders, Background color and a
We’ll start 2017 with a look at some commonly used characters used in Office but are missing from the standard keyboard. How to insert symbols on a ‘one-off’ basis or insert quickly for more commonly used characters. Degree mark for temperature. Has no special shortcut but you can make one
In Outlook 2013 you may have noticed the ‘Link Contacts …’ item on each contact card. We’ll explain why it’s there and what it can do for you. Link Contacts is different from ‘Contact Linking’ that’s been available in many versions of Outlook. Contact Linking lets you connect a contact
You can select almost anything in Windows to paste into OneNote or paste a link to the original content. Clipper You can select web page content, copy then paste it into OneNote. If you do that, OneNote will automatically add a link to the original page. Or install the OneNote
OneNote has been around since 2003 and is available to many Office users as part of their Office suite or subscription. Why not try OneNote, it’s worth a look since it can be very useful. What is OneNote We’ll skip past the Microsoft hype and tell you that OneNote is
Managing your Deleted Items folder You might think that when you delete something in Outlook, it’s gone. Nope, Outlook has a safety net, just like Windows does for files. In fact Outlook can have multiple safety nets to let you recover accidentally deleted files. That’s a good thing because sometimes
A substantially improved and upgraded Organizing Outlook Email ebook is available right now. The 3rd edition goes deep into Outlook 2013/2010 & 2007 with new ways to get the most out of your email. The Third Edition is totally updated and revised to cover Outlook 2013/2010 & 2007 email management in detail. There are all sorts
A few questions from readers about their ISP (Internet Service Provider) based email service that comes with their internet access. We’ll try to explain what normally happens. Keep in mind that each ISP has it’s own rules so you should check with them. Michael B writes: “Once I switch to RoadRunner,
Here’s how to troubleshoot your Outlook connections to POP, IMAP and SMTP accounts. Outlook has a ‘Test Account Settings’ button that makes testing a lot easier (also Auto Configuration for many accounts). It’s there when you setup or change account settings. Click on the button and Outlook will try to
It’s hard to move from an email account you’ve used for years, but there’s a simple way to make the move easier. The main reason why Internet Service Providers give email accounts with all their connections (dial-up or broadband) is to make it harder for you to switch to another
Many reports about hacking into ‘Outlook’ had many regular Outlook software users rightly worried, especially if they are in China, Hong Kong or Macau. Don’t panic – a lot of the reporting was poorly worded and showed an ignorance of the difference between Outlook software (as sold/rented with Microsoft Office)
It’s been a long-standing problem for laptop users – you have Outlook running nicely at home but when you travel it’s impossible to send messages. Here’s what’s happening and how to avoid it. The fix, that should work for most situations is to change the Outlook account settings to login
It’s an old problem that keeps coming up – an email arrives with a winmail.dat attachment. We’ll explain and how to fix it from receivers and senders point of view. Winmail.dat problems were once common. They don’t happen a lot these days because Microsoft Outlook and Exchange Server both have
It’s an old problem that keeps coming up – an email arrives with a winmail.dat attachment. We’ll explain and how to fix it from receivers point of view. Winmail.dat problems were once common. They don’t happen a lot these days because Microsoft Outlook and Exchange Server both have default options
Here’s what to do if someone complains that you’re sending winmail.dat attachments with your emails. The problem is in Outlook and you need to change some settings. The setting might be global for all emails but you may need to check the settings for an individual contact or email address.
The BBC has an interesting piece on the effect of AutoCorrect and word suggestions for quicker typing. I dunno about ‘boring’ but AutoCorrect in Office does have a downside – it makes you and your typing fingers stupid. If you type stupdi into Word it will fix it to
Of course, you can’t fully send emails from Outlook if the computer isn’t connected to the Internet … but it’s surprising how many people don’t know they can write and click Send any time – whether the computer is connected to the Internet or not. We often use the relatively
The Florida Center for Investigative Reporting has released the emails of Governor Jeb Bush during his tenure as Florida’s governor. That’s of interest to us since the information is available in its original Outlook data file form. Before anyone gets angry with us … we are not making any political
When you type or paste a web link into Office, it normally converts it into a web link automatically. But occasionally that feature doesn’t work right. We found one example when researching the famous artist Roy Lichtenstein and one of his best known works. Click on the image to see
A friend is expecting a parcel via Fedex and got the email shown below, so they wondered if it was really from the courier company or not. This particular email got past both the Gmail and Outlook spam filters. We thought it was a good example to use of the
We’ve already looked at Microsoft Office document properties features. They are fully featured in Word and have limited availability in Excel so now we look at PowerPoint. PowerPoint has little document automation. Word users are often surprised to discover that even basic field codes don’t exist in PowerPoint. As a
We’ve already told you about document properties and how useful they are in Word. We also complained about the poor support for properties in Excel. You can add and edit document properties in worksheets much the same as in Word documents. Go to File | Info in Excel 2013 (Prepare
While delving into the details of Office document properties, we found some curious anomalies. They aren’t major but worth keeping in mind if you use document properties in Word documents. When you enter a document property it should just add the text and the same document property will show the