Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: Default sort orders

2007: Sort data in a range or table

Reference Articles - 2003

2003: About collecting and pasting multiple items

2003: Automatically number rows

2003: Change cell background color using VBA

2003: Clear items from the Office Clipboard

2003: Collect and paste among programs

2003: Convert columns to rows or rows to columns

2003: Create a picture from cells a chart or an object

2003: Default sort orders

2003: Delete cells rows or columns

2003: Display the contents of the Office Clipboard

2003: Edit cell contents

2003: Enter data in worksheet cells

2003: Guidelines for entering data on a worksheet

2003: Hide or display the Paste Options button

2003: Highlight cells

2003: Insert cells rows or columns

2003: Locate and select cells that meet specific conditions

2003: Locate and select named or unnamed cells or ranges

2003: Measurement units and rulers in Excel

2003: Merge cells or combine their contents

2003: Move or copy cells and cell contents

2003: Move the cursor after entering data

2003: Select all cells on a worksheet

2003: Select cells and their contents on a worksheet

2003: Select the last cell of a worksheet or list

2003: Sort a range

2003: Sorting a range that contains numbers stored as text

2003: Split cell contents across multiple cells

2003: Top tips for Excel: Working with data

2003: Troubleshoot collecting and pasting

2003: Troubleshoot sorting

2003: Turn Insert Options buttons on or off

2003: Turn Office Clipboard command options on or off

2003: Turn drag-and-drop editing on or off

2003: Turn off the Office Clipboard

2003: Turn the option to edit directly in cells on or off

2003: Use Excel to compare two lists of data

2003: Use Paste Special to insert static or linked data into Excel

2003: Use color banding to locate the active cell

2003: Wrap text in a cell

Reference Articles - 2002

Reference Articles - 2000

2000: Correcting sorting problems with text and numbers