Hundreds of solutions to MSExcel problems

Time-Saving Microsoft Excel Solutions in detail

Time Saving Microsoft Excel Solutions is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. Easy to use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

No special software is needed to use - just download, run, and open Excel. Then select Help, Time Saving Excel Solutions. Time savings Excel solutions are always just a click away all the time - you even save time by avoiding fruitless Internet searches!

The following are the categories in the help file:

Each category expands into topic selection lists. And, you can use the Search tab to quickly find topics related to your keywords. You can also tab from one topic to the next by using the << and >> help file buttons.

Time-Saving Microsoft Excel Solutions: table of contents

1. Toolbars and menus solutions
2. Editing solutions
3. Formula solutions
4. Formatting solutions
5. Selecting solutions
6. Data solutions
7. Pivot Tables
8. Printing solutions
9. Worksheet solutions
10. File solutions
11. Excel function solutions
12. Chart solutions
13. Window solutions
14. Other solutions

Toolbars and Menus Solutions

• Keyboard Shortcuts
• Customizing Your Toolbars
• Assigning A Spreadsheet Assistant Feature to a Button
• Create Your Own Toolbars
• Adding Custom Menu Items To The Menus
• Displaying The Cell Pop-Up Menu

Editing solutions

• Displaying all the Menu Items Immediately
• Copying And Pasting Without Scrolling
• Making an Entry in Multiple Cells at One Time
• How To Turn Off Auto Complete
• Using The Buttons Next To The Formula Box
• Changing The Case On Text Entries
• Edit Directly In A Cell
• Stopping The Cell Pointer From Moving After You Make An Entry
• Specifying Destination Cells For Edit Entries
• How To Make An Entry In Multiple Cells At One Time
• Clearing Multiple Cells At One Time
• Using Auto Fill
• Copying And Pasting Within A Cell
• Combining Text Entries
• Modifying Many Text Entries Quickly
• Filling Blanks With The Entry Above
• Re-Arranging Lists
• Finding And Deleting Duplicate Entries
• Comparing Ranges or Lists
• Controlling And Using The Fill Handle
• Inserting Thick Underlines
• Inserting Percents And Decimals Numbers
• Speeding Up Editing / Manual Recalculation
• Drag And Drop Using The Right Mouse Button
• Copying Using Drag And Drop
• Inserting Blank Rows Every X Rows
• Insert Blank Rows If Cells Are Different
• Removing Blank Rows
• Trimming Blanks or Spaces From Cell Entries
• Transposing A Range
• Converting Trailing Negatives to Leading Negatives
• Using the Copy From Feature
• Using the Cut From Feature
• Converting Text Numbers to Numbers
• Changing Values Using Paste Special
• Replacing or Finding the * and ? Characters
• Displaying the Auto Complete List

Formula solutions

• Performing Any Math Action On A Range Of Cells
• Changes Cell References between Relative and Absolute
• Making Formulas More Readable
• Checking The Values Of Formula References
• Tracing Formulas
• Tracing Formulas And Errors
• Modifying Formulas to Hide Error Values
• Converting Formulas To Values
• Pasting Just Formulas
• Displaying Formulas
• Exact Formula Copy
• Sum Across Sheets
• Using SubTotal In Filtered Lists
• Toggling Calculation Between Automatic and Manual
• Formula that Returns Minimum But Not Zero
• Creating and Using Array Formulas
• Summing Time

Formatting solutions

• Quick Number Formatting
• Indenting Cell Entries
• Using The Format Painter To Copy Formats
• Conditional Formatting
• Copy Column Widths
• Toggling Word Wrap Off or On
• Unhiding One Column Of Many Hidden Columns
• Controlling where Text Splits in a Cell
• Custom Cell Alignment
• Centering Text Across Several Columns
• Center (Not Merge) Across Selection
• Pasting All But Borders
• Copy Row Heights
• Dot Borders
• Using Spaces When You Format Cells
• How to Modify Large Percents to <-100%, >100%
• Hiding Zeros
• Hiding Individual Cells
• Formatting Just Part of a Cell Entry

