EXCEL
MACROS
FOR MAC
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
1. Find All & Select >
2. Comments >
3. Charts & Objects / Chart
Data Labeler >
4. Selected Sheets >
5. Sync View Macros >
6. Workbook Macros >
7. Split & Share Workbook >
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.
b.
c.
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
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.
b.
c.
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.
b.
c.
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.
b.
2.4. Sync View Macros
Freeze, unfreeze, and sync the cursor position across all of your sheets at the same time.
Freeze Panes of
Selected Sheets
Freeze views for selected sheets on the current cell. This utility will not work on a protected workbook.
Unfreeze Panes
of Selected Sheets
Unfreeze views for selected sheets. This utility will not work on a protected workbook.
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.
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.
b.
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.
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
Sort Worksheets
Alphabetically
Sort all sheets alphabetically.
It is not case sensitive.
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.
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.
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.
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.
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.
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.
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.
b.
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.
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.
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."
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.
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.
New Mail with Active Worksheet as Attachment
Create a new file for your active worksheet and email it.
New Mail with Active Worksheet as PDF
Create a new PDF file with the current print setting for your active worksheet and email it.
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:
-
On mac: user/ Library/Group Containers/UBF8T346G9.Office/101Temp
-
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.
b.
