Making LibreOffice More Like Microsoft Office [For Free]

[@PWhiting]

Why do so many seem to hate the ribbon in MSOffice? It's one of the bits that I love.

[@carlajacobs8379]

Fantastic! In my version, 6.1.4.2, there is no Toolbar Layout but I found the command for the Notebook bar under User Interface -->Groupedbar. It worked the same. Thought it might help someone else. Thank you so much for the video. Also, I was used to using the Format Painter using the keyboard. I was able to set up the same "copy format" shortcut for the "Clone" command in LibreOffice. Now if I could just get a "selection bar" (in the left margin like Word)...

[@LinuxTechShow]

Thanks Carla. We appreciate you sharing your experience!

[@515gohadneltr]

Yeah i've just did the same thing. there is no notebook bar. so i choose grouped bar in user interface. Thx for creator of this video and you for noticing it.

[@gunjchowwiwat8357]

This helps me a lot. Thank!!!!

[@vrmsali]

Thanks to the video makers and a very special thanks to you. It saved me lots of running around; much grateful :)

[@stevepereira3746]

Thank you, this really helped me out a bunch! :)

[@merlinof2]

I've been using this since the OS/2 days (93) when it was StarOffice, written by a 16yo German kid. I am so much more productive than any of the Office users it 's not even funny. Love it but still learned a couple of tips from the Video. Thanks Chris!

[@granadosvm]