Selecting solutions

• Selecting or Filling Without Scrolling
• Scrolling And Quick Return
• Relocating the Active Cell to the Top Left
• Browsing Other Sheets And Returning
• Selecting All The Cell On An Entire Worksheet
• Selecting And Un-Selecting Sheets
• Select/Move To The End Of A Row Or Column
• Select Blank Cells Only
• Select Cells with Entries
• Select Cells with Numbers Only
• Select Cells with Formulas Only
• Select Text Cells Only
• Select Cells Based on Format
• Select Error Cells
• Select Cells with #REF!
• Select Unprotected (UnLocked) Cells
• Select Only Visible Cells
• Select Cells Using An IF Test
• Use F8 To Select A Range
• Selecting Multiple Areas On A Worksheet
• Selecting All The Cells In A Region
• Select Every Other N Rows
• Select the Rows of All Selected Cells
• Select Next Blank Or Entry Cell
• Checking the Corners of a Range

Data solutions

• Filtering Your Data For A Better View
• Inserting SubTotals
• Data Validation and Dropdown Lists
• Sorting Data With Rows Or Columns Hidden
• Using The Sort Buttons
• Sorting More Than Three Fields
• Blank Duplicate Entries

Pivot Tables

• Creating Pivot Tables From Your Data
• Updating Existing Pivot Tables
• Re-Arranging A Pivot Table
• Changing Pivot Table Selection Options
• Pivot Table Assistants
• Modifying Pivot Table Fields
• Adding Or Deleting Fields From A Pivot Table

Printing solutions

• Checking The Print Area
• Displaying the Bottom of Print Area
• Modifying Print Setups on Multiple Sheets
• Printing Multiple Selections On One Page
• Updating the Print Footers
• Printing An Area Different Than The Print Area
• Printing Embedded Charts
• Creating And Formatting Print Headers And Footers
• Page Breaks And Why They May Not Work
• Making Page Breaks Work With Fit To Page Set On
• Finding The Right Print Scale Setting
• Adding A Button To Set The Print Area
• Expanding or Shrinking the Print Area

Worksheet solutions

• Going To Any Sheet The Easy Way
• Using the Sheet Navigator to move from Sheet to Sheet
• Extract Multi-Sheet Values
• Duplicate (Copy) Selected Sheets
• Setting Multiple Sheets to the Same View
• Selecting Multiple Sheets
• Insert Multiple Sheets Quickly and Easily
• Deleting Empty Worksheets
• Summing Values Across Sheets
• Editing Multiple Sheets At The Same Time
• Switching From Sheet To Sheet
• Creating Your Own Worksheet Templates
• Showing More Sheet Tabs
• Renaming Sheets
• Shrinking Worksheets
• Hide or Unhide Multiple Sheets At One Time
• Protect Multiple Sheets At One Time
• List All Sheets in a Workbook
• Rearranging Sheets In A Workbook

File solutions

• Creating Your Own New Workbook Template
• Quick Access To Your Favorite Directories
• Bookmark Locations for Quick Access
• Quickly Change From One Directory To Another
• Using the Directory Lister to Keep Track of Your Files
• Quick Access To The Windows Explorer
• Changing Your Default File Directory
• Closing All Files The Easy Way
• Save Multiple Files At One Time
• Deleting Files
• Renaming the Active File
• Returning the Path of the Active File
• Changing Your Default Worksheet Font
• Hiding Personal Xls
• Switching From File To File Using A Hot Key
• Customizing Your New Files
• When To Update Links When Opening Files
• Opening Multiple Files At One Time
• Importing ASCII/Text Files
• Creating ASCII or CSV Files
• Exporting A Range or Embedded Graph to a Picture File
• Export Reports to a File
• Analyze the Links of All Open Workbooks
• Generating Workbook Statistics
• Using the Text Import Wizard with CSV Files
• Increasing the Recently Open Files List

Excel function solutions

