top of page

Review Macros

+50 Handy Utilities to Save Time and Increase Efficiency

When working with large Excel spreadsheets, it's important to find the information you need quickly without having to spend more time.

 

With Review Macros utilities, you can keep your Excel files clean, well-organized and well-designed, so you can find and share valuable information promptly.

Review Macros include utilities for finding and selecting data, organizing comments, working with charts and objects, and labeling data. With all of these features at your fingertips, you'll be able to work smarter, not harder!.

Review Macros Utilities

Find & Select

1. Find & Select All

Improved Find & Select for Excel on your Mac.

Select Cells with
Same Background Color: 

Find & Select all cells with a specific background color.

As a default, the format of the selected cell is offered. Before running this utility, a range of cells must be selected.

Select Cells with
Same Font Color

Use this utility to find and select all cells with specific font color.

The selected cell determines the default formatting. To use this utility, first select the range of cells that contain the font color you want to Find & Select

Select Cells with
Same Font Properties

Find & Select all cells with Same Font Properties besides color.

The selected cell's format is shown by default. You need to first select a range of cells before running this utility.

Improved
Find All

The 'Find All' utility has been enhanced for all Macs! You can find what you're looking for by pressing Control + Shift + F. Formulas and values can be retrieved quickly throughout the entire workbook. This function can be used to find case-sensitive content, entire cell contents, or the whole word. An index containing the entire found set will be created.

Find Value &
Select Cells in Sheet

This functionality finds all occurrences of text in the excel sheet and then selects the found set separately. It can also match content in formula cells or values. This feature works for case-sensitive words, with the whole content of the cell or with the entire word. Applies only to the current sheet.

Select Cells with
Same Number Format

Select cells with the same numerical format: This Utility allows you to locate and select all cells with the same numerical format.

The selected cell format is given by default.

A selected range of cells must be selected before running this utility.

How to use
Find & Select All Macros

  • Before running this utility, you must select a cell range 

  • Find & Select function can be accessed via:
    a) through the 101 Macros Menu on the "Home Tab" 
    b) through the "Review Tab"
    c) Additionally, when right-clicking on a range, this utility will be displayed as a contextual menu for your convenience.

  • Simply select a cell to find all items based on content or format.

  • You can redo this Macro by pressing CTRL-OPT-Y.

PLEASE NOTE: This macro functionality will be limited when working on a protected sheet.

a.

Find-All-Select-Screenshot_2.png

b.

Find-All-Select-Screenshot_3.png

c.

Find-All-Select-Screenshot_4.png

2. Review & Prepare Macros

These Set Of Utilities enables you to keep your Worksheets well-organized, up-to-date, with easily available important information, and looking professional
Comments

2.1. Comments Macros

With 101 Macro Comments utility, you can now easily manipulate notes and create new threaded comments - making your conversations smarter and more engaging than ever before.
 

List All Comments & Notes
in Workbook

This feature allows you to create a clickable index of all comments and notes, including the author and text, and tells you where those notes are located in the worksheet.

Select Cells with
Comments & Notes in Range 

This utility allows you to select and organize all notes and new threads' comments quickly in one place for you to find them easily.

Delete Comments & Notes
in Range

Notes and new comment threads are both deleted. This function only applies to the range you've selected. If autosave is turned off, an alert to save the file will show up before the utility runs.

Add Cell Contents
to Comment

Use this function when you need to add the cell text to a new threaded comment. If there is a pre-existing note, this function will remove the note and a new comment will be created in the thread. If a linked comment already exists, the text will be added as a reply to the comment. If you have autosave disabled, an alert message will appear, prompting you to save the file before the utility is run.

Add Cell Contents
to Note: 

You can use this function to add the text from a cell to a new note. If there is already a Note or Comment in the thread, the new note will replace it. If autosave is turned off, a message will pop up before the utility is run to save the file.

Reset Position of
Notes in Selection

Use this utility to keep the notes in your spreadsheet visible. When you run the function, the notes will be moved close to the top right corner of the cell.

Reset Size and Position
of Notes in Selection

If you need to resize and readjust the notes in the selection, this utility will

autofit the notes and move them to the top right corner of the cell.

The notes will be sized to be between

100 and 300 points wide.

How to use
Comments Macros

  • Comment Macros are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On the “Review Tab”. 
    c. As a contextual menu when right-clicking on a range.

  • You can select large ranges, including entire rows or columns.

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

PLEASE NOTE: This Macro will not work on a protected sheet.

a.

Find-All-Select-Screenshot_2.png

b.

Find-All-Select-Screenshot_3.png

c.

Find-All-Select-Screenshot_4.png
Charts & Objects

2.2. Charts & Objects and Chart Data Labeler Macros

