Note: The other languages of the website are Google-translated. Back to English
Log in Register

Kutools for Excel: Powerful Excel Toolbox

Kutools for Excel is a powerful Excel toolbox that frees you from performing time-consuming operations in Excel. The toolbox has more than 300 powerful functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.

Latest update:  Kutools for Excel 26.00
Date: December 31, 2021
We welcome all questions, feedback and bug reports. We usually need the following information: Contact us
  • A brief description of the issue and how it can be replicated (if applicable).
  • Your Operating system (Windows 10, 8, Windows 7, etc) and the version information of your Microsoft Office.
  • Screenshots that illustrate the problem - How do I take a screenshot? http://www.take-a-screenshot.org

Subscribe Newsletter:

Kutools for Excel Feature Tutorials:

You can quickly access the feature tutorials by typing in a feature name in the following search box. For example, if you want to know how to use the Reading Layout View, you just need to type in Reading keyword in the search box.

View Group:
Track Snap (Backup Current Workbook): Temporarily backup current workbook at any time
Navigation Pane: List all sheets, workbooks, columns and names
Advanced Find and Replace: Easily find and replace in multiple worksheets and workbooks
Work Area Size: Change working area size quickly
Reading Layout View: Easily reading / viewing a large number of rows and columns
Show Columns: Toggle all hidden columns to be visible or invisible
Show Sheets: Toggle all hidden sheets to be visible or invisible
Hide / Unhide Workbooks and Sheets: Hide or unhide workbooks and worksheets
View Options: Toggle workbook and worksheet settings
Set Scroll Area: Set scroll area (hide unselected columns and rows at once)
Hide Non-selected sheets: Hide all inactive (or all not-selected) worksheets
Hide Inactive Windows: Hide other workbooks (all inactive windows)
Unhide All Ranges: Unhide all rows and columns
Unhide All Worksheets: Show all hidden worksheets
Unhide All Windows: Unhide all hidden workbook windows

Range and Cells Group:
Adjust Cell Size: Set row height or column width in inches, pounds, centimeters or pixels
Merge Same Cells: Merge adjacent cells in a column with same data / value
Unmerge Cell: Unmerge cells and fill down values
Flip Horizontal Range: Flip (reverse) data order of columns or rows
Flip Vertical Range: Flip (reverse) data order of columns or rows
Transpose Table Dimensions: Convert 2-dimensional / cross table to list
Transform Range: Transpose (convert) a single column or row to ranges
Swap Ranges: Swap rows, columns or ranges
Sort Range Randomly: Sort or select cells, rows and columns randomly
Compare Cells: Easily compare two ranges of cells if they are equal or different
Select Same & Different Cells: Comparing two ranges to select duplicate or unique values
Prevent Duplicate: Prevent duplicate entries in a column
Prevent Typing: Easily prevent special or certain characters from being typed in cells
Only allow specific characters to be entered in a range of cells
Copy Ranges: Copy multiple selections or ranges
Convert between Text and Number: Convert / force text to number or number to text
Convert between Roman and Number: Convert between roman numerals and numbers
Convert Formula to Text: Quickly convert cell formulas to text strings
Convert Text to Formula: Quickly convert text string to formula
Convert to Date: Identify and convert date format
Convert Time: Convert time to seconds / minutes / hours
Currency Conversion: Convert currency (USD to EURO / USD to GBP)
Unit Conversion: Convert measurement units
Conversion of Number Systems: Convert between different number systems without using formula
Spell Out Numbers: Convert or spell out a number into English words
Change Sign of Values: Change signs of numbers (Fix trailing negative signs / Change all negative values to positive)
Advanced Combine Rows: Quickly combine rows based on same value
Convert Number to Ordinal: Quickly convert numbers to ordinal numeral
To Actual: Replace formulas with calculated values / results in cells
Round (Without Formula): Round cell values without formula
Combine (Rows & Columns): Combine (merge) multiple columns or rows

