Fill without formatting | Message 1 of 10 | TechRepublic

Discussion on:

Office challenge: How would you inhibit formats when using the fill handle?

View entire thread

Message 1 of 10

Next »

2 Votes

+ -

Fill without formatting

After you fill the cells using the handle, click on the small box (shown in the screenshot by "2016"). Select the option to "Fill Without Formatting," and the borders in the filled cells will disappear.

Posted by eljensen

Updated - 18th Aug 2011