Make your Charts & Objects stand out in a way that makes them easy to find and edit. This unique feature assures you never miss essential information.

List All Charts
in Workbook

List All Charts in Workbook: If you want to find your charts in a Workbook quickly, this feature makes a clickable index of all charts, including chart type, name, and location in the workbook. You can copy this index to a new worksheet.

Select
All Charts

This function allows you to select all charts on an active sheet and modify them all at once with a single click

Select Charts &
Shapes in Range

Group and Select All Charts within selected range.

Group and Select all Shapes within selected range.

* Notes are excluded.

Group Shapes
in Range

With this feature, you can Group and Select all Shapes / Objects within the selected Range. 

(Notes are not included)

Transform All Charts to Same Height as Selected

Use this feature when you need to quickly change the size of all charts.

If no chart is selected, a dialog box with heigh options will be displayed.

Make All Charts to Same
Width as Selected

Edit all charts size fast. If no chart is selected a dialog box will be presented to determine the width.

Add Custom
Data Labels

Use cell values as data labels in charts.

A dialog box will be presented to input the data label range.

Move
Data Labels

Move data labels x points. A dialog box will be presented to input label movement in points.

Delete
Data Labels

You can delete labels from selected series using this utility.

This tool is perfect for labels that

are hard to select.

How To Use
Chart & Objects and
Data Labeler Macros

  • Charts and Objects / Data Labeler Utilities are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On “Chart Contextual Tab”.
    c. Chart data labeler is available as a contextual menu when a chart is selected.

  • Utilities to select and group shapes are also available when a range is selected.

 

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

PLEASE NOTE: ​Sheets with protected objects are skipped.

a.

Charts - Objects - screenshot.png

b.

Charts -Objects - screenshot ribbon.png

c.

Charts - Objects - screenshot right-clic.png
Selected Sheets

2.3. Selected Sheets Macros

Use the Selected Sheets Utilities to make your project look organized before you share it. Save time by finishing long and time-consuming tasks, unifying the format of your spreadsheets, getting rid of columns, charts, and objects you don't need, and bringing your file neat and tidy way.

Rename
Selected Sheets

This utility allows you to easily "Rename" selected sheets based on the "Cell Value." Protected sheets and names with invalid names will be skipped.

AutoFit Rows
and Columns

This tool makes it simple to "Auto-fit" all rows and columns on selected sheets.

Unhide All Rows
and Columns

This utility searches through all selected sheets to reveal all hidden rows and columns.

Delete Hidden
Rows and Columns

This utility scans selected sheets for hidden rows and columns and

deletes them.

Ideal for ranges with the

auto-filter enabled.

Remove Format
from Empty Cells

This add-in saves time by cleaning all empty cells on selected sheets with a single click.

Delete All
Shapes & Charts

Using this utility, you can quickly and easily remove all shape objects and graphics (excluding comments) from selected spreadsheets.

How to use
Selected Sheets Utilities

  • Selected Sheets Macros are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On the “Review Tab”. 

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

Please note:

  • Protected sheets will be skipped.

No undo is available

  • If Autosave is turned off, a message to save the file will appear before the utility is run.

  • The message will not show again during the session if “Do not save" is selected.
     

a.

Find-All-Select-Screenshot_2.png

b.

Find-All-Select-Screenshot_3.png

2.4. Sync View Macros

Freeze, unfreeze, and sync the cursor position across all of your sheets at the same time. 
Sync View
Freeze_panes.png

Freeze Panes of
Selected Sheets

Freeze views for selected sheets on the current cell. This utility will not work on a protected workbook.

Unfreeze.png

Unfreeze Panes
of Selected Sheets

Unfreeze views for selected sheets. This utility will not work on a protected workbook.

Sync zoom.png

Sync Zoom Level
of Selected Sheets

Choose a zoom level and apply it to your selection. This utility will not work on a protected workbook.

Freeze_panes.png

Sync Selection and
Position of Selected Sheets

This add-in saves time by cleaning all empty cells on selected sheets with a single click.

How To Use
Sync View Macros

  • Selected Sheets Macros are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On the “Review Tab”. 

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

 

Please note:

  • Protected sheets will be skipped.

No undo is available

  • If Autosave is turned off, a message to save the file will appear before the utility is run.

  • The message will not show again during the session if “Do not save" is selected.
     

a.

a. SyncView-Macros.png

b.

b. SyncView-Macros.png

2.5. Workbook Macros

Insert table of contents, sort your worksheets alphabetically, hide, unhide, protect and many other utilities to help you organize and make your Workbook look great before you share it.
Workbook
1-Insert Table Of Content.png

Insert Table
of Contents

A clickable index with hyperlinks to get you up and running in the documentation of your file. Sheets will be show in worksheet order. You can  rename or sort them first with our utilities

