Hi Scott. No prob. First, when I do this, I make to assign how many header rows and column rows I want. I think the default is one of each. First, when you call up Numbers you get be template list when you choose a new file with command n. Then I press enter on that if it says blank. Interact on the layout option and the table option. Then press VO you for the menu and go table. Go down until you find the option for header rows submenu; I think there's one for columns too, but i can't remember. Press right arrow on the submenu and get The list. You probably want 1, so you won't need to do this part of the procedure unless you want more.
VoiceOver uses these headers to announce things. So, put your titles across the row the way you want them in row 1, and perhaps a title in column 1, maybe. Go down your columns and put in your numbers. I put in a divider line by typing apostrophe symbol followed by 6 equal signs so VO will say them. Then call up the menu with VO M and right arrow to INSERT. Go down arrow until you find Function. The first item under it is sum. It should then automatically put in your total of that column. types in the formula for you, I love it. The only thing is that sometimes VoiceOver won't say A, b, c, etc. If you want to add up things in the row, you can use Excel formulas by typing in the equals sign followed by the letter and row you want to add, then the plus sign, and the next one, etc. There may be an easier way to do this part, but I haven't found it yet. I use Numbers all the time to do what y're doing. The only thing I have trouble getting done is a command on the keyboard to go to the end of the file. So, I use the track pad if I want to go very far in a large file. Regards, Gigi On Mar 3, 2012, at 9:29 AM, Scott Howell wrote: > Hi all, > > FOr those of you who are familiar with Numbers I have a question. I am trying > to create a spreadsheet that would let me create three or four columns with > text headers such as paint, flooring etc. > Then I want to have the ability to put a dollar amount in each column and > have the individual columns added up at the bottom or top-where ever. > The goal is to have individual columns that contain a specific item and if I > buy a gallon of blue paint, green paint, and purple paint, I want to put each > cost of the paint in the paint column and have a total of what I spent for > the paint. > I did not see a sample I could use in the available templates. So, any help > is appreciated. > > Thanks, > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/macvisionaries?hl=en. > -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/macvisionaries?hl=en.
