|Defining a Constant
Summary: In many of your workbooks you use the same value in different cells. Excel provides a way to name that value or formula and then use it without typing the value or formula repeatedly. Here is how to do this:
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.
Moving Around the Corners of a Range
Summary: There are times when you need to quickly move to a corner of a selected range. This is very easy to do and here is how to do it:
Here are the steps:
- Select the range
- Hold down the Ctrl key and press the period key.
- Each time you press "Ctrl +." Excel moves you to the next corner of the range
- You can also move from the top left corner of the selection to the bottom right corner by pressing Shift+Tab
To move back to the top left corner you press the Tab key.
Summary: Excel has certain default settings that can be changed to meet your specific requirements. Here is how to do this:
The default font in Excel is Calibra, 11 point. If you would prefer to work with a different font you need to change the default font and font size settings in Excel. Here are the steps to do this:
- Open the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 click on the File tab of the ribbon and then click on Options.)
- Click on Popular (Excel 2007) or General (Excel 2010 and Excel 2013)
- Change the Use this Font drop-down list (Excel 2007 and Excel 2010) or the Use This As the Default Font drop-down list (Excel 2013) and select the font you want to use
- Click on the Font Size drop-down list to pick the size of font you want Excel to use
- Click OK.
- Restart Excel.
Once you do this Excel will use these settings as the default. Note that changing your default font and font size will not change the settings in any of your existing workbooks.
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 be always saved in 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.