Blog posts

  • Preferred plugins for WordPress administration /

    6 preferred WordPress “framework” plugins. Today we bring the first article about WordPress on Office-Tips and the chosen topic is plugins. This is just a short list of today’s favorites and must have plugins. It is called our preferred WordPress “framework” plugins due to the type of plugins. The list consists of plugins for site

    Categories: Office Tips WordPress
  • /

    Hide and unhide rows in Excel The article today “Hide and Unhide rows and columns” is just a quick introduction to hide and unhide rows. The first section covers hiding and showing a continuous series of rows. There are several methods, but we keep it to one and a series of rows this time.  In

  • /

    4 steps to Unhide everything – Quick tips Left Click with the mouse in field A1. Press [Ctrl] + [A] to select everything. Right click anywhere in the sheet. Select unhide from the pop-up menu All hidden rows should now be visible

  • /

    1 look-up function, Index and Match In today’s article the focus are the lookup functions Index and Match, and how they can be used together. Attached to the Article you will find a PDF version for printout. There is also an Excel file that have one sheet containing a dataset (booklist with columns author, title

  • /

    5 steps to create a drop-down list The topic of today is to make a drop-down list in Excel. In this article we will reuse the example Excel file we used in the “Look up a value” article and work in the second sheet, dataset containing the 99 recommended books list. The first thing we

  • /

    Look up a value The article today is the first explanation for use of a nested Excel function on Office-Tips.net. There are several ways of looking up values in Excel, our example is finding a value based on a set of given criteria’s.

  • /

    Move rows or columns One function that certainly is handy to know is the one that makes you able to move columns or rows where you want them by use of drag and drop. Before we learned this function the most used way to move columns or rows was by cut and paste. The steps

  • /

    Calendar 2019 Today’s post is just a calendar for 2019. So why did we make that one, well there was just a need to get an overview of the year for planning purposes. The one year calendar is at all time fixed on the wall above the desk. Old fashion maybe, but an easy way of

  • /

    How to unhide all rows & columns in Excel (mouse version) In this article we will explain an easy way of unhiding all rows and columns in Excel by use of the mouse. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A Right

  • /

    How to remove Hyperlinks. Have you ever imported data into Excel exported from internet? Then you know how annoying it can be that some fields act as HTML links and open ups the internet browser when clicking in those fields. At lest do we often meet that problem, sheet clean of linked fields are often

  • /

    One mouse click to select all. You might know how to select everything in a workbook sheet by use of the key combination [Ctrl] + [A]. But not all knows that one click on the corner button in a workbook sheet does the same. Everything will be selected by clicking the upper left corner square

  • /

    Change language in Office Among users of Office products that doesn’t have English as their native language there is often a wish to change language. They find it easier and handier to use their native language in Office. What we are looking at then is not to change the spellcheck or synonyms language, it is

  • /

    First blog on Office‐Tips.net Friday first of February 2019 was the blog office-tips.net published for the first time. At the same time as office-tips.net was publish did we also publish the Norwegian version of the blog office-tips.no The Office-tips blogs will contain tips and tricks that hopefully will make it easier to use Excel and

RSS
Follow by Email
Facebook
Twitter
LinkedIn