Ranges
-
Change the case of text (upper, lower, proper).
-
Add characters to cells -- at the beginning, end, or at a specified character position.
-
Remove characters from cells -- from the beginning, end, or beginning a specified character position.
-
Remove spaces from cells.
-
View key statistics for a range of cells -- word count, character count, and average length.
-
Select cells based on their value
-
Select cells based on their formatting
-
Select entire rows based on the contents of the cell in a specified column
-
Lock and unlock cells of a certain type (e.g., lock formula cells, unlock cells with a value)
-
Protect or unprotect all sheets in a workbook
-
View a list of the protection status of all sheets in a workbook
-
Randomly rearrange the cells in a range
-
Generate a list of non-duplicated random integers
-
Export a range of cells to a file (XLS or CSV)
-
Export a range of cells as a graphic image (e.g., a GIF file)
-
Transform a column of cells to a multi-column database
-
Display a pop-up calculator -- and paste the calculation results to a cell
Cell Comments
-
Quickly change the comment view (none, indicator only, comment and indicator).
-
Create a report of all comments.
-
Auto-size comments.
-
Perform search/replace within comments.
-
Remove (or add) the user name from comments.
Formulas
-
Quickly convert formulas to their values
-
Make exact copies of formulas (the range references are not adjusted)
-
Convert all references in a formula from relative to absolute (or vice versa)
-
Easily convert between different units of measurement (e.g., fee to meters)
-
Automatically adjust formulas so they don't display errors (e.g., divide by zero errors for missing data).
-
Convert names in formulas to their actual cell references
Worksheets and Workbooks
-
Quickly toggle various settings -- gridlines, scrollbars, row and column headers, etc.
-
Hide all rows and columns except for a specified range
-
Set the zoom factor interactively -- for one or all sheets
-
Automatically reset the "last used cell" in a worksheet
-
Insert the contents of a file (XLS or a text file) beginning at a specific cell.
-
Hide sheets and workbooks interactively
-
Save or rename a workbook even if it's not activated
-
Delete sheets from a workbook interactively.
-
Sort the sheets in a workbook -- intelligently.
-
Save your workbook and create a backup at the same time
-
Create bookmarks for frequently-used workbooks, sheets or ranges
-
Activate any open workbook workbook by clicking a toolbar button
-
Synchronize all sheets in a workbook
-
Delete all empty sheets in a workbook
Dates and Times
-
Display a calendar for any month between 1900 and 2200
-
Insert a picture of a calendar month
-
Create a calendar workbook -- up to 12 months, each on a separate sheet
-
Insert a formatted date into a cell by picking from a calendar
-
Set an alarm to go off at a particular time of day.
-
Keep track of cumulative time spent working on various projects
Working with charts and objects
-
Export charts to a graphic file (e.g., a GIF file)
-
Select a range to be used as data labels in a chart.
-
Hide and unhide objects interactively
-
Size and position objects interactively
-
Align and space objects interactively
Printing
-
Print multiple ranges -- without a page break in between each
-
Print the workbook's full path in the header or footer
-
Open and print a group of workbooks
-
Print a range of cells without changing the sheet's print area.
Auditing
-
Create a useful summary report of a workbook
-
Identify all links in a workbook -- even difficult to find "phantom links"
-
Create a useful color-coded map that describes the contents of worksheets
-
Compare the contents of two ranges or two sheets
-
Create a report that describes all date cell in a worksheet (useful for spotting potential year-2000 problems)
-
View a list of all names in a workbook -- including hidden names
-
View names by type (workbook-level, sheet-level, etc.)
-
Create a report that describes all names in workbook
-
Create a useful listing of all formulas in a worksheet or workbook.
-
Create a summary report of all VBA procedures and UserForm controls in a workbook
Formatting
-
Easily apply superscript or subscript formatting to a cell
-
Insert a symbol or character from any installed font
-
Apply attractive 3D borders to a range of cells
-
Apply shading to alternate rows in a range
-
Copy column widths
-
Remove all cell formatting with a single-click
-
Toggle word wrap with a single-click
-
Access the Number Format dialog with a single click
-
Apply "center across selection" formatting with a single click
Functions
-
Determine if a cell contains a particular string
-
Convert values to spelled out text
-
Insert a string at a specific location within another string
-
Compare cells using wildcard matching (* and ?)
-
Extract the first, middle, and last name of a person's name
-
Remove all spaces from a string
-
Rearrange a string's characters randomly
-
Count the number of visible cells in a range
-
Sum only the visible cells in a range
-
Count the number of cells that fall between two values
-
Determine the maximum value in a particular cell across all worksheets
-
Determine the minimum value in a particular cell across all worksheets
-
Calculate a sum of a cell across all worksheets
-
Choose a cell randomly from a range
-
Generate a random number that doesn't change when the sheet is calculated
-
Determine the average of the "n" largest values in a range
-
Determine the number of days in a particular month
-
Determine the calendar week for a date
-
Work with SMPTE time values
-
Determine a specific day in a month (e.g., the first Friday in June)
-
Display the directory where Excel is installed
-
Display the directory where Windows is installed
-
Determine if a file exists
-
Display the full path of a workbook
-
Get a value from the Windows registry
-
Determine the screen height
-
Determine the screen width
-
Determine the number of sheets in a workbook
-
Determine the name of a worksheet
-
Display the name of the user
-
Determine if a credit card number is valid
-
Perform interpolation from a lookup table
-
Determine the last non-empty cell in a row or column
-
Count the number of unique items in a range
-
Display only the unique items in a range
Amusement
-
Play Video Poker
-
Play Hangman
-
Play a Dice Game (like Triple Yahtzee)
-
Play BombHunt (like Minesweeper)