Editing Group:
Super Find:
Find specific text strings only in the comments
Find specific text string only in cell value
Find specific text strings only in the formulas
Find cells which contain date type values based on criteria
Find numbers based on criteria
Search specific text values only in hyperlinks
Find all cells with specific cell formatting
Fuzzy Lookup: Find and replace the similar records from a list of cell values
Select Range Helper: Select, deselect, and reverse multiple ranges
Select Interval Rows & Columns: Select interval (every other) rows or columns
Select Merged Cells: Find and select merged cells
Select Last Cells: To select last cell of used range or last cell with data of last row or column
Select Cells with Max or Min Value: Select max or min (smallest or greatest) value cell
Select Cells with Error Value: Select cells with error values
Select Specific Cells: Select specific cells, rows, and Columns
Select Cells with Format: Select cells based on formatting
Select Unlocked Cells: Quickly select all unlocked cells
Select Unblank Cells: Easily select non-blank or non-empty cells
Select Duplicate & Unique Cells: Find duplicate or unique cells/rows in a range
Insert Titles Rows: Insert title rows into a range
Insert Blank Rows & Columns: Insert blank rows or columns every other rows / columns
Insert Date: Insert date with date formatting
Batch Insert Check Box: Quickly insert multiple checkboxes at once
Batch Insert Option Button: Quickly insert multiple option buttons at once
Insert Watermark: Quickly insert and remove watermarks
AutoText: Easily create and insert Auto Text entry
Insert Sequence Numbers: Create and insert unique sequence numbers
Find Missing Sequence Number: Quickly find and fill missing numbers in sequence
Fill Custom Lists: Create custom lists and fill cells with them
List All Combinations: Quickly generate/list all possible combinations of certain lists
Insert Bullet Or Numbering: Quickly Insert Bullets Or Numberings In Multiple Cells In Excel
Insert Random Data: Using random number generator to generate numbers and password
Fill Blank Cells: Fill blank cells with value above or 0
Delete Blank Rows: Remove or delete all blank rows from bottom / a range
Delete Rows & Columns: Delete blank or hidden rows (columns)
Delete Tools: Delete all charts, text boxes and embedded OLE objects
Delete Web Controls: Remove all html objects such as checkbox
Batch Delete Check Box: Remove / delete multiple checkboxes
Batch Delete Option Button: Batch delete option buttons
Remove All Macros: Remove all macros within worksheet or workbook
Batch Remove All Macros: Batch remove or delete all macros from workbooks
Remove Spaces: Remove spaces before / after text or remove extra spaces from text
Change Case: Change case of text to all caps, lower and proper
Subscript numbers in Chemical Formulas: Subscript all numbers in chemical equations correctly
Remove by Position: Remove or delete characters from beginning / end of text strings
Reverse Text Order: Reverse text string or words order
Replace Accented Characters: Replace multiple accented characters with regular chars
Extract Text: Quickly extract certain text from cells
Extract Email Address: Extract email address from text string
Add Text: Add the same text in a range of cells
Split Names: Split first, middle and last names
Split Cells: Quickly split cell contents by space or other delimiters
Delete Characters: Remove numeric, alphabetic, non-printable or alphanumeric characters from cells
Alternate Row / Column Shading: Shade every other row/column
Superscript / Subscript (Formatting): Format text as superscript or subscript
Apply Date Formatting: Apply date formatting to a range of dates
Copy Cell Formatting: Copy a cell formatting from one cell to other cells
Clear All Cells Formatting: Completely clear all formatting of a range cells
Convert Hyperlinks: Extract url links from hyperlinks or to convert plain text links to hyperlinks
Find and Break Broken Links: Find and break broken links (external references)
Delete Hyperlinks: Remove all hyperlinks of ranges, sheets and workbook
Kutools Calculator: Fetches values from cells for operations and paste results into cells
Operation Tools: Apply mathematical operations to a range without formula
Change Comment Shape: Change the shape of comment box
Cell Comment Tools: Modify multiple cell comments
Create Comment List: Quickly extract and list all comments to new worksheet or workbook
Format Comment: Quickly format all comments based on a comment
Find / Replace Comment Text: Quickly find and replace text in comments
Remove / Add User Name in Comment: Quickly change/remove/add author name in comments
Convert Comment and Cell: Quickly convert between cell contents and comments
AutoFit Comment: Automatically resize comment boxes to fit the contents

