Quickly Selecting Cells
Summary: Instead of using the mouse to select a range of cells, here is a quicker way of getting 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.
Defining a Constant
To create a constant in Excel you need to type its value in the
New Name dialog box. Here is how to create a constant that will enter the value of the HST for Ontario, which is 13%.
- Click on the Formula tab
- Click Define Name and the New Name dialog box will appear
- Type HST as the name for your constant
- Click on the Scope down arrow and select whether you want the constant to apply to the entire workbook, or just this worksheet.
- In the Refers To box type "=.13"
- Click OK
You have now created the constant, so it's time to use it
- Click in a cell
- Type an "=" sign followed by the first letter or letters of the name of the constant. In this case you would type an 'h"
- A menu will now appear with a list of names
- Double click on HST
- Press Enter
- The value .13 will now appear in the cell.
Constants are a great way to save time when you are entering the same information in different cells in a workbook.
|
Remembering Commonly Used Workbooks
- Select the File tab of the ribbon.
- Click on Recent at the left hand side of the dialog box.
- Excel shows you a list of the most recent workbooks you've used.
- Scroll through the list of workbooks until you see the one you want to use regularly.
- Click the push-pin icon that appears to the right of the workbook in the list.
- Excel moves the workbook to the top of the file list.
- Repeat steps 3 and 4 for any other workbooks you want to pin to the list.
-
Now you can quickly access the workbooks that you use all the time by displaying the recent workbook list where they will always be shown at the top of the list.
|
Changing the Default Start-Up Directory
Summary: The default directory where you save your files is usually your "My Documents" folder. If you would like your Word documents to always save to a different directory, here is how to do this:
- Open the Word Options dialog box. (In Word 2007 click on the Office button and then click Word Options. In Word 2010 and Word 2013 click on the File tab on the ribbon and then click on Options)
- Click on the Save option at the left side of the dialog box click Save
- To the right of the Default File Location field (Word 2007) or the Default Local File Location field (in Word 2010 and Word 2013), click on the Browse button
- Select the directory you want as the start-up directory for your documents
- After you have selected that directory click on the OK button
- Close the Word Options dialog box by clicking on the OK button
- Exit and restart Word
Now that directory will be be the default folder when you open or save a file.
|