Skip to content

Archive of posts tagged How to

Why Exporting Excel File To MTH Format?

Keeping track of all webpages files can be a bit of a headache. Fortunately, you can use an easier solution: save everything using a special web archive format.

The Secret Of .XLSX File

The new .xlsx file format is actually a ZIP file in disguise. It’s composed of several files that are compressed and then packaged together as a single unit

Adding VBA Macros to the Quick Access Toolbar

Step by step instruction to guide you adding VBA macro as icon in Quick Access Toolbar, QAT.

8 Simple Steps To Setup AutoFill Series

You can create your own series with a custom step value, which determines the numeric difference between each item in the series.

Change Excel’s Default File Location

Excel saves every new workbook in the My Documents folder. Many times it is not practical for many users. Learn how to change the default file location folder.

Pinning Application Shortcut To The Windows Start Menu

The fast method to run your application is to launch it from the Start Menu. Learn how to pin your frequent use application to Windows Start Menu quickly

How to Open Workspace Automatically Whenever Excel Launches?

When you know that you’ll be using a particular workspace for some time in your Excel work, you can speed up the process of setting up your work environment by having Excel automatically open the workspace file when you launch the program.

Tips To Make New Excel Ribbon Behave Like Legacy Menu

While there is nothing you can do to bring back the legacy Excel menu and toolbars, you can make the ribbon behave a bit more like a old style menu.

Use Keyboard To Enter Excel Formulas Quickly

Learn this simple and easy method to perform formula entry in Excel to save you time from data entry.

Three Easy Steps To Work With Smart Tags

You can make your Excel work faster and easier by taking advantage of smart tags. A smart tag is a special icon that appears when you perform certain Excel tasks.