Formula Group:
   Functions:

Count by Cell Color: Using a function to count / sum cells by fill or font color
Count Char: Count the occurrences of a character in a string
Extract Numbers: Extract numbers from mixed text string with function
Reverse Text: Easily reverse order of characters in a cell with functions
Sum by font bold: Quickly sum bold values / numbers only
Count by font bold: Easily count the number of only bold cells in a range
SUMVISIBLE: Easily sum/count/average visible cells, rows, or columns only
   Formulas:

Add hours / minutes / seconds to date: Easily add hours /minutes / seconds to a datetime
Add years / months / days / weeks to date: Add years / months / days / weeks to date
Calculate age based on birthday: Calculate age by date of birth
Sum numbers in a cell: Sum all digits/numbers in a cell
Sum absolute values: Easily sum absolute values in a range
Look for a value in list: Quickly lookup a value and return a different cell from the table
Count weekends between two dates: Quickly count numbers of weekends/weekdays/specific day of week between two dates
Find nth occurrence of a character: Easily find position of nth occurrence of a character in text string
Count words in range: Quickly count the number of words
Find most common value: Quickly count the number of words
Remove time from date: Quickly Remove Time From Date Time Format Permanently
Exact Formula Copy: Copy exact formulas without changing cell references
Convert References: Convert cell reference to relative / absolute reference
Replace Range Names: Replace name in formulas with cell reference
Hide / Unhide Range Name: Easily hide or unhide named range
Error Condition Wizard: Replace formulas error messages with zero, blank cells, or customize text
Dynamically Refer to Worksheets: Quickly Fill cell references from multiple worksheets
Trace Precedents and Dependent: Quickly trace all dependents or precedents

Workbook and Sheets Group:

Workbook Tools
Split Workbook: Split or save each sheet / worksheet from workbook as one separate Excel file
File Format Converter: Convert multiple XLSX files to XLS or PDF files
Insert Workbook Information: Insert file name or path into cell / header or footer
Open Containing Folder: Open current directory / folder of active workbook
Copy Full Path: Copy and insert the active workbook file name and path
Auto Open Those Workbooks Next Time: Automatically open specified workbooks when Excel starts
Combine Worksheets:


Combine multiple worksheets / ranges from workbooks into one worksheet
Combine / merge all worksheets of same name across workbooks into one worksheet
Combine / merge worksheets or workbooks into one workbook
Summarize and calculate data from multiple worksheets into one worksheet

Worksheet Tools
Synchronize Worksheets: Synchronously select same cells in all worksheets
Sort Sheets: Sort or arrange sheets / worksheets alphabetically
Freeze Panes Multiple Worksheets: Freeze panes across multiple worksheets
Unfreeze Panes Multiple Worksheets: Unfreeze panes on multiple worksheets
Rename Multiple Worksheets: Rename multiple worksheets
Create List of Sheet Names: Create an index of sheets in active workbook
Copy Multiple Worksheets: Copy or insert multiple worksheets
Create Sequence Worksheets: Create a new workbook with customized worksheet names
Perpetual Calendar: Insert a monthly or a yearly calendar in Excel
Split Data: Split data into multiple sheets
Delete Blank Worksheets: Delete all blank worksheets with one click
Delete All Hidden Sheets: Delete all hidden worksheets with one click
Delete All Inactive Sheets: Delete all sheets except current / active one from workbook
Combine Worksheets: Merge multiple worksheets or workbooks into one workbook
Table Merge: Update Or Merge Tables By Matching Column From Two Worksheets / Workbooks
Export Range to File: Export or save a range as CSV, HTML and Workbook
Export Range as Graphic: Export range as image file
Export Graphics: Save and export charts graphs (pictures or shapes) as JPEG image files
Insert File at Cursor: Insert contents of CSV, Excel, Text or PRN files at cursor position
Filename List: Get and create a list of filenames in a folder or directory
Create Folders Based on Cell Contents: Create folders based on cell values
Print Multiple Workbooks Wizard: Print multiple workbooks from a directory
Print Multiple Selection Wizard: Print multiple ranges / selections into one page
Print Pages in Reverse Order: Easily print pages in reverse order
Insert Page Break Every Row: Quickly insert page break every x rows in Excel worksheet
Add Border to Each Page: Quickly add and print border around each page
Copy Page Setup: Copy and apply page setup settings from one worksheet to others
Paging Subtotals: Inserting and printing subtotals on each printed page
Print First Page of Each Worksheet: Quickly print first page of each worksheet
Import Pictures: Insert multiple pictures into cells and arrange them neatly
Match Import Pictures: Import pictures into cells based on cell value
Print Multiple Columns: Printing a list into multiple columns to fit on each printed page
Print Current Page: Print current printed page of active cell

