All I need to figure out is how to put 2or more lines of text in one cell box and I can't figure it out because no one shows it in their tutorials? Any ideas? In Microsoft excel you push alt and enter and you can do that.
@lilmaryb1 If you select a cell or cells and then right click on them, you get an option to "Format Cells..." Select the alignment tab from the new pop up box that appears, then select the option to "Wrap Text automatically" on the left hand side about half way down. That should sort your issue for you.
I was wondering if you knew how to update multiple cells in a row, without using IF/OR/AND functions, but using Validity. I want to select the first cell and choose an option from the drop down box I've made. But I want the following cell to: for example, display the price of item that I have selected. The cell after I might want that item's weight. So, in case I didn't write that very well, A1=drop down item. B1=price of selected item, C1=weight of selected item. Any ideas on how to do this?
@riverstrat if you want left, right or center justify some cells, just select the desired cells, it's easy. See just above the input box, the B I U icons - to the right of those are the justify icons. Try them out.
If you want to word wrap cells, select the cells, then use Format menu's Cells... item. That will open a dialog in which you need to click on the Alignment tab, then in the Properties, check the Wrap Text Automatically checkbox.
@bryantlikescake subtraction is easy to do. simply use the - eg =cell number-cell number or = a1-b1 and if you want to observe BEDMAS =(a1-b1)+(c1-d1) Hope that this helps?
@bryantlikescake there is not a subtraction function. To subtract something you simply have to Click in the cell that you want the answer to appear in, then in the formula bar, type your formula starting with an equals sign. Once you have done that, identify by clicking in the cells the cells that you wish to subtract from one another and press return to enter the formula into the sheet. Hope that this helps. If not I might do a quick demo and post it for you :)
@bryantlikescake Search my latest video the title is "Subtraction formula in Open Office Calc" this should give you the answers you need :) Let me know how you get on.
how do you make it display th formulas? I hve formulas made went to tools-options-calc-view- display and clicked display formulas, and nothing happened D= what am I doing wrong?
@EHTGOEH to do a range of cells all you have to do is use a colon. The colon indicates a range and you need to state the starting and ending cells in the range. eg =sum(a1:a27) would add all the values in the range from cell a1 to a27. Hope that this helps?
@dakinane You can also set up an array on another sheet and write a formula to return the data from particular cells if conditions in the formula are met.
pretty good it helped me alot. but you should have added instead of multiplied lol if u spend $12 on monday and $56 on tuesday youve spent $68 not $672 haha
Thank you so much!
lilmaryb1 1 week ago
All I need to figure out is how to put 2or more lines of text in one cell box and I can't figure it out because no one shows it in their tutorials? Any ideas? In Microsoft excel you push alt and enter and you can do that.
lilmaryb1 1 week ago
@lilmaryb1 If you select a cell or cells and then right click on them, you get an option to "Format Cells..." Select the alignment tab from the new pop up box that appears, then select the option to "Wrap Text automatically" on the left hand side about half way down. That should sort your issue for you.
dakinane 1 week ago
thank you very very much!!
nadiaatz 1 month ago
Hi Dakinane, I may have overlooked it in your other videos but I wondered if you were going to do a video on macros in Calc?
GTDtogether 2 months ago
I was wondering if you knew how to update multiple cells in a row, without using IF/OR/AND functions, but using Validity. I want to select the first cell and choose an option from the drop down box I've made. But I want the following cell to: for example, display the price of item that I have selected. The cell after I might want that item's weight. So, in case I didn't write that very well, A1=drop down item. B1=price of selected item, C1=weight of selected item. Any ideas on how to do this?
Technorex 3 months ago
In what video do you explain and demonstrate use of 'Alignment' in calcs ?
Thanks.
riverstrat 5 months ago
@riverstrat if you want left, right or center justify some cells, just select the desired cells, it's easy. See just above the input box, the B I U icons - to the right of those are the justify icons. Try them out.
If you want to word wrap cells, select the cells, then use Format menu's Cells... item. That will open a dialog in which you need to click on the Alignment tab, then in the Properties, check the Wrap Text Automatically checkbox.
JohnnyHands 3 months ago
Thank you!!!!!!!!!
csmclvrspreassigned 5 months ago
how can i subtract? i know theres a sum button but cant find subtraction. help?
bryantlikescake 7 months ago
@bryantlikescake subtraction is easy to do. simply use the - eg =cell number-cell number or = a1-b1 and if you want to observe BEDMAS =(a1-b1)+(c1-d1) Hope that this helps?
dakinane 6 months ago
@dakinane nope still confused...help please
bryantlikescake 6 months ago
@bryantlikescake there is not a subtraction function. To subtract something you simply have to Click in the cell that you want the answer to appear in, then in the formula bar, type your formula starting with an equals sign. Once you have done that, identify by clicking in the cells the cells that you wish to subtract from one another and press return to enter the formula into the sheet. Hope that this helps. If not I might do a quick demo and post it for you :)
dakinane 6 months ago
@dakinane lmao im on slow mode in my brain -___- you should def make that video
bryantlikescake 6 months ago
@bryantlikescake I have made a short video for you so that you can see how to create a subtraction formula. Let me know how you get on.
dakinane 6 months ago
@bryantlikescake Search my latest video the title is "Subtraction formula in Open Office Calc" this should give you the answers you need :) Let me know how you get on.
dakinane 6 months ago
Comment removed
alttplink 8 months ago
how do you make it display th formulas? I hve formulas made went to tools-options-calc-view- display and clicked display formulas, and nothing happened D= what am I doing wrong?
Yokoskitsunegirl 8 months ago
thx but how do u use is to add more then just 2 cells..(i want it to add) but dont want to punch in the + sign in between B3+C3+D3...HELP PLS
EHTGOEH 8 months ago
@EHTGOEH to do a range of cells all you have to do is use a colon. The colon indicates a range and you need to state the starting and ending cells in the range. eg =sum(a1:a27) would add all the values in the range from cell a1 to a27. Hope that this helps?
dakinane 6 months ago
@dakinane
Thanks man you saved my life!!
BattleGround16 3 months ago
@dakinane You can also set up an array on another sheet and write a formula to return the data from particular cells if conditions in the formula are met.
dakinane 3 months ago
pretty good it helped me alot. but you should have added instead of multiplied lol if u spend $12 on monday and $56 on tuesday youve spent $68 not $672 haha
coryeb1 9 months ago
Great info ...thank's. Good job!
FROZENICE1000 1 year ago
Great content. Quality is a bit rough, but the info is very useful. Thanks!!
stevelco 1 year ago
It took tooooo looooong timeeeeeee buy a frking new computer
dalladeien 1 year ago
You should film it in HD!
Krishna0666 1 year ago 2
Nice
MusicProdu 1 year ago