Office Nifty
Office Nifty
  • 110
  • 401 776
Merge Columns in LibreOffice Calc
Quickly combine data from multiple columns into one by using a formula in Calc. This videos goes over two ways, using & (ampersand) symbol and the Concatenate() function. It also explains why using the Merge Cells icon is not necessarily ideal for combining information from columns.
Official help page on how to Merge and Unmerge cells
help.libreoffice.org/latest/en-US/text/scalc/guide/table_cellmerge.html
Official help page for the Concatenate() function
help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3149688
#LibreOfficeCalc
Переглядів: 89

Відео

Limit Number of Rows and Columns (Simplify your Sheet) | LibreOffice Calc
Переглядів 333Місяць тому
Having thousands of columns available, or endless rows, can be a bit annoying and aesthetically unpleasing. This video shows the fastest way to limit the number of rows by hiding them, and then how to unhide them properly as needed. *Video Chapters* 0:00 How it'd look 1:19 Hiding columns 1:57 Hiding rows 2:47 Unhide columns 3:16 Selecting hidden columns 3:52 Unhide rows 4:07 Right click on row ...
Get Day of the Week from Date in LibreOffice Calc
Переглядів 5022 місяці тому
The WEEKDAY() function will return the day of the week as a number value. However, to show the name of the day of the week, we can use cell formatting. This video goes over both scenarios and how to add a custom date format if it's not one of the choices in Calc. *User-Defined Number Formats* help.libreoffice.org/latest/en-US/text/scalc/guide/format_value_userdef.html *Number/Date Format Codes*...
Date Differences Made Easy with the DATEDIF Function in LibreOffice Calc
Переглядів 3023 місяці тому
Calculate date differences and intervals easily with the DATEDIF function. This video goes over the three parameters, a common date format error, and the six different interval types supported. Calculating with dates and times using * and -* operators, instead of a function. ua-cam.com/video/H4LHGTtzC0s/v-deo.html Official LibreOffice Calc help page on using DATEDIF, as shown at 1:20 help.libre...
Add a Button to Run Macro in LibreOffice Calc
Переглядів 1,6 тис.3 місяці тому
This video goes over adding a button to your sheet using Form Controls, and then changing the button's look and feel. Next, we assign an existing macro for one of the button's event, so that it will run every time we click the button. Most importantly, I discuss macro security settings and how to prevent using them in untrusted files. Lastly, I answer a viewer's question about using a button to...
Office Nifty Channel Memberships! What are the Perks?
Переглядів 603 місяці тому
Thank you to all my viewers, and especially subscribers!! Because of you, this channel now gets to have memberships. I've set it up to support Calc learners to by provide upcoming exclusive lessons, spreadsheet templates, having weekly office hours, and more! I really recommend you to give it a try (it's really cheap), and I'd be happy to hear from each one of you to accelerate your learning. #...
Using Arrow Key Navigation in LibreOffice Calc
Переглядів 3374 місяці тому
Using the arrow keys will move your cell selection in the direction you choose. However, when the Scroll Lock key is pressed, it keeps the selection in place and can scroll the sheet instead. This video will show that scenario and the benefits, and also show keyboard shortcuts with arrow keys navigation in the sheet, including selecting multiple cells quickly compared to just using the mouse. 0...
How to Use the OFFSET Function in LibreOffice Calc
Переглядів 6444 місяці тому
Offset lets you target cells in relation to a designated cell location. This video shows how to choose an offset range, and even dynamically choose disjointed ranges. *Formulas used in the video* Selecting One Cell =OFFSET(B4,1,1) Selecting a Range =OFFSET(B4,1,1,1,3) Selecting Every Third Row =SUM(OFFSET(B4,2*(ROW(C1)-1) 1,4,1,3)) Official LibreOffice help page on using the Offset Function hel...
How to Get the Sheet Name in LibreOffice Calc
Переглядів 4645 місяців тому
Populate a cell with the name of a sheet dynamically into your sheet. A benefit of this is to avoid typing it and updating it manually when renaming sheets or duplicating sheets. You don't want the cell to end up with the old name! Formulas used in this video: =CELL("filename") =RIGHT(A1,LEN(A1)-FIND("#$",A1)-1) Video Timestamps: 00:00 Methods to Insert Sheet Name 00:34 Using Edit Mode to Inser...
Check If Cell Contains Text in LibreOffice Calc
Переглядів 4145 місяців тому
This video goes over a few functions that can help with checking or finding specific text in a cell. Using VLOOKUP video tutorial: ua-cam.com/video/LCpYXwGbHDI/v-deo.html For further info, here are official help pages: Using the Find Function help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3152589 Using the Search Function help.libreoffice.org/latest/en-US/text/scalc/01/04060...
How to Add and Use a Checkbox in LibreOffice Calc
Переглядів 5 тис.5 місяців тому
Check boxes are one of many Form Controls available in LibreOffice. This video goes over how to add one, then link it to set values in another cell. Official LibreOffice Help page on using Form Controls ⬇ help.libreoffice.org/latest/en-US/text/shared/02/01170000.html
Using Clicking to Populate Numbers Quickly (AutoFill guide)
Переглядів 3226 місяців тому
AutoFill is a handy way to generate a series of numbers, prices, and dates. It's also quick to apply using the mouse to click and drag. Link to my video on using Sort Lists: ua-cam.com/video/AzsVWezqBj4/v-deo.html Official help page on using AutoFill and Fill Series dialog: help.libreoffice.org/latest/en-US/text/scalc/guide/calc_series.html
Populate Text Quickly (Using Sort Lists) in LibreOffice Calc
Переглядів 2646 місяців тому
Using Sort lists can help fill down cells with values in a column. This video shows how it works, and to add your own specific lists to use and save time. Official help page on using Sort lists: help.libreoffice.org/latest/en-US/text/scalc/guide/sorted_list.html #LIbreOfficeCalc
Enable Macros in LibreOffice Calc
Переглядів 4,6 тис.6 місяців тому
By default, macro recording is not available in Calc. This video shows where to enable it in the Options section. You can try it by going to Tools ➡ Options ➡ LibreOffice ➡ Advanced, and check the box for Enable macro recording. Link to my Getting Started with Macros video: ua-cam.com/video/uTreRVO7CC0/v-deo.html Link to official Calc guide on using macro recording: books.libreoffice.org/en/CG2...
How to Import Data from Web into Calc (Using WebQuery)
Переглядів 1,8 тис.6 місяців тому
Some webpages have tables in them, and using copy and paste can give bad results. This video will show the LibreOffice Calc feature to help insert tables into your spreadsheet. Link to the Wikipedia page of U.S. Presidents: en.wikipedia.org/wiki/List_of_presidents_of_the_United_States Link to official help page for using Web Page Query help.libreoffice.org/latest/en-US/text/scalc/guide/webquery...
Applying Formatting to Dates in LibreOffice Calc
Переглядів 1,8 тис.8 місяців тому
Applying Formatting to Dates in LibreOffice Calc
Getting Started with Macros (Basic Examples) in LibreOffice Calc
Переглядів 11 тис.11 місяців тому
Getting Started with Macros (Basic Examples) in LibreOffice Calc
How to Use Group and Outline in LibreOffice Calc
Переглядів 2,1 тис.Рік тому
How to Use Group and Outline in LibreOffice Calc
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
Переглядів 570Рік тому
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
Keyboard Shortcuts for Copying and Renaming Sheets | LibreOffice Calc
Переглядів 468Рік тому
Keyboard Shortcuts for Copying and Renaming Sheets | LibreOffice Calc
Getting Started with Mail Merge in LibreOffice Calc and Writer
Переглядів 8 тис.Рік тому
Getting Started with Mail Merge in LibreOffice Calc and Writer
How to Paste into Multiple Cells | LibreOffice Calc
Переглядів 3,5 тис.Рік тому
How to Paste into Multiple Cells | LibreOffice Calc
How to Use AutoOutline in LibreOffice Calc
Переглядів 658Рік тому
How to Use AutoOutline in LibreOffice Calc
How to Export to CSV in LibreOffice Calc
Переглядів 3,1 тис.Рік тому
How to Export to CSV in LibreOffice Calc
How to Add Days to Date in LibreOffice Calc
Переглядів 2,9 тис.Рік тому
How to Add Days to Date in LibreOffice Calc
How to Set the Print Area in LibreOffice Calc
Переглядів 13 тис.Рік тому
How to Set the Print Area in LibreOffice Calc
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
Переглядів 4,4 тис.Рік тому
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
How to Jump to the Last Row in LibreOffice Calc
Переглядів 1,5 тис.Рік тому
How to Jump to the Last Row in LibreOffice Calc
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
Переглядів 2,2 тис.Рік тому
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
How to Concatenate Cells in LibreOffice Calc
Переглядів 7 тис.Рік тому
How to Concatenate Cells in LibreOffice Calc

