Unsolved
This post is more than 5 years old
2 Intern
•
7.9K Posts
0
36585
March 15th, 2007 18:00
Excel: Fill Without Changing Formatting
Excel 2007 (though I'll accept help in any recent version).
I need to use the Fill Down command (though I'll accept help in any direction). Currently when I use fill down, it updates the values but also changes cell formatting and type.
Is there a way to use Fill Down to only change the cell formula/value but not change the cell formating/type?
Thanks
RoHe
10 Elder
•
45.2K Posts
0
March 16th, 2007 22:00
"You can use Auto Fill Options to choose options for how to fill the selection. For example, you can choose to Fill Formatting Only or Fill Without Formatting.
Format>autoformat>options
Also:
"If you've already entered the list of items you want to use as a series, select the list on the worksheet. On the Tools menu, click Options, and then click the Custom Lists tab. Do one of the following: To use the selected list, click Import.
To type a new list, select New list in the Custom lists box, and then type the entries in the List entries box, beginning with the first entry. Press ENTER after each entry. When the list is complete, click Add.
Note A custom list can contain text or text mixed with numbers. To create a custom list that contains only numbers, such as 0 through 100, first select enough empty cells to contain the list. On the Format menu, click Cells, and then click the Number tab. Apply the Text format to empty cells, and then type the list of numbers in the formatted cells. Select the list and then import the list."
Ron
NemesisDB
2 Intern
•
7.9K Posts
0
March 17th, 2007 16:00