Excel - Q & A from the News groups

(Last updated 04/07/97)

Table of Contents

• Calculations
  1. Adding Numbers baised on Adjacent Cell
  2. Calculating the yth root of x
  3. Inversion of large Matrices
  4. Raising x to the power y
• Charts
  1. Display a graph of Hidden Data
• Delimiters
  1. Splitting a Text String
• Display
  1. Colour Cells by their Content
  2. Keeping Certain Rows and Columns always Visible
  3. Menu Bars - Customization
  4. Not Displaying Zeros in a Spreadsheet
  5. Page breaks - finding them
  6. Printing a Background Image/Banner (e.g. "Draft")
  7. Printing a translucent Watermark
  8. Switching between Value and Formula views

• Displaying the current sheet name in a cell
• Format
  1. Times as Durations
  2. Converting seconds to minutes
  3. Imported Dates from Access "Incorrect" - 1904 Date System
  4. Zipcode formatting
• Functions
  1. YEAR Function
• INDEX and Match Functions
  1. Finding the Cell a Value comes from
• Jumping between Cells
• Menus and Toolbars
  1. Disabling the Exit icon from the window
• Note Text
  1. Adding Note Text to a Protected Sheet
• ODBC
  1. Getting data from Access using a wildcard
• Printing
  1. Printing Non-Contiguous Columns
  2. Printing From a Custom Dialog Box
• Selecting every nth Row
• SMALL and LARGE Functions
  1. Finding the 2nd Smallest value in a list.
• Sorting Sheets within a Workbook
• Summing values with Constarints
• Visual Basic
  1. Automatically add File path to Page Footer
  2. Check to see a file exists before using it
  3. Deleting a Sheet within a Macro without dialog response
  4. Deleting Duplicate Rows from a Spreadsheet "Database"
  5. Deleting Selected Rows from a Spreadsheet
  6. How to Display the Open and Save As Dialog Boxes
  7. Mouse Pointer - Changing to an Hour glass
  8. Naming a Cell Range
  9. Opening a file with a date name
  10. Removing Apostrophe from start of Date
  11. Splitting Data from one Cell into two Cells
  12. Writing Results to a Locked Sheet

  Return to main page

  If you have any comments, suggestions or gripes about the way the data have been presented please contact us at waa@juno.com . We welcome your input.