Tags: cell, changing, color, excel, fill, font, format, formula, microsoft, msdn, software, value

How to fill down without changing the format?

On Microsoft » Microsoft Excel

1,555 words with 2 Comments; publish: Thu, 22 May 2008 05:45:00 GMT; (30646.88, « »)

Does anyone know how to fill a cell's formula/value down without changing

the format (color, font, etc.)?

--

_________________________________________

Todd Bennett

Mechanical Designer

Celerity Group, Inc.

9660 SW Herman Rd

Tualatin, OR 97062

Phone: 888-724-3221

E-mail: tbennett.excel.todaysummary.com.celerity.net

All Comments

Leave a comment...

  • 2 Comments
    • Just drag it down.

      "T Bennett" <tbennett.excel.todaysummary.com.celerity.net> wrote in message

      news:big7g7$8skmo$1.excel.todaysummary.com.ID-183945.news.uni-berlin.de...

      > Does anyone know how to fill a cell's formula/value down without changing

      > the format (color, font, etc.)?

      > --

      > _________________________________________

      > Todd Bennett

      > Mechanical Designer

      > Celerity Group, Inc.

      > 9660 SW Herman Rd

      > Tualatin, OR 97062

      > Phone: 888-724-3221

      > E-mail: tbennett.excel.todaysummary.com.celerity.net

      >

      #1; Thu, 22 May 2008 05:46:00 GMT
    • Very nice, thanks.

      "Debra Dalgleish" <dsd.excel.todaysummary.com.contextures.com> wrote in message

      news:3F4BB8E1.4090307.excel.todaysummary.com.contextures.com...

      > 1. Point to the Fill Handle, and press the RIGHT mouse button.

      > 2. Drag down, then release the button.

      > 3. From the shortcut menu, choose Fill Without Formatting

      > T Bennett wrote:

      > > Does anyone know how to fill a cell's formula/value down without

      changing

      > > the format (color, font, etc.)?

      > --

      > Debra Dalgleish

      > Excel FAQ, Tips & Book List

      > http://www.contextures.com/tiptech.html

      >

      #2; Thu, 22 May 2008 05:47:00 GMT