Open your spreadsheet in Microsoft Excel 2003 and double-click the cell in which you want the textual white space to appear. Press the "Spacebar" to enter single-character spaces.

You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

A cell reference is simply a way of identifying a specific cell in your spreadsheet.

To stop this automatic simplification, you need to tell Excel what denominator to use. In other words, to keep "4/6" as is, ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.