Security Group:
Encrypt Cells: Encrypt and decrypt selected cell values or contents
Decrypt Cells: Encrypt and decrypt selected cell values or contents
Protect Worksheet: Protect multiple sheets / worksheets at a time
Unprotect Worksheet: Unprotect multiple worksheets / sheets at once
Create Mailing List: Easily Create Mailing List In Excel
Send Emails: Send Emails Based On Mailing List In Excel

Mailing Group:
Create Mailing List: Quickly create a list of recipients in an Excel table
Send Emails: Send personalized emails to multiple recipients in bulk

Filter & Statistic Group:
Count by Color: Calculate cells value based on cell background or shading color
Paging Subtotals: Inserting and printing subtotals on each printed page
Advanced Sort: Easily sort data by last name / month / frequency / text length
Super Filter: Filter data based on cell value with multiple criteria
Filter Bold: Filter All Cells By Bold Characters
Filter Italic: Filter All Cells By Italics
Filter Strikethrough: Filter Cells With Strikethrough
Filter Comment: Filter All Cells With Comments
Filter Formula: Filter All Cells Which Containing A Formula
Filter Merged: Filter Merged Cells
Special Filter:
Filter Cells By Uppercase / Lowercase
Filter Cells By Text Length
Filter Cells By Workday/Weekend/Specific Day Of The Week
Filter Cells By The Font Color
Filter Cells By The Background Color
Paste into visible range: Copy data and paste into only visible cells / filtered list
Selection Lock: Easily configure cells to be locked or unlocked
Selection Unlock: Easily configure cells to be locked or unlocked
Highlight Unlocked: Quickly highlight / color all unlocked cells
Formulas Hide: Quickly hide or unhide formulas
Formulas Unhide: Quickly hide or unhide formulas
Highlight Hidden: Quickly highlight cells with hidden formulas
Highlight Formulas: Quickly highlight all formula cells
Highlight Names: Quickly highlight all named ranges
Show Headers: Quickly hide and show column and row headers
Show Formulas: Easily show or display all cell formulas
Comments (277)
No ratings yet. Be the first to rate!
Chris Chambers
Chris Chambers
This comment was minimized by the moderator on the site
Is there is a version of this plugin for use on Macs? c
Chris Chambers
Reply
admin_jay
admin_jay     Chris Chambers
This comment was minimized by the moderator on the site
Is there is a version of this plugin for use on Macs?By Chris Chambers


Sorry, we don't have a version for Mac. :-)
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Jeremy
Jeremy
This comment was minimized by the moderator on the site
Please please pleeeeease make a version that runs on OSX, I would buy all of your products and love you forever. Seriously though, this is a great excel add-in, even if you know formulas/macros to do everything, kutools makes it so much faster and easier.
Jeremy
Reply
David Borean
David Borean
This comment was minimized by the moderator on the site
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?
David Borean
Reply
admin_jay
admin_jay     David Borean
This comment was minimized by the moderator on the site
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?By David Borean


