Office Greenhorn      Excel     Word   Outlook
 
 

Excel Greenhorn - Tool bar utilities for Microsoft Excel


   Home | Download | Register | Tool Bar | Contact | Add My School/Youth Program | About | Help

You do not need to be a power user to install and benefit from these utility tool bar buttons - they were designed for novices and soon to be power users although even seasoned excel users have raved about the speed and ease of use.

Buy now or

Here is a summary of the buttons on the tool bar.
Search and Locate
Tool
Bar		 Feature Description
Next unique value Find next unique cell in current column - Most used button!
Next unique any change Find next unique cell (or same value with different format) in current column
Next unique value right Find next unique cell in row
Next blank Find next blank cell in column - second most used button!
Next duplicate Find the next cell that is a duplicate of the previous cell in column - one of the most used buttons
Find in Book Search all sheets in current workbook
 
Copy and Paste.
Tool
Bar		 Feature Description
Copy unique cells Copy unique cells into new sheet with counts - great way to find one of each if many duplicate department entries for example
Copy unique lines Copy unique lines from current sheet into new sheet with only unique lines
Fill down Take current value and copy down until next non blank cell in column - good way to create data for sorting from sub headers, or to clean up imported data with missing info
Copy current line Copy the current line with ctrl-K or with the supplied button - recommend approach to adding a line to a sheet  - always better to copy a new line than add a blank to keep formulas correct
Trim spaces Removes all leading and trailing spaces from selected cells - good way to clean imported data
Paste Value and Format Paste Values only and format text with data color
Paste Formulas Paste formulas only into the current cell
Paste Note Only Paste a copied cell note as the note for the current cell
Paste date Enter current date into current cell using my date format
Paste transposed value Paste the current row as a column with values only, or paste column as a row
Paste link Paste a link to the copied cell into the current cell - so when the original cell changes, this one will show the value
 
Formatting / Header Footer.
Tool
Bar		 Feature Description
Format formulas Format all cells with formulas so formula cells are easy to spot - great when working on new sheets to show you each cells that have formulas
Format Vertical Format cell text to be vertical
Format Wrap Text Format cell text to be vertical or if vertical back to horizontal (normal)
Format date Format current cell with my date format (you specify what default date format you want using the Options button)
Best Fit Format Columns of current selected cells to best (auto) fit
Format Text Blue Format Text Blue
Format Text Green Format Text Green
Format Text Magenta Format Text Magenta
Quick header footer Set Header and Footer using the Sheet name as the header - automatically add file name and date bottom left, page # of ## bottom middle, and confidential note bottom right - or to values you define with the configuration wizard
 
Files and Windows.
Tool
Bar		 Feature Description
Next window Go to next window (same as Ctrl-Page Down but as a button to help with navigation)
Jump to Sheet Show list of all sheets (visible and hidden) to select the sheet to go to or to hide / unhide
Show or Copy full file name and path Displays the full path and file name with an option to copy it into the paste buffer - so you can paste the full file and path name if needed (For example to attach the file from an email later)
Load Preset File I Load the file allocated to quick load button I - Loads the file specified with the configuration wizard - you have up to 3 of these to quickly load common files you need
Load Preset File II Load the file allocated to quick load button II - Loads the file specified with the configuration wizard - you have up to 3 of these to quickly load common files you need
Load Preset File III oad the file allocated to quick load button III - Loads the file specified with the configuration wizard - you have up to 3 of these to quickly load common files you need
Quick file load from cell Load the file specified in the current cell - for cells that contain file names and paths (that are easy to set using the Copy full file name and path button)
Set Preset File I, II or III Set the path and name of the file to load when 'Load Preset File I' is pressed or selected
Set default dir to current Set default directory to the current workbook path.
 
Data.
Menu Feature Description
  Show all named cells List all named ranges and their location in the current sheet, as a report in a new sheet of the workbook
  Add File To Recent List Add the current workbook to the Recent loaded list (from the File menu)
  Add Cell Note Insert the contents of the cell as a cell note with ':' added.  Will do nothing if the current cell note is not blank
  Show Zeros Set print options to display zeros or not display zeros - toggles setting each time
  Extract Last And First Function Cell Function (under User Defined) to split the first and last name of a name in a cell
  Delete External Names Delete all names that refer to external workbooks
  File List to Max Set Display File List Option to show last 9 files saved
  Go to Name in Cell Go to cell referenced by name in the current cell
  Print First Page Print the first page only of the current sheet
 
Miscellaneous.
Tool
Bar		 Feature Description
Count non blank Show count of non blank cells - good way to tell how many real entries in sheet with many blanks
Show cell formatting Show cell formatting and number info of the current cell
Options… Set options for the following:
  Date Formatting
  Formula Formatting
  Short Cut Keys
  Quick Load Files
  Quick Load Directories
  Set Header / Footer
Show Help Show Help Topics
 
 
 

Comments

"This is so useful, I wonder why Microsoft did not include it?"

Please help us help others: eMail a friend about us!
 

Short Cuts here!

Get your toolbar and menu now and start saving clicks in less than 5 minutes!
Download trial
or
Buy Now