I'm trying to "lock" or "freeze" the first column in the spreadsheet I'm making so that it will always be on the left side of the sheet when I scroll right. I cannot for the life of me figure out how though.
View 5 RepliesI'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack... I have a column of numbers (miles) and a column of use (Personal, Medical, Business). How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?
View 2 Replies View RelatedI've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
I have a .txt file that is quite long and I need to get some data off of it. The file is made up of a few thousand lines each with a format similar to: 1 2.4 5.4 abcde abc.def, The 1, the 2.4, the 5.4, etc each signify a different value and I need to somehow get them into separate columns into excel. The number of digits in everything except the first value (which is always one digit) varies, and all the values are separated by spaces. What is going to be the easiest way for me to get these values into numbers in separate columns? Realistically, doing this manually isn't an option.
View 2 Replies View RelatedI'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
I just recently got a MacBook - I'm new to the Mac world, but so far I love it and its worlds better then Windows 7 or anything else I've used. I'm picking up everything ok, except for a few little things. My biggest problem is in the "Numbers" spreadsheet program. I've searched the help topics and cant figure out how to make the numbers in my budget add up.
For example:
Paycheck- $500
Rent-$100
Food-$50
Car-$25
Total Expenses- $175
Difference between income and expenses: I cant get it to fill in the gap between the income and expenses so I know how much I have left over without having to do all the math myslef. Excel used to do this, is there a way to make Numbers do it too?
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
since I don't know when, the columns in Finder windows have always the same size. If I change the size, and then close the windows, when I open a new one, the column get back to their "original size" (which is too small for my personal use).
View 2 Replies View RelatedI was wonder if there was a way to use both coverflow and 3 column view. I did search.
View 4 Replies View RelatedI just downloaded the new itunes 10, and the first thing I noticed was the "album by artist" column under the music library. I don't like it at all. I want to remove it, but I can't! I'm not talking about the "album artist" column. This is totally new with the iTunes 10. When I try to remove it by, it only gives me the option of sort and artwork.
View 5 Replies View RelatedAfter a few months mild use on OS X I'm starting to get used to it more and more now. I love the column view, but find it really annoying that occasionally new finder windows will open in Icon view. What exactly is the point of the finder preference "always open new windows in column view"? It sounds pretty straight forward, but finder doesn't exactly pay much attention to it. When I'm viewing in column view and I command-double click a folder, finder will open a new window in Icon view, depsite my preference. I have to reset the new window to column view and then close it, and then when I repeat the command-double click it will open in column view but it kinda defeats the point. I've read numerous posts about finder not remembering views, I don't understand also why there's only an option for column view? why isn't there "always open in list view" or "always open in icon view" option?
View 1 Replies View RelatedTwo emails in my mailbox have two exclamation points (!!) in the flagged column. I was unable to find what this meant in the help doc or on google. I was wondering if someone on here might know what this means. The two emails were sent via forms on my websites so I imagine maybe that has something to do with it? Anyway, any insight on these crazy exclamation points.
View 4 Replies View RelatedI have about 20 playlists. I want to apply the column formatting (including widths and orders) of the main itunes music library to these playlists. Is there a way to do this? I cannot do it manually.
View 12 Replies View RelatedI want to capture selections on my screen and add comments. Is there a program out there that will allow me to do that? I don't like the "grab it" program because it saves the captured file in a Tiff format instead of a Jpeg format.
View 11 Replies View RelatedDoes anyone know how to set all the folders in Outlook 2011 to show the same set of columns?
View 1 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
I have a belgian azerty keyboard and OS X in english on my white macbook. Is it possible to change the caps lock key's function to shift lock so that it affects the whole keyboard rather than just the letters? I'd like to be able to type numbers without holding shift.
View 3 Replies View Relatedim trying to lock separate applications like pictures and documents
View 1 Replies View Relatedis it possible to take a program made from a PC and make it run on a mac? without crossover (it never works)its not a complex program but it never works from me
View 4 Replies View RelatedI've been feeling paranoid lately after reading a number of articles on how vulnerable my data is. I wanted to make my MBP more secure. I realize that with cold boot attacks, nothing is ever truly secure, but I do want my data more safely protect than with just an EFI and user password. I don't have any particular files on my computer that is pressingly sensitive, so I found truecrypt to be not very useful. I want my computer to generally well protected.
View 8 Replies View Relatedapplication or app that will allow me to lock my keyboard? I've got a curious new kitten who insists on walking on my laptop when I'm sat watching a film and pausing/stopping/ejecting etc!
View 2 Replies View RelatedI'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.
View 4 Replies View RelatedI have an iMac 20'' running Snow Leopard and I want to keep my screen on (to be more specifically, I need to keep it on with a photo on it, always) but when someone moves the mouse or press a key I don't want them to access my computer without entering my password. (like a transparent screen lock app) I think you got the idea, can you recommend me a software that does this?
View 3 Replies View RelatedI'm looking for an app that will allow me to specify which folders I want to copy to my external drive, updating existing files within it and copying new ones.
I don't want to backup settings, my whole harddrive nor make a bootable backup. Just something to backup what I want to backup and where.
Not sure if Time Machine can do that, but it wants me to reformat my external before I can even find out..and considering how much is on there, I really don't want to have to remove that all elsewhere while doing so. [Don't think I could anyway, none of my internal drives have that much space.]
So, does anyone know of a relatively painless backup app that could do simply what I want? Doesn't sound all that complicated in comparison to some of the more convoluted backup apps I keep finding.
I am trying to switch my email program from Thunderbird to the mac email program Mail.Thunderbird has been playing up a lot recently and am tired of the glitches.
I have all the correct server settings etc and succesfully imported my mailboxes. The problem is that when I send an email it isn't from the right email address?? Is this a Mail problem or smth to do with my settings? I'm with Virgin media and have a separate set of email address through my website for my business so my email address are through freeola that I am using through Thunderbird.I'm sorry if this all sounds very stupid but I am pulling my hair out trying to figure out where I have gone wrong!
The v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
View 3 Replies View RelatedI just have a quick question about Numbers (iWork '09). I need to graph some supply and demand graphs for school. How would I go about doing this? Whenever I create a graph based on a chart, it just plots each row as it's own line. I can only edit the values in the Y-axis, and obviously I need to be able to work with the X-axis as well.
Update: I played around with it more and figured it out. I guess you have to graph it as a scatter plot and then choose to connect the dots, and remove the dots, rather than choose the line graph, whose icon looks just like a graph of supply and demand.
I'm a recent switcher from Excel to Numbers. For the life of me, I cannot find a way in Numbers to "freeze" headings so that as you scroll down or across the sheet they remain visible.
I'd be grateful for help; the matter is not covered in the video tutorials, nor in my little manual that came with iWorks, nor on the Help Menu.
