These reusable shortcuts handle pasting, navigation, cleanup, indexing, and timestamps from any standard Excel workbook.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

Macros can perform your tasks easier in Google Sheets by automating functions that can be implemented by keyboard shortcuts or command by dropdown menu. Find out how to create macros here.

Google Sheets is a popular spreadsheet tool that has changed how people collaborate today. This web-based spreadsheet tool is a free alternative to Microsoft Excel and allows you to create and edit ...

In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, automatically updating the corresponding data. This technique consolidates ...

Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook. We hide sheets for many reasons, but mostly, to keep other people out of them ...

Excel's Save As command lets you save a single worksheet in the CSV (comma seperated value) format, but not an entire workbook. Saving individual sheets by hand is a tedious project for large ...

Macros are the timesaving magic trick for Office applications because they automate repetitive tasks that gobble time. This week’s feature, which spotlights Excel, is one of several articles featuring ...

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...