Excel Digest

  Excel help for the rest of us

Archive for the 'General' Category

07 Nov

How to copy or move worksheets within the same workbook

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 [...]

03 Nov

How to copy or move worksheets between workbooks

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 [...]

29 Oct

Macro based yearly calendar template

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 [...]

21 Oct

How to install and load the Analysis Toolpak

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 [...]

18 Oct

How to change Excel default file location

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 [...]

28 Sep

How to view multiple worksheets at the same time

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 [...]

30 Aug

How to automatically save a backup copy of a workbook

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 [...]

18 Jul

Macro based monthly calendar template

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 [...]

01 Jul

How to make your macros and functions available to all workbooks

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 [...]

22 Jun

How to create and use a workspace file

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 [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo