To copy or move worksheets within the same workbook follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. The To book drop down will default to the current workbook. Leave this as [...]
To copy or move worksheets between workbooks follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. In the To book drop down select the destination workbook. You can also choose to create [...]
I have added to the downloads page a yearly calendar template. This is a dynamic template that will allow you to generate a calendar for any year between 2001 and 2016. There are two combo boxes for the user to select the year and the start date of the week. Each selection will trigger a [...]
The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
Tip:
If Analysis Toolpak [...]
To change Excel default file location, follow these steps:
1. In the Tools menu click Options.
2. When you get the Options window, click the General tab.
3. Towards the bottom of the window there is a label called “Default file location“. To the write of this label is a text box. Enter here the full path of [...]
To view multiple worksheets at the same time follow these steps:
1. Open your workbook.
2. In the Window menu click New Window.
3. In the Window menu click Arrange and select an option (Tiled, horizontal .. etc). Now you will have two windows showing the same worksheet.
4. Click on any one of the two windows and select [...]
Excel has a feature called AutoRecover that allows you to save a workbook automatically at a preset time interval. Every time a file is saved, a backup copy will first be saved using the previously saved copy of the workbook, and the current information will be saved to the original workbook. Follow these steps [...]
I have added to the downloads page a monthly calendar template. There are three combo boxes for the user to select the month, year and the start date of the week. Each selection will trigger a macro that will generate the calendar. Here are a few notes to consider:
To Enable Macros:
Select : Tools —> Macro [...]
When you create a macro or a user defined function in a workbook, by default that macro will only be visible for that specific workbook.
If you have a code that you use repeatedly and you want it to be available for all workbooks then you have to create a global workbook called Personal.xls and save [...]
If you have a number of workbooks which you usually open together at the same time, then you can save those in a workspace file. This will allow you to later open all workbooks by opening the workspace file. You will also be able to resume work with the same window sizes, print areas, screen [...]