Yes, you can install it in your computer with same license.
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Woza
Woza
This comment was minimized by the moderator on the site
Hi there - I love the add-in but wanted to know why the navigation pane opens up every time I open an excel file. I'd like to opt in manually rather than have it open up every time. Is there a way to manually activate so it doesn't open up by default?
Woza
Reply
admin-jay
admin-jay     Woza
This comment was minimized by the moderator on the site
:-) Hello, You can disable the Navigation Pane by clicking on Kutools > Navigation. It will not automatically open again after that.
admin-jay
Reply
Jim Stinson
Jim Stinson
This comment was minimized by the moderator on the site
I still have not figured out what this is supposed to do. Got any ideas?
Jim Stinson
Reply
admin-jay
admin-jay     Jim Stinson
This comment was minimized by the moderator on the site
Hello, please contact me with your issue at jaychivo#extendoffice.com
admin-jay
Reply
Rajesh
Rajesh
This comment was minimized by the moderator on the site
whenever i click on text tools on Kutools Menu it says Kutools for excel is loading and no window opens as shown in help.please let me know
Rajesh
Reply
admin_jay
admin_jay     Rajesh
This comment was minimized by the moderator on the site
:-) Please contact me at jaychivo#extendoffice.com, please replace # with @.
admin_jay
Reply
admin-jay
admin-jay
This comment was minimized by the moderator on the site
Hello, please uninstall the software from Control Panel. and to reinstall the software by using EXE installation package.
admin-jay
Reply
Shahari
Shahari
This comment was minimized by the moderator on the site
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.
Shahari
Reply
admin_jay
admin_jay     Shahari
This comment was minimized by the moderator on the site
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.By Shahari


Hello, please uninstall the software from Control Panel.

