Summary: Instead of using the mouse to select a range of cells, here is a quicker way to get the job done:
You can use the mouse to select a range of cells by holding down the left mouse button and dragging the mouse to make a selection. There is an even quicker way to select cells using the mouse. Here is how to do this:
- Select the cell that marks one corner of the range of cells you want to select.
- Move the mouse pointer so it points to the cell at the opposite diagonal corner of the range you want selected.
- Hold down the Shift key as you click once on the left mouse button.
That will select all the cells in the range.
Replacing Dashes with Periods
Back to top
Summary: If you ever need to substitute periods for dashes in a cell, here is the formula to do this:
If you have a phone number such as "123-555-1212" you might want to change it to "123.555.1212". This is easy to do using the SUBSTITUTE function.
Let's assume column B has a list of phone numbers with dashes. Insert a helper Column C. Select cell (C1) and enter the following formula into the cell:
C1 will now have the phone number with periods. Copy that formula down the column to convert the rest of the phone numbers.
The final step is to copy the new phone numbers in column C and do a Paste Special Values to the numbers in column B. You can then delete the numbers in column C.
Ensuring Rows and Columns are Empty
Summary: It is important to check if a row or column has data before you delete it. Here is a quick way to check for a completely blank row or column:
it is easy to delete rows or columns you think are blank, when in fact they contain data you cannot see on the screen. Here are the steps to check for data without scrolling through the gazillion rows and columns in your worksheet:
Back to top
- Click on the first cell of the column (A1, H1, etc.).
- Hold down the Ctrl key as you press the down arrow or the right arrow.
Performing these simple steps causes Excel to move to the next cell containing data. If there is no data, Excel selects the last cell in the column (at row 1,048,576) or the last cell in the row (at column XFD). You then know that the row or column is empty and you can safely delete it.
|Inserting the Date Your Document was Last Printed
Summary: It is useful sometimes to know when a document was last printed. Here is how to enter that date in your document:
Word maintains when a document was last printed. Every time you print your document, this piece of information is updated. There may be times when you want to display this "last printed" date in your document. To do this, follow these steps:
- Position the insertion point where you want the date to appear.
- Display the Insert tab of the ribbon.
- Click Quick Parts (in the Text group) and then click Field. Word displays the Field dialog box.
- Choose Date and Time from the Categories list. Word updates the choices in the Field Names list.
- Select PrintDate from the Field Names list.Select a date format from those offered, if desired.
- Click on OK to insert the field.