Open a file as Read-Only
Let’s say you have a budget in Excel that is the final version but you want to open it and do a few casual ‘what if’ projections with it. As …
Using Excel’s ROUND function to round to the nearest thousand
Subscriber Maki K. asks ‘in Excel how do I show $8,607 as $9,000 and $43,035 as $43,000?’. The answer is the ROUND function. You may be familiar with the ROUND …
Using Excel’s Transpose feature to switch rows and columns in a spreadsheet
Sometimes in Excel you might create a spreadsheet and after using it for a while decide you want to switch the rows and columns. So it looks like this: But …
Using Conditional Formatting to highlight a row of data in Excel
If you have rows of data in an Excel spreadsheet it can sometimes be handy to highlight the row based on the value in one of the cells in that …
How to Zoom in when reading an Outlook email
Subscriber Jean K. asks ‘Is there a way in Outlook to zoom in to make the text in an email larger?’ If you have opened the message, as opposed to …
Use F4 to repeat the last command
If you occasionally find yourself in a Word document or Excel spreadsheet applying the same formatting to different parts of the file, then F4 will come in handy as it …
How to prevent Word inserting the Copyright symbol in a document
Subscriber Cal J. asked ‘What to do when you want (c) rather than ©?’ You have couple of ways to approach this. If you sometimes want to use the c …
How to insert a Copyright or Trademark symbol in a document
Want to quickly add a copyright symbol, ©, or trademark symbol, ™, to a document? Just type (c) or ™ and Autocorrect will insert the symbols for you. This works …
How to insert a Copyright or Trademark symbol in a document
Want to quickly add a copyright symbol, ©, or trademark symbol, ™, to a document? Just type (c) or ™ and Autocorrect will insert the symbols for you. This works …
How to make sure a follow up date falls on a weekday in Excel
Subscriber Theresa M. asks: ‘We send out letters and follow up 45 days after the initial letter. We have a formula to calculate the dates but the dates need to …