Leading the way in Microsoft Office Development

Excel

Knowledge Base Articles - 2007

288412 - 2007: How to change the color palette for workbooks in Excel 2002 or Excel 2003

149663 - 2007: Wrap Text Does Not Adjust Row Height

Knowledge Base Articles - 2002

293449 - 2002: Articles About New Formatting Features in Excel 2002

291207 - 2002: Bullets Not Retained When You Paste Selection from Word

288984 - 2002: Cannot Use Speech to Format Font Color

291293 - 2002: Color Palette Looks Different in Microsoft Excel 2002

277577 - 2002: Error Message: Run-Time Error 1004: Unable to Set the LineStyle Property of the Border Class

291321 - 2002: How to Programmatically Reset a Workbook to Default Styles

293467 - 2002: Incorrect Number Alignment in Right-to-left Worksheets with Wrap Text Alignment

292481 - 2002: You Are Unable to Dismiss the 'Number Must Be Between -90 and 90' Error Message

Knowledge Base Articles - 2000

212105 - 2000: Both Diagonal Cell Borders Use the Same Line Style

230934 - 2000: Bullets Not Retained When You Paste Selection from Word

212236 - 2000: CTRL+ALT+TAB Does Not Insert Tab into Active Cell

212126 - 2000: Cell Appears Blank with Angled Text and Small Row Height

211533 - 2000: Color Palette Looks Different in Microsoft Excel 2000

213896 - 2000: Corners of Double Borders Do Not Meet Around Angled Cell

212129 - 2000: Diagonal Border Disappears with Rotated Text

285810 - 2000: Error Message 450 When You Run Sample Code from Excel 2000 Help to Change the Style of a Range

211828 - 2000: Fill Colors May Be Saved Incorrectly with WK3 File

214307 - 2000: Financial or Accounting AutoFormats Change Number Formats

211462 - 2000: Formats May Not Be Applied to Pasted Merged Cell

211550 - 2000: Formatting May Be Lost When Pasting Merged Cells

228868 - 2000: Hidden Property Not Retained When Pasting Selection from Word

264582 - 2000: How to change default colors in Excel 2000

285347 - 2000: Illegal Operation Error When You Attempt to Format Cells

213834 - 2000: Inconsistent Formatting When You Use VBA Borders Method

215514 - 2000: Inconsistent Results When You Press CTRL+ENTER to Replace Formatting in a Selected Range

211575 - 2000: Indent Option on Alignment Tab Not Available with General Alignment

252730 - 2000: Justify Command Does Not Insert Spaces Between Text from Each Cell

214092 - 2000: Lotus 1-2-3 WK1 File Loses Formatting When Opened in Excel

213622 - 2000: Macro to Search for Cell Formats: Font Border and Interior

213616 - 2000: Macro to shade every other row in a selection in Excel

212204 - 2000: Pasting in Merged Cell Duplicates Copied Cells

211478 - 2000: Problems When You AutoFormat an Entire Worksheet

211906 - 2000: Redo Toolbar Button Does Not Repeat Formatting

213588 - 2000: Styles('X').Parent Different Than in Earlier Versions of Excel

214382 - 2000: Text Is Cut Off in Cell When You Select the Bottom Alignment Setting

211843 - 2000: Text Is Truncated to 255 Characters After You Use Justify Command

214357 - 2000: Text Is Wrapped Incorrectly When Typed in a Cell

214358 - 2000: Text with Shrink to Fit Format May Disappear or Grow

231064 - 2000: TrueType Fonts Available But Not Used in Print or Print Preview

211628 - 2000: Two Methods for Justifying Text

213688 - 2000: Using ColorIndex Property to Set Color of Borders Results in Unexpected Behavior

213469 - 2000: Visual Basic Procedure to Change the Standard Font

215609 - 2000: WMF Image Inserted as Background Appears Very Large

213899 - 2000: Wrap Text Format Causes Text to Move Closer to Top of Cell

Knowledge Base Articles - 1997

159464 - 1997: Automatic Styles and Apply Styles Do Not Apply Format

237277 - 1997: Border Color of Lines Returns Incorrect RGB Value When Border Color Is Set to Automatic

177050 - 1997: Borders Near Hidden Cells May Not Be Displayed or Printed

185158 - 1997: Borders Removed When You Remove Hyperlink from a Cell

172680 - 1997: Both Diagonal Cell Borders Use Same Line Style

156164 - 1997: CTRL+ALT+TAB Does Not Insert Tab into Active Cell

172684 - 1997: Cannot Undo Background in Text Box on a Chart Object

171722 - 1997: Changing Alignment and Indent Causes Text to Disappear

167385 - 1997: Error Formatting Cells on WinBook XP5 Laptop Computer

168788 - 1997: Fill Colors May Be Saved Incorrectly with WK3 File

264854 - 1997: Format Painter and Date Watch Wizard Cause Excel to Stop Responding

159321 - 1997: Format not Applied on Grouped Sheet with Merge Cells

163495 - 1997: Formats May Not Be Applied to Pasted Merged Cell

157028 - 1997: Formatting and Cells May Be Lost When Pasting Merged Cells

156889 - 1997: Indent Option on Alignment Tab Not Available with General Alignment

157204 - 1997: Odd Behavior Using Format Painter and Merged Cells

188503 - 1997: Overlapping Formatted Cell Border Behavior

186208 - 1997: Pointer Not Changed to Format Painter Pointer

171953 - 1997: Problems Using ColorIndex to Set Color of Borders

159863 - 1997: Problems When You AutoFormat an Entire Worksheet

169722 - 1997: Rotated Text May Not Be Visible

171705 - 1997: Text Copied from Microsoft Word Is Converted into Squares

183201 - 1997: Two Methods for Justifying Text

171334 - 1997: Undoing 'Merge and Center' Causes Page Fault or Hang