Adding the Properties Icon to the Standard Toolbar

Why add the Properties icon to the Standard toolbar? By setting the Scroll Area range, you restrict the accessible area in the sheet. By changing ...

Hide an Excel sheet using VBA in Microsoft Excel and Excel sheet cannot be unhidden using unhide button on Excel application

  In this article, we will create a macro for hiding the Excel sheet. Excel sheet is made hidden by changing its properties using VBA code. Hidd...

Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel

Tip submitted by Kieran from Western Australia. Open the web toolbar. While holding down CTRL and ALT, right-click on the Address box, and drag ...

Opening Workbooks from a List of Hyperlinks

To add a workbook to a hyperlink list: 1. Select a cell. 2. Press Ctrl+K or select the Insert Hyperlink icon from the Standard toolbar. 3. In the...

Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor

Tip submitted by: Judy Cocking, Go to START Menu, open a copy of Excell. It will open on one of your monitors. It does not matter which one. Now,...

Adding the Page Setup Icon to the Excel Menu Bar

To add the Page Setup icon to the Excel Menu bar: 1. Right-click one of the toolbars, and then select Customize from the shortcut menu. 2. In the ...

Changing the Name of the Cell Comment's Author

By default, each cell Comment includes the author's name. To change or cancel the name of the Comment's author: 1. From the Tools menu, select O...

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.