and to reinstall the software by using EXE installation package.
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Ashwin
Ashwin
This comment was minimized by the moderator on the site
I wish that: [b]Workbook Split window should have[/b (1) facility to organise worksheet names alphabatically or as displayed in workbook. (2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.
Ashwin
Reply
admin_jay
admin_jay     Ashwin
This comment was minimized by the moderator on the site
I wish that: [b]Workbook Split window should have[/b

(1) facility to organise worksheet names alphabatically or as displayed in workbook.

(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.By Ashwin


You can get it done as follows:

http://www.extendoffice.com/images/stories/comments/split-workbook.png
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Ashwin
Ashwin     admin_jay
This comment was minimized by the moderator on the site
I do not have any checkbox near "Worksheet Name". Perhaps I have got older version 7.0 installed on my machine. That is why I aksed you for updating to new version without Admin Account (in my another query.) but as you say, Admin Account is a must, I will have to do without older version.

Anyway, thanks,

Regards,

Ashwin

I wish that: [b]Workbook Split window should have[/b

(1) facility to organise worksheet names alphabatically or as displayed in workbook.

(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.By admin_jay


You can get it done as follows:

http://www.extendoffice.com/images/stories/comments/split-workbook.png[/quote]
Comment was last edited about 1 month ago by Qiu hongkun Ashwin
Reply
Ashwin
Ashwin
This comment was minimized by the moderator on the site
I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?
Ashwin
Reply
admin_jay
admin_jay     Ashwin
This comment was minimized by the moderator on the site
I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?


Sorry, the installation requires Admin account. 😄
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Yitzhak
Yitzhak
This comment was minimized by the moderator on the site
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. " Is there any other way to get the list of files ?
Yitzhak
Reply
admin_jay
admin_jay     Yitzhak
This comment was minimized by the moderator on the site
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. "

Is there any other way to get the list of files ?By Yitzhak


Hello, we will try to enhance this feature in upcoming versions.
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
SueB
SueB
This comment was minimized by the moderator on the site
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all. Any ideas what the problem may be?? Please advice
SueB
Reply
admin_jay
admin_jay     SueB
This comment was minimized by the moderator on the site
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all.

Any ideas what the problem may be?? Please adviceBy SueB


:-) Hello, please try to contact me at jaychivo#extendoffice.com with your sample data.

Please replace # with @.
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Sam,
Sam,
This comment was minimized by the moderator on the site
I need to use the format tools function for all cells in a workbook. I have 40 spreadsheets. Can the formatting - including cell width be copied?
Sam,
Reply
C. Manzano
C. Manzano
This comment was minimized by the moderator on the site
I have a field with data to separate into three different fields. Last Name, First Name, Middle Initial (all in one) Some records no not have middle initial. Does anyone know if I can do it using this great tool? Thanks, C. Manzano
C. Manzano
Reply
andy
andy
This comment was minimized by the moderator on the site
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013
andy
Reply
admin_jay
admin_jay     andy
This comment was minimized by the moderator on the site
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013By andy


Yes, you can. Please try to upgrade to the latest version.

:-)
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Manobala
Manobala
This comment was minimized by the moderator on the site
How to auto increment after x amount of rows using kutool?



example:

A B

1 1 3

2

3

4 3

5 6

6

7 5

8

9 9

10 7



In A column I have incremented with the interval of 2rows and in B column 3rows.



How to do with Kutools?





Thanks!
Comment was last edited about 1 month ago by Qiu hongkun Manobala
Reply
admin_jay
admin_jay     Manobala
This comment was minimized by the moderator on the site
[quote]How to auto increment after x amount of rows using kutool?



example:

A B

1 1 3

2

3

4 3

5 6

6

7 5

8

9 9

10 7



In A column I have incremented with the interval of 2rows and in B column 3rows.


How to do with Kutools?


Thanks!By Manobala[/quote]


Please take a look at: http://www.extendoffice.com/product/kutools-for-excel/excel-fill-blank-cells.html


If that is no the feature you are looking for, please try to contact me at jaychivo#extendoffice.com. Please replace # with @.


:-)
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Venkat
Venkat
This comment was minimized by the moderator on the site
Hi i have a spanish excel file.

My requirement is to translate the complete content to english.

Right now i couldnt see any translation option.Please advice.
Comment was last edited about 1 month ago by Qiu hongkun Venkat
Reply
admin_jay
admin_jay     Venkat
This comment was minimized by the moderator on the site
Hi i have a spanish excel file.

My requirement is to translate the complete content to english.

Right now i couldnt see any translation option.Please advice.By Venkat


Hello, Please try to create some sample data in a workbook, and send it to me at jaychivo#extendoffice.com, please replace # with @.



Please tell me what do you want to accomplish. :-)
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Alan Downie
Alan Downie
This comment was minimized by the moderator on the site
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert Kind regards in advance Alan
Alan Downie
Reply
admin_jay
admin_jay     Alan Downie
This comment was minimized by the moderator on the site
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert

Kind regards in advance

AlanBy Alan Downie


Hello Alan, we don't have such feature or utility right now. :-)
Comment was last edited about 1 month ago by Qiu hongkun admin_jay
Reply
Joel
Joel
This comment was minimized by the moderator on the site
If I purchase and install will functionality only work on my computer that I would like other to see after everything has been calculated?
Joel
Reply
chris74
chris74
This comment was minimized by the moderator on the site
Hi can you help please.

I am trying to use the "fill worksheet references" tool. But it will not fill with a subtotal value that is calculated from a sheet. What do I need to do to overcome this issue? Thanks. E.g

Worksheet 1

A B C D

Item quantity x rate = total

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Insulation 50 £2.50 £125.00

Subtotal £500.00 (I want this cell total to auto fill list from each sheet on to the master sheet) e.g

Work sheet 1 - £500.00

work sheet 2 - £750.00

work sheet 3 - £750.00
Comment was last edited about 1 month ago by Qiu hongkun chris74
Reply
There are no comments posted here yet
Load More
Leave your comments
Guest
Posting as Guest
Login
×
Rate this post:
Reset
0  Characters
Suggested Locations