How to find format bar and formula bar in Numbers

Tom W P wrote:

I cannot find the formula bar or format bar in Numbers at the top when I'm on a cell, to edit or past script (Like excel) or the old numbers

You can't find it at the top because the versions of Numbers released in recent years don't have it at the top. To familiarize yourself with the recent version you might want to spend a few minutes reading Help.

SG

The reason you cannot find it is because it is, in fact, not there. to reveal the formula bar, select a cell, then type the equal sign. The formula editor will appear. The formula editor can be moved once it appears and will disappear when you finish editing the cell

Hi Holri,

You are in the iOS format but appear to have an OSX question so here goes.

In Numbers 3 in OSX click the grey paintbrush in the upper right. When you have something selected you will get your format choices. When you type "=" into an empty cell you will see the formula choices.

On an iPhone or iPad you will also see the paintbrush. It works the same way as far as formatting goes. Double clicking a cell will bring up an entry screen the "=" will take you to the formula editor.

Hope this helps.

quinn

Hi Holri,

The short answer is to drag the yellow handle of the cell with the formula you want to fill. You may need to do other things befor you do that step. Show me the formula you want to propagate.

Why don't you put up a screenshot to show what you are trying to do. Click the cell so the formula shows.

to take a screenshot press cmd-shift-4 then click and drag for your screenshot. to upload it click the camera icon in the reply window and navigateto your pic.

quinn

Thanks for the help but Apple needs to sell a Power user version with all of the old stuff plus drag some of excels features over ... Every time they strip away powers user features from OSX, some one puts them back and makes it better. Or just hacks the system to get what you want done. Stop taking away features apple !!! At the vary least you could make hidden and able to turn on for more advance users.Your making America engineering look bad !!!!

Hi Alexander,

You are in a user forum. We are all users like yourself. If you want to give Apple feedback this is not a good place to do it- they may never see it.

quinn

if you are trying to copy the formula, keeping one cell reference "locked", while letting the other one change as the formula is copied down, in ios just tap the reference "bubble" in the formula editor and select all the "lock" options there. This created the $ notation you are probably used to seeing.

Jason

I cannot find the formula bar or format bar in Numbers at the top when I'm on a cell, to edit or past script (Like excel) or the old numbers