Opening Workbooks from a List of Hyperlinks in Excel 2007

To add a workbook to a hyperlink list: 1. Select a cell. 2. Press Ctrl+K or select Insert -> Hyperlink (in Links Group). 3. In the Insert Hype...

How to find active workbook path in Excel

In this article, we will learn How to find an active workbook path in Excel. CELL function in Excel Cell function in Excel gets you the info...

List of File Formats that are Supported in Excel 2007

Format______________________________Extension Excel Workbook_________________________.xlsx The default Office Excel 2007 XML-based file format. Ca...

How to change Display Direction in Excel

In this article, we will learn How to change Display Direction in Excel. Scenario: Excel has some default features when a new excel workbook...

Coloring Sheet Tabs in Excel 2007

To color the Sheet tabs: Right-click a sheet tab, and select Tab Color from the shortcut menu to choose a color. Or Select Home -> Format (in ...

Changing the Font Size of the Sheet Name in Excel 2007

To change the font size of the sheet tab: 1. Minimize all open applications by pressing Windows button + M, and right-click the desktop. 2. Select...

Using a Workspace to Open a Number of Workbooks at Once

Saving open workbooks in a workspace enables them to be opened together at a later time. This is important when working with linked workbooks. To s...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.