So useful, thank you! I have just moved to Libre from MS Office due to pricing and your videos are so helpful in the transition

Thank you, Office Nifty!

Correct me if i'm wrong but isn't this just getting the name of a sheet that I already know! Like asking my friend Brian what his name is!

thanks!

It didn't work.

Thanks man, so easy. Couldn't find it to save my life.

Worked, thank you!

When I hit PRINT, my Print dialog did not show most of the options yours shows. None of the spreadsheet specific options appeared. I realized it was because I had to check the "Collation and Paper slides" box first. Why would they NOT have those options shown by default? It's not a matter of space, since there is plenty of room to show them all. Apparently this is an example of the couterproductive trend in recent years for coders to make screens "minimalist" in appearance instead of maximizing ease of use and functionality for users.

Thank you! How dumb for the programmers at Libra Calc to not make an easy and obvious way to print the grid lines.

he took 53 seconds to tell us to press shift F7. bro's yapping is unmatched

thanks a lot man! Btw I liked your UI very much, what is it?

Does'nt work for me. I get error messages or zero as an answer.

any way to add a strikethrough button on the toolbar?

Please help

The button didnt work when klick

tks for tutorial!!!

cool tuorial!!!

Only options : select all sheet Protect sheet View grid line Sheet events - are shown when i click on my sheet tab. Alt kry & left click din"t work either ... please help

How can I get my table to print on orientation landscape instead of portrait?

the information I needed, thank you very much!

This is a great tutorial, but it seems that I can only do a calculation only once. It will calculate the numbers together then if I want to add that answer to the original numbers it will just repeat that last number, Any ideas? Thanks.

Thank You So Much! When anything I have to read is that light I can't read it. Just a note to Mac users or maybe a different version of this awesome software. Go to preferences. In that list below personalization is application colors. Change it whatever color works for you. A tutorial never went this easy for me! Thanks.......Oops! Don't forget to click apply to. LOL.

SUBSCRIBED! I love how your LibreOffice vids are straight, well-thought out and to the point. I look forward to seeing if you have any content on LO Base

Works perfectly! Solved my problem. Thank you very much Office Nifty :)

I can’t get mine to print all the rows it’s printing20 I need 25

already out of date, this is nothing like libre calc now! 24.2.5.2

Thanks for sharing this knowledge!

Urgh! Many thanks, saved me quite a few hours formatting as I also couldn't find that setting until I watched this.

شكرا

Open office always shows the grid lines by default. Libre office has the OPTION checked to show the grid lines by default, but does not ACTUALLY show them, and no (format, cells, borders) or (tools, options, calc, view) option seems to show them. This makes it difficult to avoid run--ons between cells. Why does the actual screen not show the grid lines?

how can i calc percentage between 2 numbers in a pivot? example a column with 10 and another with 2 how can i say to the pivot table to show me how much percentage its representing that 2 from 10?

Thank you so much for your tremendous help!

Thanks so much you’ve just helped me solve a BIG problem for my school work!! Cheers 🎉

Very helpful. Thank you so much. Needed that.

About the second portion of your video, where we are copying multiple columns: ¿What if I only want to check columns A and B for duplication? That is, if columns A and B duplicate together but C, D, and E don't, I still want to delete the duplicate A & B row. This is because I've merged data from different sources and they may have discrepancies, and I only want to keep the first one.

Oh no man...i couldnt see niks, nada, niente. BO icon. Whqt icon. Do a close up for I eyes

this looks nothing like libre sheets wtf?

Bad tutorial

Thank you so much!

Thanks, that was useful. Would be great if you showed else if here or mention if the program allows it.

How do we do in two different sheet

Thanks! It works. It's kind of stupid of them to only allow you to right-click on the row number to hide the rows rather than right-clicking on the area and then choosing Hide Rows.

thanks alot , your video helped me a lot

Trying to find how to do this was a PAIN. I didn't know there was specific words for this like wrap. I kept trying to search, Fit, Match, and Size. So thank you.

I appreciate the help. Now I know LibreOffice is not the solution for me.

Not working.

Libre Tech Tips

can i pay you for a little help just looking for a way to create a formula like X - X / 2000

Thank you for your videos. My question is, is it possible to highlight a column of cells, and just have the system update the year? My cells are MM/DD/ and each year I copy business spread sheets and change all the data, but am generally entering data from a prior year, say it is 2024 and I need to enter data for 2023. Thanks in advance for any help.