Open Source

How to Delete Empty Rows in Excel
  • Online sales

If you regularly work with tables, you often encounter rows without content when reworking and restructuring them. Removing each of these rows by hand is often very tedious. However, Excel can find these blanks automatically. There are even several ways to delete blank rows in Excel. We will introduce two of them in the following.

Composr
  • CMS

The UK-based CMS ocPortal has undergone a rebrand: presenting Composr 10. Following in the footsteps of ocPortal 9, this CMS offers an all-in-one solution for web presences, with no need for extensions or templates. But who is Composr 10 suited to? And how does it compare to the CMS market leaders?

Excel SUBTOTAL function
  • Online sales

Excel functions generally calculate all values in their range – whether the cells are hidden or not. This is practical, as it does not change the final result. However, sometimes that is exactly what you want. If so, SUBTOTAL can help in Excel: Multiple calculations react to any existing filters and adapt the result accordingly.

How to insert comments in Word
  • Online sales

The built-in comment function in Microsoft Word is a great way of adding helpful information to your own documents or other texts. Any comments you add will be visible to all other users. Whether or not they can be edited or deleted depends on how the document access rights are configured. This guide explains how to insert comments in Word, and also how to edit and delete them.

The best Raspberry Pi operating systems: A brief portrait
  • Know-how

The single-board computer Raspberry Pi has enjoyed high popularity since its release in 2012. With the increasing number of possible applications, the minicomputer has become an interesting and practical solution for various branches of industry. As a result, more and more operating systems for the British computer are being introduced to the market. Choosing the appropriate Raspberry Pi...

Splitting Excel Cells
  • Online sales

If a table field contains several values, it often makes sense to split the respective Excel cell. Although the Microsoft spreadsheet program doesn’t offer a general function for this, you can split the cell content among multiple columns by configuring and using separators. We explain how you can use this option in your Excel document.

Squid: the license-free caching server for your web project
  • Configuration

If you’re optimizing your website, then you shouldn’t just turn to content and design; it’s important to also make sure that you invest ample time into the functionality of your website. Usability and loading time are just as important for a website’s success as high-quality and regularly offered content. A long loading time is one of the main causes of high bounce rates. The simple solution: a...

Turning on incognito mode in Chrome
  • Online sales

If you want to surf the Internet in private, your best option is to use the Chrome incognito mode. Incognito mode is a security feature that lets you browse the Internet without your history, cookies or other browsing data being stored. Read on to find out how to go incognito in Chrome and why you might want to do this.

Raspberry Pi: How to set up an SSH server
  • Configuration

Raspberry Pi has established itself as a reliable basis for servers of various types. Access – for configuration and maintenance purposes – rarely takes place on the mini computer itself, but mostly on a desktop computer in the same network. The communication protocol is the secure SSH (secure shell), which isn’t enabled by default and hasn’t been for some time. How to activate the Raspberry Pi...

The best alternatives to Facebook Messenger
  • Social media

Facebook's messaging function has long become indispensable as a means for many people to keep in touch with friends and colleagues – even on the move. Using Facebook Messenger app on your phone tends to use up a lot of battery power and internet data. Fortunately, there are good alternatives that allow you to navigate Facebook chats just as easily and quickly, and that often also help to protect...