КОМЕНТАРІ

  • @ImolaS3
    @ImolaS3 4 дні тому

    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

  • @wyrierit
    @wyrierit 5 днів тому

    Thank you, Office Nifty!

  • @shrek132
    @shrek132 6 днів тому

    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!

  • @t-love8351
    @t-love8351 9 днів тому

    thanks!

  • @DB-su5qp
    @DB-su5qp 10 днів тому

    It didn't work.

  • @trupinion512
    @trupinion512 11 днів тому

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

  • @dannyfumagalli5454
    @dannyfumagalli5454 13 днів тому

    Worked, thank you!

  • @nabuk3
    @nabuk3 14 днів тому

    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.

  • @nabuk3
    @nabuk3 14 днів тому

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

  • @SurelyNotClover
    @SurelyNotClover 14 днів тому

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

  • @aliyilmaz852
    @aliyilmaz852 17 днів тому

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

  • @stantons9309
    @stantons9309 17 днів тому

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

  • @islamicbookstore
    @islamicbookstore 21 день тому

    any way to add a strikethrough button on the toolbar?

  • @hapsyd
    @hapsyd 22 дні тому

    Please help

  • @hapsyd
    @hapsyd 22 дні тому

    The button didnt work when klick

  • @drallisimo34
    @drallisimo34 Місяць тому

    tks for tutorial!!!

  • @drallisimo34
    @drallisimo34 Місяць тому

    cool tuorial!!!

  • @msnoemify
    @msnoemify Місяць тому

    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

  • @gaylemarquez1277
    @gaylemarquez1277 Місяць тому

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

  • @joern.schaut.youtube
    @joern.schaut.youtube Місяць тому

    the information I needed, thank you very much!

  • @49Macman
    @49Macman Місяць тому

    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.

  • @49Macman
    @49Macman Місяць тому

    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.

  • @erichepperlewp
    @erichepperlewp Місяць тому

    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

  • @neosrinath
    @neosrinath Місяць тому

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

  • @kaycherryman5291
    @kaycherryman5291 Місяць тому

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

  • @amiga2025
    @amiga2025 Місяць тому

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

  • @andreibuciu9591
    @andreibuciu9591 2 місяці тому

    Thanks for sharing this knowledge!

  • @e2linuxos
    @e2linuxos 2 місяці тому

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

  • @issameldaghayes5428
    @issameldaghayes5428 2 місяці тому

    شكرا

  • @allanrichardson1468
    @allanrichardson1468 2 місяці тому

    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?

  • @DiseñoFompac
    @DiseñoFompac 2 місяці тому

    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?

  • @Darexor13
    @Darexor13 2 місяці тому

    Thank you so much for your tremendous help!

  • @sebzxford
    @sebzxford 2 місяці тому

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

  • @MartynaSpolnicka
    @MartynaSpolnicka 2 місяці тому

    Very helpful. Thank you so much. Needed that.

  • @ChasMusic
    @ChasMusic 2 місяці тому

    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.

  • @hulunnchoo
    @hulunnchoo 2 місяці тому

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

  • @richardthompson14
    @richardthompson14 2 місяці тому

    this looks nothing like libre sheets wtf?

  • @elation0x
    @elation0x 2 місяці тому

    Bad tutorial

  • @earthheavenisa
    @earthheavenisa 2 місяці тому

    Thank you so much!

  • @GnarledStaff
    @GnarledStaff 2 місяці тому

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

  • @BlackHat-uj6cq
    @BlackHat-uj6cq 2 місяці тому

    How do we do in two different sheet

  • @BillGreenAZ
    @BillGreenAZ 2 місяці тому

    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.

    • @officenifty
      @officenifty 2 місяці тому

      Thanks for leaving a comment, I appreciate it! 😃 Yeah I agree it would be more intuitive and user friendly if we could do it without moving the cursor all the way to left.

  • @miskandary
    @miskandary 2 місяці тому

    thanks alot , your video helped me a lot

  • @mansfieldtime
    @mansfieldtime 2 місяці тому

    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.

  • @AA-db9cb
    @AA-db9cb 2 місяці тому

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

  • @peterhoehsl
    @peterhoehsl 2 місяці тому

    Not working.

  • @lilium3324
    @lilium3324 2 місяці тому

    Libre Tech Tips

  • @SleazyDevs
    @SleazyDevs 2 місяці тому

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

    • @officenifty
      @officenifty 2 місяці тому

      Yeah for sure! How can I contact you on social media? I don't know if youtube allows email addresses in comment, but you can try to email me *mrhlee* at *gmail* dot com

  • @lyndieharkey2566
    @lyndieharkey2566 3 місяці тому

    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.