In case anyone is scanning documents directly into Libre Office.... I was watching this video while using Libre Write although I have my paid version of Office 365 because while trying to insert scans directly into the Document, I could not find a direct way of doing it in Word and Microsoft help tells you to scan and save documents and then insert pictures, which is fine when you are scanning a page or two, but when you have to do a lot, it takes a lot longer and creates a lot of unnecessary extra scanned files. In LO Write you can use [Insert|Media|Scan|Select Source] and it will scan directly into your document. But when you activate the experimental features and tabbed icons, that option goes away from the toolbar... The good news is you can still Use it. In Libre Office 7 (the version I'm using), when you select the [Insert] Tab, in the far right of the toll bar there is a drop-down menu that repeats the word [Insert], from the drop down choose [Select Source] and it will let you select your scanner (I only have one) to again send scans directly into your document.

[@boman.]

Video starts at 5:26

[@peteromenda9882]

That was, undoubtedly, very very helpful. Thank you. I truly appreciate. This is now what we call a call to eradicate poverty. God bless the work of your hands.

[@GrdDog]

Awesome thank you for the helpful information on this subject; a question, do you know if Libre Office is making a program One Note like Micro's Office has, I love that program for note taking

[@cyberlizardcouk]

one thing I would like to see in libre office is full support for VBA.

[@ifell3]

Tabbed compact @ 13:08 on 6.4 running from win.

[@mickyjankis9542]

it worked but showing less icons, rest are in that arrow part, any clude how to show all of them at once

[@genkiferal7178]

We need an extension or small program to automatically make the two more similar.

[@YamiKeizerLeon]

Thanks for the info, needed an alternate to office...

[@XxAbdozxX]

I am having an issue setting the toolbar layout because I have the later version. you have "view" then "toolbar layout" then the "Notebook layout". However, for me I have "view" then "user interface" but the "notebook layout" does not exist. Can you please help me its my final step. By the way the video is amazing, thank you guys.

[@givemoremunashemakonya6438]

having a similar problem as well!!

[@XxAbdozxX]

@@givemoremunashemakonya6438 Hey dude some one already made a comment about this I just realised it 😅,. Go to "view" then "user interface" then "grouped bar" then its done !. If the menu bar disappears, you'll find a "menu" button on the top right. click it then click "menubar".

[@karlia_mc]

Indeed, it's not Word, you've hit the nail on the head. Just as Nissan is not Mercedes. I've come to prefer LibreOffice and its basic Interface after making the switch from MS Office about two weeks ago. My biggest concern was handling pivot tables with Calc, but that turned out to be unfounded. Windows 11 24H2.

[@hardrod6989]

Can you do all these, same amazing things to the libre office excel and PowerPoint

[@flyfight98]

I dont have the "Toolbar Layout" option even tough I activated the advanced user settings :/

[@timpedra]

I believe it's now under "User Interface". Also, you won't find "NotebookBar" anymore (at least I didin't), I think it's called "Tabbed" now.

[@happy77548]

hi when we type this url : cat5.tv/libraofficeicons in firefox and it diverted to category5.tv/ and i am not able to download icon theme

[@SuperSilentViewer]

Fist time to use LibreOffice, a bit hard try to find the function due to interface style. As this was an older video, i did not think that LibreOffice do not make the theme as default coz my version is already 6.4. so i try to look at it myself, turn out when you go to View>User Interface>Tabbed , it is almost like microsoft one. I dun care on icon. I think LibreOffice does have a nice icon pack thanks to this video

[@liesdamnlies3372]

Pages is different, and has a better interface than LibreOffice. You can be different and have a great UI too.

[@fivesfish]

When it comes to fonts who can you say is wrong? you for sending the document or them for receiving the document?

[@mayurvaghela8496]

Though I have an educational license of Window 10, I just switched to Linux before a week. I am very much satisfied.

[@sfeco2]

Thank you. I wish an email client will be included soon. That'll make it "complete".

[@alphabennyrosy5068]

That would not follow the Unix philosphy.

[@sagshah10]

have you tried wps office suite? I recently downloaded it and found it to be quite similar to office 365.

[@adorablegodzilla5628]

"Options" has been moved to "Preference" if you're stuck.

[@TheInfirit]

Staroffice (on which openoffice/libreoffice is based) predates msoffice by 5 years. Msoffice looked like staroffice for much longer than the other way around.

[@wordart_guian]

No, only the starWriter Word processor prédates the office suite, and It is far from predating Microsoft Word (1983). PowerPoint for example was the first of its kind, so obviously impress came later. And excel has existed since 1985 - before calc

[@imammarsudi008]

are this things is legal? i am a newbie in linux, download MS 2013 theme, its legal in linux?

[@WatchingTrainsGoBy-PassingTime]

Yes.. COMPLETELY LEGAL and free.. They're open source created by enthusiasts over years now. They just want to help people that can't afford other products. MS does nothing wrong charging for their product. It's just nice that communities come together to help the rest of us like this.

[@_IRONJAW]

How can you type anywhere like in microsoft word? (same like one note)

[@WanderingAroundAZ]

Free (as in beer) does not automatically make something more compelling. I say that because many of the comments I read are about how great LibreOffice is because it doesn't cost them any money. I don't mind paying a developer for exceptional software. I use MS Office all day long at work, so when I come home and need to balance by checkbook in a spreadsheet program, LibreCalc is just not as capable as Excel and, for $7.99 a month, I find MS Office to be a value. If you want free, there is Microsoft 365 online. The open-source nature of LibreOffice is to be applauded, so is the fact that it offers a capable alternative to the proprietary mainstay. But the vilification that MS Office seems to attract in the comments of every LibreOffice review is just nonsense. Choice is good... whether it be a paid, proprietary one or not.

[@katiekeaton3943]

How do I send a document from Libre to my e-mail

[@anuragpal2506]

Any way to implement all the ms office keyboard shortcuts to libre office linux?

[@genkiferal7178]

I'd like to know this as well. Did you ever figure it out? In many linux sotfwares (editors mainly), i add lines in the config files to change keyboard shortcuts to more standard or newer ones. I've never seen a simple .conf or .config file for LibreOffice, though. I think that would be great for LibreOffice, too.

[@wildcat22]

Excellent episode guys. Love the channel.

[@kennethhumphrey952]

Can you make these changes on a Mac or PC?

[@guraknugen]

I use Excel a lot at work, and I'm so happy that LibreOffice Calc (which I use at home) is very different from that! So many crazy bugs and shortcomings in Excel. Yes, LibreOffice has bugs too, but I haven't seen that crazy ones yet. Recently I actually installed LibreOffice on my job computer too, just to get some peace in my heart, but I'm not sure I was allowed to do that. Don't tell anyone… :P Funny though, that my LibreOffice installation at work (in Windows 10) doesn't seem to work as well as the LibreOffice installation on my home desktop computer (in Manjaro Linux). And those ”ribbons” in Excel in which I never find anything I'm looking for, except for those things I use all the time. I have to google everything all the time (or use the built in search thing, which on the other hand isn't a bad idea). Very time consuming.

[@genkiferal7178]

Have you found any other videos or articles that make using both LibreOffice (at home) and MS Office (at work) less confusing? It's 3 years later now. I'd like to set up (customize) my LibreOffice to be as close as possible to what I will be using (soon) at work...so that my head doesn't explode.

[@lmorris7503]

I made a document resume and was not able to send it because is was save as ODT. How do i save it as PDF?

[@KLP99]

There is an option under the File menu for Export as PDF.

[@lmorris7503]

@@KLP99 Thank you so much for the info!

[@paulo.galvao]

For who start using word 2.0 i prefer use the ancient menu's with the right bar... In this video does not appear

[@polgzz]

As on april 2020, in version 6.4.3, you don't even need to do all this. Just hit view > uster interface > tabs bum! As for the icons, they are already similar ones this days. Give it a try, people! or otherwise, legitimately pay for MS office. But please, don't hate on FOS software while not being willing to pay for private lincesed sofware :). It takes a lot of work from a lot of generous people to run libreoffice that good with the huge power it has underneath. Cheers!

[@aljoumeyli]

Thanks man! It worked on my Libre Office version 7.2.

[@guillaumemaurice3503]

Thank you for sharing this video that was very interesting and great information. I recently bought a Chromebook as I got fed up with Windows and I have downloaded Libre office and I like it. It is quite good. It is important for me as I am a fictional author.

[@1mphamvu]

I use WPS (on linux) because just prettier than libreoffice. I understand libreoffice can do much more than WPS, but compatibility with word much better with WPS and looks very similar.

[@CallsignEskimo-l3o]

Or instead of paying for Office you could create an Ice Single Site Browser and use the free online version of Office.

[@LinuxTechShow]

Good thought, and a great solution. Though Ice SSB requires you be online at all times (it's a web browser, really), which could be less than ideal for a word processor. Instead, if you want to use a cloud-based approach, we'd suggest going with Google Docs, which can be used even without an Internet connection. kzbin.info/www/bejne/pXe2faVobLN5iMk

[@genkiferal7178]

I would love an idiot's guide to ICE applications. I briefly read up on ICE, but got intimidated (or lazy). Instead, I just use it in a separate profile in a browser, but I guess I could compartmentalize it more by using a separate user in my OS and/or container tabs (extension) in Firefox. Oh, I also use it on just one older weaker PC so as not to contaminate my better PC.

[@marcosjuarez1998]

Is there 2013 Microsoft office icons for Mac for libreoffice

[@anthonyrc6618]

I was able to do it. I can't remember exactly how, but if I remember correctly, you must download what they downloaded in the video, go to: 1) LibreOffice > Preferences > Advanced > Enable experimental features (may be unstable) > Click on Apply 2) Then again, LibreOffice > Preferences > View > Icon style > Office2013 > Click on Apply (this generates the MS2013 theme) 3) If you want the toolbar to be spread out like Microsoft, go to View > User Interface > Tabbed. Normally, that should do it.

[@dacrazybieber]

This was very helpful. Thank you so much!

[@agungprawiranegara2062]

actually i look for tutorial about how to install microsoft in linux, but this tutorial change my mind hahahaha, thank you.

[@kevyyar]

The fuck?? Why?

[@polgzz]

This days you don't need to. 6.4.3 already has tabs mode and the icons are quite similar already

[@genkiferal7178]

You mean you installed a virtual machine, then installed MS Windows to it and then installed MS Office? I have done most of that, too, but now need a free version of MS Office (not just the free online version that lacks Access). I would like to note, though - that some free versions of Windows 10 seem better than others. Two years ago I installed one on linux in a VM and it was almost as fast as using Windows on bare metal, but I deleted it to make more space. Then I installed another since I need to re-learn it for a pay raise at work. This new free version of Windows 10 is far slower and I am not sure if it is Virtual Box or the Windows version at fault. SO if you get it working right and fast, never delete it and think it will work as well if you reinstall it in a year or two. Nothing is guaranteed.

[@aapnegara]

@@genkiferal7178 no ... my comment was 3 years ago which is the first time I use manjaro linux as my operating system [not using windows and also not using vm to run linux but full linux on my machine].

[@sandeepxkamath]

Thank you very much! Keep up the good work! Respects! ♥️

[@chaltonaloe457]

Thanks for your efforts guys. Really helpful.

[@konstantinospapafilakis9598]

Can I download office 2020 instead of office 2013?

[@stevepereira3746]

Thanks for the video, helped me out quite a bit :)

[@josephkingstonleomariamich7220]

You saved my day, thanks guys

[@neck-o]

When the notebook bar went on, I climaxed.

[@michaeljoseph7578]

Amazing! Really helpful! Thank you very much!

[@hardrod6989]

Gr8 video, please make the same for libre cal (like MS Excel)

[@faisalyuliono]

Thanks, that's great!

[@amulhossain2892]

update?

[@ncg5162]

Explained beautifully!

[@iamjoemomma2]

Awesome tips! Thanks a lot!

[@sjcap4233]

One question though why

[@azmathchoudhury8702]

well price and on linux u can't get Microsoft office. this video definitely secured me on going full blown linux now

[@MrArtist1971]

Used Word professionally for over 25 years. IT SUCKS. LibreOffice is wonderful.

[@billcallahan9303]

Thank you both! Great help!

[@YASSINEFLGHORBA]

Thanks man! You nice tuto!!

[@ashwith]

I do miss smart art though. Microsoft's implementation feels a lot better.

[@serdomoded3891]

It's amazing. Thank you for your advice. It very helps me.

[@ncg5162]

LibreOffice 6.4.4.2 has spell-checker built-in, no need to download.

[@staninjapan07]

It was all going well until you made the word processor look like a web browser, a mistake that "they" made. I have never understood why MS made Word etc look like they now do. Proper menus, that is cascading menus, are much, much more intuitive. Insert expletive here ( ).

[@WanderingAroundAZ]

To each their own. I find the latest iteration of MS Office *MUCH* more pleasing to use. Whenever I am forced to use an older (non-ribbon, or even prior ribbon) version of Office, I long for the current version. If you don't know where anything is, you just have to type the command in the search bar and you will quickly find it. I've been using MS Office since Windows 3.1 and it only continues to improve.

[@kannansekar9493]

Interesting to execute all this.. Thank you

[@TomTabaczynski]

What if you're moving from a Mac? Don't Mac users ever move to Linux? I haven't used Windows in years, hate the look of it.

[@HBgv5830]

Excellent job Guys... thanks a lot...

[@WatchingTrainsGoBy-PassingTime]

The notebook bar, MS clone is actually kind of ugly. I prefer the default function/style of libreoffice as is. Changing the icon set and color of background and theme was all it took to sharpen it up enough so I didn't feel like I was using something that was a compromise. It has paste unformatted in context menu, which is my biggest pet peeve of openoffice. I'm a libreoffice convert now. And Sasha is HOT! Call me. lol If you're married, please ignore that.

[@spatialnasir]

New vocabulary: Intercommunicationability 😅 14:28

[@papapunkz]

You are help me, a lot~ i really going to zero piracy

[@fon75]

Am I the only one who finds premise of MS office is always best and every alternative should be made exactly like MS office annoying? I mean really? Just because you get confused if the menues look a bit different? I have used all the MS Office versions and hold licenses up to 2016 and let me tell you I do not miss MS Office one bit. Libreoffice is actually dramatically better than MS office in many areas. Not to mention the extreme bloat in MS office and the fact it is calling home ALL THE TIME.

[@davidleecrites]

100% Agree!!!!! I can make Writer look enough like Word that folks make the transition without difficulty, which is what I bring to the table.

[@capocannoniere7]

Thanks, 2020 still works

[@mariajiao4855]

Being different from MS Office doesn't mean being ugly. Libre looks ugly to me

[@docholliday1811]

Awesome video thanks!

[@hernancobo883]

It's free!!!!

[@suruadamable]

you are legends, thanks

[@berniesutton7277]

Leebray?...

[@LinuxTechShow]

'Leebray' = Spanish, 'Leebruh' = French. Both are correct. We tend to use the Spanish pronunciation. Funny, since we're Canadian :)

[@chilidog73]

Love it but the label feature is soooo horrible. Why do I have to go thru a whole extra step of creating a database first. Should just be part of the steps when creating a label. It's rediculous.

[@omkarrathore1868]

Really helpful.

[@bazwillrun]

All i kept noticing was how she couldnt get a word in edgeways...he just kept talking over her !..

[@192ali1]

I am very pleased with the LibreOffice service. I do not see any difference between MS window and LibreOffice. MS has made billions of Dollars from people and still is greedy to milk us. To purchase office from MS cost a couple hundred dollars. The funny part is that it last for only a couple years and have to pay another couple hundred dollars to renew it. This greedy behavior of MS is nothing short of taking advantage of public and rob them. I intent to donate some good amount of money to LibreOffice to appreciation their service. I strongly believe that everybody who uses the LibreOffice service should not take advantage of the initial free service but should have a good conscious to donate, and to support them.

[@wordart_guian]

If you don't see Any difference between MS Windows and LibreOffice, I have serious concerns. And I have been using the same €120 office licence since 2007 without problems.

[@rtsa4633]

@@wordart_guian Yh LibreOffice looks severely outdated. For those of us on linux there are also WPS and SoftMaker FreeOffice which are just as good free alternatives. However Libre is the best opensource suite. Just needs a UI update to get things modernised.

[@wordart_guian]

@@rtsa4633 I'd say that LibreOffice needs to exist. We do need an entry-level free office suite, for all the people who can't afford more and don't rely too much on some Advanced features. And (while I'm not very knowledgeable about it) I guess it being open source brings Something interesting on the table. However the OSS fanboys claiming there's no difference between MSO and LO are plain wrong. Typically they are the same people saying office was basically complete in 1995. Most people may use 5% of office, but nobody uses the same 5%. Office has Evolved a ton in the last 25 (!) years. As a genZ kid, there are features I take for absolutely granted that were Added in 2003 or 2007, or even after! I mean, I don't ever run excel without using the 2007+ tables and conditional formating, because they help me vizualize and organize data (there isn't anything in excel that I use more than these actually) ; but I don't think these two features were ever Added to LO. So I totally agree that LO plays an important role, but Office honestly can't be dismissed.

[@rtsa4633]

@@wordart_guian Those other proprietary alternatives offer the same features for linux and arent lacking in the same way libre is. They look interesting. Libre is getting better however recently with their new updates. I can see it having every basic feature it should already have in the next few years. I will be happy one we have a complete feature rich open source alternative. I also have a 2007 office disk :)

[@wordart_guian]

@@rtsa4633 Does WPS stand for WordPress Something? If so, it should be qualitative, as an historical high-end competitor to Word, but I doubt WordPress would be free. I guess Softmaker free office is, though.

[@VermillionRedd]

Free is free. And free is good

[@trafalgarla]

Personally I think this makes libreoffice look ugly. I like the look of libreoffice's layout

[@BharathBhushan13]

agree, I think, LibreOffice developers should polish the icons and tweaks in their own way. It looks kinda old and doesn't catch up with the DE.

[@georgevanvalkenburg2560]

THANKS CAT 5...

[@haha5571]

brilliant

[@samuelm2223]

sweet

[@rubendragan6514]

thanks

[@delliridelliri]

eu amo voces

[@Amonny]

He is very informed and she isn't.

[@VermillionRedd]

True

[@zdzichzcan2808]

what is free never works

[@genkiferal7178]

bs. Many people use free software for video editing and do just fine with it. Same for writing books or editing photos.

[@Cobalt2112]

First!

[@clumein2]

banging my head against the wall with their jabbering.... just get to the point... for god's sake!

[@drteeth7054]

Would have been a good video if a) there were one presenter and b) if you were not trying to be funny. Big miss!

[@seebee216]

Who wants ANYTHING to be like anything Mikkysoft???? HAH!

[@WilliamVG]

Microsoft wants us to pay a yearly fee to run Microsoft Office. No Thanks.

[@WanderingAroundAZ]

You can pay for it by the month as well 🙄

[@genkiferal7178]

the New World Order's new plan is to have us all lease/rent and not own. Leasing makes far more profit for the company and also gives the company more control over how that product can be used - or is likely to be used lest you pay a huge sum when you try to turn in the product or upgrade. Microsoft is one of the leading members of the NWO.