How do I apply a formula to entire column in Numbers 10
How do I apply a formula to entire column in Numbers 10
MacBook Pro 13", macOS 10.15
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
How do I apply a formula to entire column in Numbers 10
MacBook Pro 13", macOS 10.15
Drag the yellow dot down the column.
Or select the cell with the formula, type command-c to copy, select all the cells in the column, type command-v to paste.
You can find more about the first method, filling, by going to Help > Numbers Help in your menu and searching for "autofill".
SG
Drag the yellow dot down the column.
Or select the cell with the formula, type command-c to copy, select all the cells in the column, type command-v to paste.
You can find more about the first method, filling, by going to Help > Numbers Help in your menu and searching for "autofill".
SG
There ain't no "triangle of death." Those are error triangles, and always include an error message telling what error caused the formula to not work.
So what was the part of your formula causing it to work on only every second row?
Regards,
Barry
When I clicked on the red triangle it said:
"The operator “+” expects a number, date, or duration, but cell D2 contains a string."
I have no idea what that means. I have no idea why my formula only worked on every other row!
Double click on the cell containing the formula.
Click in the space to the left of ƒx and drag the editor to where you can include it in the shot without hiding any of the cells included n the formula. Make sure you can also include the row and cell reference tabs above and to the left of the table.
Then follow the instructions below.
To take a screen shot of part of the screen:
Place the mouse pointer at the top left corner of the area you want to capture.
Press shift-command-4. (the pointer will change to a crosshair)
Press and hold the mouse button and drag down and right to the bottom right corner of the area to be captured.
Release the mouse button.
The captured image will be saved to your Desktop with the title Screen Shot, followed by the date and time of capturing the image.
To post your screen shot here:
place the insertion point where you want the image to appear.
Click the mountains icon in the toolbar below the composing window.
This will open a drop down pane showing the contents of our Desktop. If sorted descending by date, your screen shot should be at the top of the list.
Double click the file (or click once, then click Choose).
You'll be returned to your post, and after a slight pause the image will appear.
Regards,
Barry
What is the formula in D4?
Screen shot of formula as it appears in the Formula Editor preferred,
but copy and paste from editor ok.
Barry
ps: Will be away from the computer for a few hours. Don't be alarmed by lack of quick reply.
B.
Sorta worked when I dragged the yellow dot. Every other row had the red triangle of death in it! Once I selected then deleted those rows, it seemed to be fine. Thanks!
It means that the value in D2 is being read as a text string, which the addition operator ( + ) cannot handle.
What is in D2?
Regards,
Barry
D2 is in my Header and contains no text. I'd like to send you a screen shot of my results, but can't even figure out how to do that. Any suggestions?
I think by putting my formula in the second row of my spreadsheet instead of the first row, I get the results I'm looking for. Thanks for your time!
You've been very helpful. Thanks
How do I apply a formula to entire column in Numbers 10