Team OfficeBeginner

How to Highlight the Highest and Lowest Values in Google Sheets

by

Checking for the highest or lowest value in a data set comes in handy on many occasions. To do this on Google Sheets, there are easy and efficient custom formulae that you can use.

  • Need to highlight the highest value within a cell range?
  • Need to highlight the top three cells with the highest values?
  • Need to highlight values within a single row?

We have got you covered. We have compiled the most comprehensive tutorial to guide you.

5 Methods of highlighting the highest and lowest:

Method 1: Highlighting the highest and lowest values within a cell range

1.1 Highest value within a range

1.2 Lowest value within a range

Method 2: Highlighting the highest and lowest values within a column 

2.1 Highest value within a column 

2.2 Lowest value within a column 

Method 3: Highlighting the highest and lowest values within a row 

3.1 Highest value within a row 

3.2 Lowest value within a row 

Method 4: Highlighting N cells with highest and lowest values 

4.1 Highlight top N cells with the highest value 

4.2 Highlight top N cells with the lowest value 

Method 5: Highlighting the entire row with the highest and lowest values 

5.1 Highlight row with the highest value

5.2 Highlight row with the lowest value

Let’s go over the methods one by one, starting with highlighting values within a cell range. 

Read more

How to count checkboxes in Google Sheets

by

In your Google Sheet, you might have checkboxes to know what is done and to be done. Say you want to count the checkboxes in your sheet. Google Sheet allows you to count the checkboxes easily. 

2 methods to count checkboxes in Google Sheets

  • COUNTIF to count the checked checkboxes
  • COUNTIFS to count the checked checkboxes based on a condition

Read more

How to Place a Circle Around Letters or Numbers in MS Word

by

You may want to place a circle around a certain letter or number in your MS Word document. This may be to emphasize an important point in the document. It may also be to simply decorate the text.

4 ways to put a circle around Letters and Numbers in MS Word

  • Use the Oval Tool
  • Use the Enclose Characters Tool
  • Insert a Circle Shape
  • Insert Enclosed Alphanumeric Symbols

We will show you step-by-step instructions for all the tools above.

Let us begin.

Read more

How to count non-blank cells in Google Sheets

by

Within a Google Sheet, you might have blank rows. Some of these rows could be populated with special characters that are not visible unless you click on the cell. There are multiple ways of identifying the number of cells that are not blank. Let’s go over these one by one. 

4 ways to count non-blank cells on Google Sheets 

  • Counting non-blank cells using COUNTA function 
  • Counting non-blank cells using COUNTIF function 
  • Counting non-blank cells using the SUMPRODUCT function 
  • Counting non-blank cells using Count value in the Taskbar 

Read more

How to count unique values in Google Sheets

by

When you add large amounts of data to your Google Sheet, you might have duplicates or repeated values. You might want to count the unique values, pick them out, or even find the occurrences of each unique value. 

4 methods to count and display unique values in Google Sheets

  • Using COUNTUNIQUE to count the unique values
  • Using UNIQUE to display the unique values
  • Using Remove duplicates to display the unique values
  • Using UNIQUE and COUNTIF to display the occurrences of each unique value

Read more

How to triple space in MS Word

by

Increasing the spacing between characters makes them more legible. Increasing the spacing between lines in a document makes the document more attractive. When presenting a paper in the Chicago format style, you must double-space the text. Sometimes, you only want increased spacing while printing the document.

3 ways to Triple Space in MS Word

  • Between selected characters 
  • Between selected lines
  • Between lines in the entire document for printing only

Let us start.

Read more

How to change the background color of the text box in MS Word

by

 A Text box within a document is a great way to attract the reader’s attention. Inside the text box place some important information you want to emphasize. There is another way you can make the text box more attractive. Change the background color to make the text box appear in a greater contrast from the document.

Microsoft Word allows you to easily change the background color of your text box. You only need to follow our step-by-step guide for changing the background color. 

Let us begin.

Read more

How to add outline in Google Docs

by

An outline is an important part of any professional document. Without an outline, everything looks muddled, and the vital parts lose significance. 

In addition, a document without an outline is hard to follow and lacks readability. Finally, an outline also serves as a table of contents with anchor links to jump to a specific section of a document.

So, in this tutorial, we’ll see the easiest procedure to convert an untidy document into a formal one by adding an outline. 

Without any ado, let’s begin.

Read more