numbers problem with autofill

Question

Level 1

8 points

numbers problem with autofill

Hi, I have been using numbers for years, although I'm not a power user. When I want to autofill a cell or cells in a column, I simply grab the yellow handle on the bottom of the cell and drag down. This particular column, which totals my other columns, is suddenly not showing the yellow handle on the sides or bottom. The column next to it shows the yellow handle.

There was a post awhile back from Mr. Quinn, who helped someone else in a similar situation. The solution, I believe, was to select the column, go into format and make the table header was set to zero.

I tried this solution and my table headers are at zero. Any thoughts?

Posted on Apr 9, 2022 10:39 AM

Reply

Answer 1

Best reply

Barry

Level 9

59,867 points

Apr 9, 2022 2:58 PM in response to jkenyan

Have you closed and re-launched Numbers since first noticing this issue.

If so, try closing it again, then pressing shift as you re-launch it. Numbers may take a bit longer to relaunch, as it goes through a different set of startup routines.

If that doesn't succeed, you may need a restart into Safe Mode. Instructions for booting into Safe Mode differ slightly for intel based Macs and Macs running Apple Silicon. Details here: How to use safe mode on your Mac - Apple Support (CA)

REgards,

Barry

Reply

Answer 2

Barry

Level 9

59,867 points

Apr 9, 2022 1:39 PM in response to jkenyan

I'm assumng you are trying to fill th formula in the selected cell into one or more cells below and in the same column.

Try this:

Click on the 'source' cell to select it.

Copy.

With the source cell still selected, scroll to the last 'target' cell that is to receive the formula.

Press shift, and click on that last cell to add it and all cells between it and the source cell to the selection.

Paste.

Regards,

Barry

PS: Always useful to include the software version number (Numbers menu > About Numbers) and the version number of macOS installed in your Mac (Aple menu > About this Mac).

B.

Reply

Answer 3

jkenyan Author

Level 1

8 points

Apr 9, 2022 2:20 PM in response to Barry

Hi Barry, thank you for your reply. Yes, I can find alternative ways around performing an autofill. I'm curious where my yellow handle went though, because it's such a useful feature. Numbers version 12.0 (7033.0.134), Mac OS Monterey version 12.2.1 (21D62)

Reply