Excel keyboard shortcut to insert the date in a cell
Working in Excel and looking for a quick way to insert the current date in a cell? Use a keyboard shortcut: Ctrl+; Want to insert the current time? Then the keyboard …
An alternative way to add comments to a cell
You have likely discovered Comments in Excel which are useful if you want to capture some thought about the value in a cell. (Right-click on the cell, Insert Comment) As …
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 …
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 …
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, …
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 …
Declutter the Status Bar in Word and Excel
Starting with Office 2007 you can customize the Status Bar in all the Office programs. As you likely know, the Status Bar is at the very bottom of the window, …
How to make your Excel functions easier to read
As you work with Excel you might occasionally create more complex formulas and functions. When you later come back to look at them they can be difficult to read as …
How to Merge and Center several rows of heading at once in Excel
You are likely familiar with Excel’s Merge & Center command which is a great way to centre a heading across the width of the spreadsheet. Yet, as you have probably …