Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default autofill button is not appearing when I select cells in Excel 2007

I have a function in a cell (F12) that I am trying to fill down the rest of
column F without changing the formatting. Initially there was a bad function
in the entire column. When I selected F12 and then dragged to select the
columns below it, I got the little fill option button which I clicked and
then had the option to fill formulas only, not formatting. However, when I
did this, only about a fifth of the cells filled with the new formula, the
rest retained the old one.

So I deleted the formulas in all the cells except F12 and tried dragging to
select them all again. Now the fill option button is no longer appearing. I
can't make it appear no matter how I click or select cells. I've tried it in
other spreadsheets and cannot make it appear anymore. The standard fill
button on the toolbar does not have "formulas only" as an option.
(Incidentally, if I reopen an old version of this worksheet I can recreate
the issue in my first paragraph.)

Any suggestions on how I can fill just the formula and not the formatting?
Any idea what that little box/button thing doesn't appear anymore?

Thanks,

Kelly

p.s. With Excel 2007 I feel like an English speaker in French Immersion
school. I figure out how to do basic stuff I used to do all the time in
earlier versions and there is no way for me to switch interfaces back and
forth to figure it out.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I control the order of Custom Toolbars appearing in the Add-Ins Tab of Excel 2007 Jeffrey W. Smith Excel Discussion (Misc queries) 1 October 26th 07 01:52 AM
Excel: How to stop '#div/0!' from appearing in empty cells. Gary Excel Discussion (Misc queries) 3 January 16th 07 05:09 AM
Excel 2003 is missing toolbar button select visible cells select visible cells Excel Worksheet Functions 1 August 15th 06 07:34 PM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM
Stop autofill icon from appearing? lvh519 Excel Discussion (Misc queries) 1 November 30th 04 03:02 AM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"