Round numbers up or down to the nearest quarter in Excel
Subscriber Peter Scott asks ‘Is there a way of rounding a number up or down to the nearest .25?’ Peter is using a spreadsheet to calculate monetary amounts and for …
Quickly fill multiple cells in Excel with the same value or formula
Sometimes when you are doing data entry in an Excel worksheet do you need to put the same value into several cells? Maybe you want to put zeros in a …
Keyboard shortcut to switch between tabs in your browser
If you want to switch tabs in your browser window, just press Ctrl+Tab to go to the tab on the right of the current tab or Shift+Ctrl+Tab to go to …
A quick way to insert six rows at once in Excel
Subscriber Barb K. asks “When I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert …
Easily view two websites at the same time
All the major browsers (Internet Explorer, Chrome, Firefox) have tabbed browsing where you can open several websites, each on a separate tab in the same window. As each web site …
How can I find the cell in an Excel worksheet that has a link to an external source?
Subscriber Margaret Y. asks “How can I find the cell in an Excel worksheet that has a link to an external source?” If you link to another workbook in Excel, …
How to create an email with a hyperlink
This week we’re going to look at how you can use a hyperlink to create a pre-addressed email. You could use this if you had a budget in Excel or …
How to preview a file in Word before opening it
Do you sometimes find yourself wanting to take a peek at a file you are about to open in Word? Maybe you are looking for a specific file and you …
Use Excel’s Paste Special to perform calculations when pasting
Last week I was working with an Excel spreadsheet that had several columns of numbers. As it happened, I needed to increase all the numbers (and there were lots of …
A quick way to copy attachments from one email to another in Outlook
You might have run across the situation in Outlook where you want to copy attachments from one email to another? Maybe you’ve received an email from a supplier and you …