|Closing an Excel Workbook Without Exiting the Program
Summary: When you close Excel it exits you from the program. Then to open another Excel workbook you have to start Excel all over again. This is a big time waster. Here is how to close an Excel workbook and stay in Excel:
To close a workbook and stay in Excel press Ctrl+W. This will close the workbook and keep Excel open. If you have not saved your file before you press Ctrl+W, Excel will prompt you to save the file and then will close.
PS This also works in Word and PowerPoint.
Calculating a Person's Age
Back to top
Summary: There are times when you would like Excel to calculate a perons's age. Here is how to do this with the =DAYS360 function:
Let's assume that Column A contains a list of a person's date of birth starting in Row 3. Column B contains the current date. In column C we want to calculate the person's age.
To calculate the age of an individual.Select cell C3
- Type =DAYS360(
- Click on cell A3 which contains the start date
- Add a comma and then click on cell B3 which contains the end date
- Add the closing bracket )
- Then type /360
- Press the enter key Copy the formula down to the rest of the cells in Column C
- In this example cell A3 refers to the start date (date of birth) and B3 to the current date. We divide the answer by 360 days because we want to convert the days to years.
We now have the age of each person in Column C.
Displaying Two Excel Worksheets on the Screen at the Same Time
Summary: There are times when it is useful to display two Excel worksheets on the screen at the same time. Here is how to do this:
Make sure you have only have one workbook open.
- Click on the View tab of the ribbon
- Click on the New Window tool in the Window group. Excel will open a second version of the same workbook
- In the View tab of the ribbon, click on the Arrange All tool in the Window group
- Choose how you want Excel to arrange your windows
- Click on OK.
Excel arranges the windows as you directed.
In each of the windows you can display different worksheets, even though they are part of the same workbook. When you are done, simply close one of the windows and save your work.
If you have a need to do so, you can view more than two worksheets from the same workbook. Just repeat step 2 as many times as necessary to open the desired number of windows.
Quickly Selecting a Word(s)
Summary: If you using a mouse Word has a neat shortcut that enables you to select a word or words very quickly.Here is how to do this:
- Point to the word you want to select.
- Double click with your mouse.
The word will be selected. If you want to select several words double click on the first word and then hold down the Control Key and double click on the additional words you want to select.