How to Edit a Drop-down List in MS Excel

by

Drop-downs are one of the most useful features in MS Excel. It can help users select a choice instead of manually entering them. This can help you avoid human errors and validate data. 

If you have a drop-down list in your spreadsheet, you might want to edit it at some point. The good news is that you can quickly edit your drop-down in Excel using several methods.

4 Methods of editing drop-downs in MS Excel

  • Editing a drop-down manually using data validation
  • Editing a drop-down list using ranges in data validation
  • Editing a drop-down using a table and data validation
  • Editing a drop-down using the OFFSET formula in data validation

Let us begin.

Read more

How to Add a Calendar in MS Word

by

It is easy to add a calendar in a Word document. You can do this in three ways.

3 ways to add a calendar in MS Word

  • Use MS Word’s Online Templates
  • Use the ‘Quick Table’ option
  • Use Tables to manually create a calendar.

We will show you all the three methods in simple, step-by-step instructions.

Let us begin.

Read more

How to Insert a Page Break in MS Excel

by

One way to control the amount of data to print on each page is to use page breaks. If you don’t know how to break down spreadsheets for printing, you are not alone.

Following any one of the five methods below will help you split your spreadsheet.

5 Methods of inserting page breaks in Microsoft Excel:

  • Inserting page breaks along the rows
  • Inserting page breaks along the columns
  • Resetting all page breaks
  • Removing page breaks
  • Moving page breaks

Read more

How to Insert a Checkbox in MS Excel

by

Checkboxes are great if you want to give two options to users. It’s great for assigning tasks, shopping lists, to-do lists, etc. 

You can check a checkbox by just selecting it and making a tick mark inside the checkbox. You can select it again to uncheck the checkbox.

You can quickly insert a checkbox in MS Excel using the below method.

Read more

How to Insert Multiple Rows in MS Excel

by

Many people know how to insert a single row in Microsoft Excel. 

Sometimes, you may need to insert multiple rows at a time. Inserting each row by itself can be very time-consuming. Luckily, there are various simple methods you can use to insert numerous rows into a spreadsheet.

3 Methods of inserting multiple rows in Microsoft Excel:

  • Repeating the insert function with the F4 key
  • Inserting multiple consecutive rows
  • Inserting multiple rows in different locations

Let us begin!

Read more

How to Remove Duplicates in Microsoft Excel

by

Removing duplicates is a common data cleaning task. It is also a very common interview question. Questions about removing duplicate data are common for jobs that need individuals to have Microsoft Excel skills. But even if you are not preparing for an interview, learning how to clean datasets will not hurt anyone.

This article will discuss three methods of removing duplicate data from datasets. You will understand the merits and demerits of each method. You will also see why one of the methods might give you a different result when compared to the others.

5 methods of removing duplicate entries in Microsoft Excel:

  • Removing duplicates using Power Query
  • Removing duplicates using the Remove Duplicates feature
  • Removing duplicates using the UNIQUE function
  • Removing duplicates using conditional formatting and filter option
  • Removing duplicates using the COUNTIF function and filter option

Read more

How to Sort Data by Date in Microsoft Excel

by

Datasets often contain many types of data. For example, some datasets include names, location, values, and time. If you don’t clean and organize a dataset, you may struggle to make sense of its contents. Sorting helps you make sense of the data.

You can sort the data by name, rank, or any other criteria. This article will show you two simple methods of sorting data by date.

2 methods of sorting data by date in Microsoft Excel

  • Sorting by date using the Format option
  • Sorting by formatting dataset as a table

We will explain how to apply either method in a few simple steps.

Let us begin!

Read more

How to Change the Width of a Column in Microsoft Excel

by

By default, columns and rows in Microsoft Excel have a fixed size. This size doesn’t change unless you change it. 

Since your data may be longer than the default column width, and if you don’t change the column size, your data will appear truncated.

This article covers four methods that will help you adjust the width of columns in Microsoft Excel.

4 methods to change the width of a column in Microsoft Excel

  • Changing column width using the mouse
  • Changing column width using the Format Auto-fit option
  • Changing column width by double-clicking the cell border
  • Changing column width by entering a specific size 

Read more

How to Insert Word Art in Google Docs

by

If you use Microsoft Word and love the word art feature, you might wonder if you can use it on Google Docs as well. 

Here’s the good news: you can! Word Art is a quick and easy way to add flair to your document and make it much more interesting. 

2 methods of inserting Word Art in Google Docs

  • Using the Insert and Drawing option
  • Using the Help and Drawing option

We will explain how to apply either method in a few simple steps.

Let us begin!

Read more

How to Start Page Numbering from a Specific Page in MS Word

by

It is often helpful to number the pages in your Word document. But what should you do if the first page is a cover page, and the second contains the list of contents? 

In that case, you would want to start the numbering from the third page onwards.

MS Word is highly flexible with page numbering. But you must divide your document into sections. This will allow you to number each section independently.

We will show you how to start page numbering from a specific page. We will use simple, step-by-step instructions.

Let us start.

Read more