Excel Archives - Office-Tips

WordPress

26/03/2019UncategorisedCalendar, Calendar 2019, columns, days and weeks, drop-down, Excel, excel and hyperlinks, Excel Tips, hyperlinks, jump inside excel, Look up a value, Microsoft office, move between sheets, move column, move columns, move row, move rows, Office365, unhide

WordPress

Blog posts

Hide and Unhide rows and columns in Excel

18/03/2019Excel, Microsoft Office, Office Tipsdrop-down, Excel, Excel Tips, Microsoft office, Office365

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 […]

4 steps to Unhide everything – Quick tips

17/03/2019Excel, Microsoft Office, Office TipsExcel, Excel Tips, Microsoft office, Office365, select all, show all, show everything, un-hide, unhide

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 […]

1 look-up function, Index and Match

17/03/2019Excel, Microsoft Office, Office Tipsdrop-down, Excel, Excel Tips, Microsoft office, Office365

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 […]

5 steps to create a drop-down list

16/03/2019Excel, Microsoft Office, Office Tipsdrop-down, Excel, Excel Tips, Microsoft office, Office365

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 […]

3 ways to Look up a value

14/03/2019Excel, Microsoft Office, Office TipsExcel, Excel Tips, Find, Look up a value, Microsoft office, Office365, search, Search and find

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, […]

3 easy steps to Move rows or columns

13/03/2019Excel, Microsoft Office, Office Tipscolumn, columns, Excel, Excel Tips, Microsoft office, move column, move columns, move row, move rows, Office365, row, rows

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 […]

2019 Calendar

12/03/2019Excel, Microsoft Office, Office TipsCalendar, Calendar 2019, days and weeks, Excel, Excel Tips, Microsoft office, Office365, week numbers

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 […]

6 ways to unhide all rows & columns in Excel

12/03/2019Excel, Microsoft Office, Office TipsExcel, Excel Tips, Microsoft office, Office365, unhide, unhide all, unhide column, unhide rows

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 […]

3 steps to remove Hyperlinks in Excel

11/03/2019Excel, Microsoft Office, Office TipsExcel, excel and hyperlinks, Excel Tips, hyperlinks, Microsoft office, Office365, remove hyperlinks

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 […]

1 click or 1 key combination

10/03/2019Excel, Microsoft Office, Office TipsExcel, Excel Tips, jump inside excel, Microsoft office, move between sheets, Office365, select all

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 […]

Change language in Office

08/03/2019Excel, Microsoft Office, Office TipsExcel, Excel Tips, Microsoft office, Office365

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 […]

1st blog on Office‐Tips.net

06/03/2019Microsoft Office, Office Tips, WordpressExcel, Excel Tips, Microsoft office, Office365, Wordpress

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 […]