Topics Search

How To Use Go To Special In Excel

In this tutorial we’re going to go through all the various options that Excel offers with the Go To Special command. This is one of my favorite options in Excel and I use it practically every day. So take a few minutes and you too will see all the benefits of Go To Special in Excel.

Parallax Image Scrolling Animation with CSS 3D and JavaScript

While there are many solutions to achieve parallax scrolling on the web, it’s my impression that most fake the images-in-depth effect. Inspired by a OS X screensaver, I realized that CSS 3D would allow images to be actually set back on the z axis, providing true perspective and parallax when the images were moved up and down.

How to Insert a PDF File in an Excel Sheet

Microsoft Excel allows us to represent data in a uniform way. We can show complex data in the form of charts or tabular format. Suppose, you have a list of products that you want to share along with the product description and specifications. Then using Excel would be a great help. Thinking how it can be done? Let me tell you that. Say, you have the details of the product in a PDF File, and then having the product names in one column and the respective PDF files in another column would solve the problem. So, in this article, I will let you know how to insert a PDF File in an Excel sheet.

Excel Control Settings for Every New Workbook and Worksheet

Every time I start a new workbook or insert a new worksheet, I always make the same customizations, such as setting print scaling to fit to one page wide, setting certain margins, adding a “Page 1 of n" footer to the worksheet, making the heading row bold, and so forth. How can I have these settings applied to every new workbook or worksheet?

Random Numbers

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. The RAND function generates a random decimal number between 0 and 1.

Add PowerShell file (*.ps1) to New Context Menu of File Explorer

In this article, we will see how to get a useful context menu item to create a New -> Windows PowerShell script. It will save you time if you need to create them from time to time. You get a new file with the PS1 extension instantly with one click. Usually, to create a PowerShell file, you can either create a new text file and rename its extension every single time to .ps1, or you can use Notepad.

How to Insert a Picture in Excel Comment

In some cases, you may want to insert a picture in Excel comment boxes. For example, if you have a list of products, then inserting product images in the comment box could make your Excel sheet easy to use. As soon as the user would hover the mouse over a cell that has a comment, it would show the comment and the picture within it.

Running An Excel Macro From The Immediate Window

Today let’s take a look at using the Immediate Window in the VBA debugging environment. This environment can be used as a type of scratchpad or sanbox areas and has many uses as well as debugging code. If you cannot see the Immediate Window, you just need to enable it. It really simple.

How to change locale and language of Bash

If you use the built-in Bash on Ubuntu feature in Windows 10, you might notice that it follows the operating system's installed language. Suppose you want to change the language for Bash only. For example, my Windows 10 is in English, but I want to use Bash in Russian. Here is how it can be done.

Fix unable to resolve host error in Bash on Ubuntu

If you run the sudo command in Bash on Ubuntu in Windows 10, you might face the issue that it shows an error message unable to resolve host followed by your computer name. Here is a quick fix for this issue.

How to Ignore Case When Using Tab Completion in the Linux Terminal

The command line in Linux is case sensitive. When you use tab completion to quickly change or list directories on the command line, you must match the case of the directory names. However, there is a way to make tab completion case insensitive.

How to Hide or Show App Badges on the Windows 10 Taskbar

The Anniversary Update for Windows 10 adds badge icons for universal apps pinned to the Taskbar. While you can’t turn icon badges on and off for individual apps, you can disable all badges if you want. Fire up Windows Settings by clicking Start and then clicking the Settings button (or by pressing Windows+I on your keyboard). On the main settings screen, click “Personalization.”

Should You Use Windows’ Full-Drive Compression to Save Space?

Open a drive’s properties window, and you’ll see an option to “compress this drive to save disk space” on Windows. But how much disk space will you save, and what’s the catch? Windows uses the NTFS file system, and NTFS has a built-in compression feature that allows you to compress individual files and folders.

How to Add Tabs to Ubuntu’s Terminal

If you work a lot in the command line, you probably keep more than one Terminal window open at once. However, instead of having separate windows, you can condense all your Terminal sessions onto one window using tabs. We’ll show you how to open multiple Terminal sessions as tabs in Ubuntu.

Plugs Are to Elixir What Rack Is to Ruby

Plugs are to Elixir what Rack is to Ruby. As such, they both use functions to manipulate web requests. The principle behind plugs is simple, as is their implementation. In this article, we’ll explore basic plug usage, from “hello world” to a JSON API.

Is It Safe to Delete Everything in Windows’ Disk Cleanup?

The Disk Cleanup tool included with Windows can quickly erase various system files and free up disk space. But some things–like “Windows ESD Installation Files” on Windows 10–probably shouldn’t be removed. For the most part, the items in Disk Cleanup is safe to delete.

What Are Factory Functions

You can’t get far as a JavaScript programmer without learning about functions and objects, and when used together, they are the building blocks we need to get started with a powerful object paradigm called composition. Today we’ll look at some idiomatic patterns for using factory functions to compose functions, objects and promises.

How to Recover a Lost or Corrupt Document in Microsoft Word 2016

Have you ever had a troublesome .doc or .docx file Word that you can’t seem to open? Or even lost a document completely, with all your hard work gone with it? We’ve all been there before, and if you don’t already, this is a hard lesson that you should keep your computer backed up. There are plenty of free and cheap programs that will ensure this doesn’t happen in the future, so once you’re done with your work, do yourself a favor and set that up.

XML Sitemaps: The Beginner’s Guide

XML sitemaps are simple text files that are used to provide details for every URL on a website. They include location, date of last modification, change frequency and page priority. If you’ve got an international or multilingual site, you can also use your sitemap to note the relationship between language versions of a URL. All of these elements provide search engine bots with information about your site, helping them crawl and index pages easily and more efficiently.

Setting up a Living Styleguide in Jekyll

I was recently working on a small Jekyll project and wanted to see whether it would be possible to have a very component-ized approach driven by a styleguide, despite the fact that Liquid (the template engine behind Jekyll) is not meant to do that.