2. Sort Alphabetically.png

Sort Worksheets
Alphabetically

Sort all sheets alphabetically.

It is not case sensitive.

3. Unhide All hidden.png

Unhide All
Hidden Worksheets

This feature allows you to show all hidden sheets at once with a single click. Please note that protected sheets will not be displayed.

4. Hide All but the Active Worksheets.png

Hide All but the
Active Worksheet

This is just another time-saving tool. When you organize your Worksheet before sharing it, the Protected sheets will be skipped.

5. Protected All Worksheets.png

Protect All
Worksheets

Use the same password to protect all worksheets. Please remember don't forget the password!  If more than one sheet is selected, protection will be applied only to the currently selected sheet. This utility will skip sheets that are already password protected.

5. Protected All Worksheets.png

Unprotect All
Worksheets

Provide a password and all sheets will be unlocked. This utility will skip sheets with a different password set. If more than one sheet is selected, only current sheet selection will be unprotected.

6. Delete all blanck sheets.png

Delete All
Blank Worksheets

Clean your Workbook with this utility. You can easily delete all unused sheets when using this add-in. Please be aware that only unused and unprotected sheets will be removed.

6. Delete all blanck sheets.png

Break
All Connections

Delete all ODBC connections from the workbook. No changes are made to the data model. If Autosave is turned off, a message to save the file will appear before the utility is run.

7. Break Internal Links connections.png

Break External Links
and Connections

Breaks external links to other workbooks and ODBC connections at the same time. No changes are made to the data model. If Autosave is turned off, a message to save the file will appear before the utility is run.

How to use
Workbook Macros

  • Selected Sheets Macros are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On the “Review Tab”. 

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

Please note:

  • Protected sheets will be skipped.

No undo is available

  • If Autosave is turned off, a message to save the file will appear before the utility is run.

  • The message will not show again during the session if “Do not save" is selected.
     

a.

a. Workbook  Macros.png

b.

b. Workbook  Macros.png
Split & Share

3. Split & Share Your Workbook Macros

Easily split and share workbooks with others. Simplify time-consuming tasks like splitting workbooks, breaking links, and creating new files with the active worksheet, before sharing your work.

SS-Split-Book.png

Split
Book

Create a new file for every sheet in your Workbook. Files will be created on the same path as the active workbook. The new files will be created if your file is open from OneDrive or SharePoint. You will be asked to grant permission to the folder on a Mac.

SS-Split Book & Break links.png

Split Book and
Break Links

Create new files for each sheet in your Workbook, conveniently removing links and connections. Files are saved on the same path as the active workbook, if opened from OneDrive or SharePoint. Permission to the folder may be required on a Mac."

3. Unhide All hidden.png

New File with
Active Worksheet

Create a new file with the Active Worksheet. The new files will be created on the same path as the active workbook. If your file is open from OneDrive or SharePoint, the new file will be created there. You will be asked to grant permission to the folder on a Mac.

SS-New File with worksheet-file.png

New File
with Selection

Create a new file with preserved formatting and pasted data as values, based on your selection. The file will be saved in the same location as your active workbook, provided it's opened from OneDrive or SharePoint.

Mac users may be prompted to grant folder permissions.

SS-New Mail with Active Worksheet.png

New Mail with Active Worksheet as Attachment

Create a new file for your active worksheet and email it.

SS-New Mail with PDF.png

New Mail with Active Worksheet as PDF

Create a new PDF file with the current print setting for your active worksheet and email it.

SS-New Mail with a selection as Attachment.png

New Mail with Selection
as Attachment

Create a new file with the current selection and email it. Formatting (including row and column width) will be preserved.

How to use Split & Share Workbook  Macros

  • Split & Share Workbook Macros are available via:
    a. The 101 Macros Menu on the “Home Tab” 
    b. On the “Review Tab”. ​

  • You can re-do this Macro with the shortcut CTRL-OPT-Y.

Please note:

  • Microsoft Outlook will be the preferred email service.

  • A temporary folder will be created to store temporary files before emailing to the following locations:

    1. On mac: user/ Library/Group Containers/UBF8T346G9.Office/101Temp

    2. On pc: user/temp/101Temp

  • 101 Macros will clean the folder before leaving.

Only on mac

  • You can also choose to email with Apple Mail

  • On Macs, you can choose the default email app, addressees, subject, and body text. 101 Macros will use this information to prepare your emails.

  • A script is needed to send emails. If you installed 101 Macros Manually, please make sure to copy the file “101MacrosScripts.scpt” to:

“<your user>/Library/Application Scripts/com.microsoft.Excel/”

a.

a. Split & Share Workbook.png

b.

b. Split & Share Workbook.png