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 […]
Learn some nice Microsoft Excel keyboard and mouse shortcuts
User manual describing how to change the menu language in Excel or other Microsoft Office products.
The office-tips.net blog will be a place for tips and trixs that hopefully makes it easier to use Microsoft office products and other daily use software products.
