Creating a Data Series Replaces Formatting in Excel

ID: Q77513

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2 versions 2.x, 3.0

SUMMARY

In Microsoft Excel, if you create a series of numbers or dates using the Series dialog box, the cell pattern or shading in the first cell is copied down the length of the series. This formatting replaces any existing formatting throughout the series.

This behavior is by design. To avoid losing the formatting of your cells when you create a series, do the following:

Create the data series in another area on your worksheet.

Select the data series and choose Copy from the Edit menu.

Select the area on the worksheet where you want the series to appear, and choose Paste Special. Under Paste, select the Values option. Choose OK.

The series is pasted onto the worksheet without affecting the formatting of the cells.

To restore the original formatting when the above behavior occurs, you must reformat the affected cells

Note: In Microsoft Excel version 5.0, to use the Series dialog box, choose Fill from the Edit menu, and then choose Series. To use the Series dialog box in earlier versions of Microsoft Excel, choose Series from the Data menu.

REFERENCES

"Microsoft Excel User's Guide, Book 1," version 4.0, pages 238-239 and 122-127.

"Microsoft Excel User's Guide," version 3.0, pages 205-206 and 261-264.

"Microsoft Excel Reference Guide," version 2.1, pages 144-145 and 309-310.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0

Keywords :
Version :
Platform :
Issue type :