• Useful Rounding Mathematical Functions
• Using Linest To Do A Least Squares Line Fit
• Using the Match Function
• Using Growth, Logest And Other Statistical Functions
• Using The Sum Function And Multiple Ranges
• Find The Min And Max Of A Range
• Getting An Exact Match With Vlookup And Hlookup
• Using The Sumif Function
• Counting Entries
• Using Subtotal Instead Of Sum
• Rounding Numbers To 10's, 100's, 1000's
• Using The Average Function
• Using The Index Function
• Using The Sumproduct Function
• Useful Text Functions
• Using The Offset Function Instead Of A Cell Reference
• Date In Month Function
• Date and Time Functions
• Date To Day Function
• Extract A Word Function
• File Name And Sheet Name Functions
• Grow Rate Function
• Insert In String Function
• Look For Text Function
• Numbers To Dollars
• Using Functions to Remove or Trim Spaces
• Special Lookup Functions
• BetweenXY Function
• Contains Function
• LastCellInColumn and LastCellInRow

Chart solutions

• Using Quick Charts
• Quickly Copy Changes From One Graph To Another
• Changing The Chart Type
• Converting An Embedded Chart To A Chart Sheet
• Controlling Where The Y Axis On A Chart Cross The X Axis
• Separating/Exploding Part Of A Pie Chart
• Embedding A Chart Within A Chart
• Adding A New Data Series To A Chart
• Using Dynamic Ranges In Charts
• Adding And Relocating Data Labels On A Chart
• Changing The Default Chart Type
• Linking A Chart Title's To A Cell Entry
• Aligning Embedded Charts
• Adding Text To A Chart
• The Affect Of Hiding Data On Charts
• Plotting Your Data Between Tick Marks
• Overlapping Or Separating Bars In A Bar Chart
• Using A Graphics Image For The Bars On A Chart
• Using Graphic Images As Markers For Lines
• Combining Lines And Bars And Pies On One Chart
• Inserting A Trend Line On A Chart
• Using Text Boxes And Formulas On Charts
• Using Pictures And Formulas On Charts
• Plotting Data with Gaps or Missing Data
• Charts and Hidden Data

Window solutions

• Eliminating Gridlines On The Screen
• Hiding and Unhiding Windows
• Change the Zoom Setting
• Fitting The Screen Zoom To A Selected Range
• Duplicating A Window
• Resizing Windows
• Minimizing and Restoring Windows
• Quick Access to the Windows DeskTop
• Hide Or Show Comments
• Creating Title Rows And Columns
• Freeze Panes On Multiple Sheets
• Changing the Size of the Sheet Tabs

Other solutions

• Inserting Sticky Notes
• Finding and Removing Unneeded Links
• Freeze and Unfreeze the Scroll Area
• Drawing A Circle Around A Range
• Inserting Months and Years
• Display A Calendar
• Using Excel As A Word Processor
• Accessing Notepad and the Windows Calculator
• Using Worksheet Protection
• Inserting Trademark and Copyright Symbols
• Making Better Appearing Presentations
• Displaying Range Information
• Drawing Perfect Circles And Squares
• Drawing Perfect Straight Lines
• Find the Longest Text Entry
• Recovering Information From Corrupted Workbooks
• Creating And Using Range Names
• Creating Local Range Names
• Creating, Displaying, And Deleting Cell Notes
• Using Goal Seek To Determine An Answer
• Using Solver To Determine An Answer
• Creating Image Files For Use On The Internet
• Creating A Name Reference
• Creating And Using Custom Lists
• Preventing Auto_Open And Auto_Close Macros From Running.
• Generating Random Numbers
• Calculating the Days between Two Dates
• Finding hard to find Links
• Turning Off the Office Assistant

See also in "Excel - VBA macro examples"

• Visual Basic Macro Collection - Over 2000 Excel VBA macros in 2 e-books.
• MS Excel Visual Basic Macro Examples - Over 1200 useful VBA macros.
• MS Excel Visual Basic Macros Made Easy - Hundreds of VBA macros.