How to Set Custom Tab Stops in MS Word

by

In an MS Word document, you can turn on invisible characters. These invisible characters have different purposes. For example, a dot represents a single space. A pilcrow represents a new paragraph, while an arrow represents a tab stop.

A tab stop allows you to start (or end) text at a specified point on your page. You can read more about it in our ‘What are Tab Stops?’ article.

2 ways you can set invisible, custom, tab stops:

  • Using the horizontal ruler.
  • Using the Paragraphs menu.

We will show you in simple, step-by-step instructions how to set custom tab stops using both methods.

Let us begin.

Read more

How to Insert Today’s Date in MS Excel

by

3 Methods of inserting today’s date in MS Excel:

  • Inserting today’s date in MS Excel using a keyboard shortcut
  • Inserting today’s date in MS Excel using the TODAY function
  • Inserting today’s date in MS Excel using the NOW function

We will explain these three methods in simple step-by-step instructions.

Let us begin.

Read more

How to Count Colored Cells in MS Excel

by

Sometimes you may use different colored cells in Google Sheets to represent categories. This makes your data easy to read. In such cases, it can be useful to count the cells based on the cell’s color. For instance, we have a list of student names and they’re colored. If the cell is red in color, the student is absent. If the cell is green in color, the student is present. 

If you want to know the number of students present, it’d be useful if you could simply count the green-colored cells, right? So we will show you how to do that in easy steps, plus there are four different ways in which you can count the colored cells.

Let us begin!

4 Methods of Counting Colored Cells in MS Excel:

  • Using SUBTOTAL and filters
  • Using VBA code
  • Using the FIND function
  • Using COUNTIF and GET.CELL

Read more

How to Unhide Columns in MS Excel

by

Hiding columns is useful for many reasons, but when someone else has hidden columns in a spreadsheet, it can be a pain to unhide them.

Fortunately, there are many methods to unhide columns, but know that some methods mentioned may not work for certain situations. Therefore, you should read through them all, to know what will work for you. 

This article will cover 10 methods of unhiding columns in Microsoft Excel.

10 methods of unhiding hidden columns in Excel:

  • Unhiding all the hidden columns
  • Unhiding specific columns using the Format icon
  • Unhiding specific columns using the context menu
  • Unhiding columns by changing the column width
  • Unhiding the first column
  • Unhiding columns using shortcuts
  • Unhiding columns using the Find option
  • Unhiding columns using the Go To method
  • Unhiding columns by inspecting documents
  • Unhiding columns using VBA Macros

Let us begin.

Read more

How to Hide Columns in MS Excel

by

If you don’t need something at the moment, you should keep it out of the way. The same principles apply when working with spreadsheets. If you don’t need a column, you should keep it out of the way. 

This article will discuss four methods of hiding columns.

4 methods of hiding columns in Excel:

  • Hiding columns as a group
  • Hiding individual columns
  • Hiding multiple columns
  • Hiding non-adjacent columns

Let us begin.

Read more

How to Move a Column in MS Excel

by

This article explains three methods of rearranging columns in Microsoft Excel. Two of the methods will work for small datasets. However, the last method will save you time when dealing with larger datasets.

3 methods of moving columns in Microsoft Excel:

  • Dragging and dropping the columns
  • Cutting and pasting the columns
  • Moving columns using data sort

Let us begin.

Read more

How to Insert Total Number of Pages in a Word Document

by

For a lengthy document, the total number of pages is important. It tells the reader how many more pages are left before reaching the end of the document. 

Also, this information is useful when printing the document. You know when you have reached the end of the document.

MS Word has the ability to print the current page number and the total number of pages. You may have a Word document that:

  • Already has the pages numbered
  • Has no page numbering 

We will show you in simple, step-by-step instructions how you can do this for both cases.

Let us begin.

Read more