Connect with us

MS Excel

How to Freeze Panes Multiple Rows in Excel

Published

on

How to Freeze Panes Multiple Rows in Excel

In some cases, Excel freeze panes are needed, so that some columns or rows remain visible and do not move when scrolled.

This feature will certainly make it easier for users to read the required data.

But, how to implement this one feature? It’s so easy, really. Here’s the full tutorial.

HOW TO FREEZE PANES IN EXCEL

You can use this feature directly through the Tab View menu – Freeze Panes – Freeze Top Row like this.

How to Freeze Panes Multiple Rows in Excel

By doing so, the first line of your document will be locked or not moving when you scroll down.

Unfortunately, most people need those immovable rows a few rows down.

To do this there is another way that you have to do.

How to Freeze Multiple Rows in Excel

Since I want the unmoving are Student Name and Grade then all I have to do is put the cursor on the first Student Name.

After that click, the View menu – Freeze Panes – Frees Panes like this.

How to Freeze Panes Multiple Rows in Excel

By doing this, some of the lines won’t move even if you scroll down.

How to Freeze Excel Columns

As for the column, all you have to do is place the cursor where you want and then select the View – Freeze Panes – Frees Panes menu like this.

As a result, the column name will not move. Place the cursor in the tutorial above, you just need to adjust it to your own document.

That’s it for this tutorial, good luck, GUYS!

MS Excel

Determining Lowest and Highest Values ​​in Microsoft Excel

Published

on

Determining Lowest and Highest Values ​​in Microsoft Excel

Determining the lowest and highest values ​​requires a special formula or function that you can do with Microsoft Excel.

Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?

For that you need an Excel formula.

How to? Come on, follow this tutorial in full.

HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE

To do this, the formula you can use is MAX and MIN.

As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.

Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)

Number is the range of numbers for which you want to know the highest value.

Finding Lowest Value

Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).

As usual number is a range of numbers, or the same when you look for the previous highest value.

How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.

That’s all and good luck.

Continue Reading

MS Excel

How to Use Automatic Ranking Formulas in Excel

Published

on

How to Use Automatic Ranking Formulas in Excel

The formula for finding rankings in Excel is also available for those of you who want to rank in a group.

This one formula is a formula that is quite widely used, especially in the field of education.

Well, here’s an Excel formula tutorial to find rankings.

RANKING FORMULAS IN EXCEL

There are several formulas you can use that basically have the same function for finding rankings.

And the first formula you can use is = RANK(Number;Reference;[order]).

The order in the formula is the number 0 or 1 as a ranking reference.

When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.

But you also need to know that the formula will also give the same rank when there are the same values.

To overcome this you can use this one formula.

RANK.AVG Rumus formula

The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])

And when you apply it and there is the same value, it will produce an average ranking of that value.

So, for an assessment, this formula is the most appropriate.

Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.

That’s how the ranking formula in Excel works.

That’s all and good luck.

Continue Reading

MS Excel

How to Calculate Workdays with Excel Formulas

Published

on

How to Calculate Workdays with Excel Formulas

Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.

Most people are lazy to use Excel for their daily needs, even though this software is very useful.

Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.

HOW TO CALCULATE WORKING DAYS

You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.

But you also need to know that the weekends here are Saturday and Sunday.

For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.

The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])

For more details, consider the following image.

How to Calculate Workdays with Excel Formulas

In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.

NETWORKDAYS.ITL

Well, for this formula you can determine the time off or weekend as needed.

The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])

The difference in this formula is that [weekends] are used to exclude and treat as weekdays.

If you do not fill it in, it will be considered as the previous formula.

You can also use a holiday code with a seven-character text string consisting of a combination of the text numbers 1 and 0 to represent Monday-Sunday.

So what happens is the number 1 represents holidays while the number 0 for workdays.

For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.

As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.

That’s all and good luck.

Continue Reading
Advertisement

Latest

How to recover Facebook account tools to do it in minutes How to recover Facebook account tools to do it in minutes
Social Media4 hours ago

How to recover Facebook account: tools to do it in minutes

SHARE It is very common for users to lose their Facebook or other social media accounts. The reasons can be...

how to generate your own QR code for free and online how to generate your own QR code for free and online
How-To6 hours ago

Step by step: How to generate your own QR code for free and online

SHARE There is no denying the popularity and convenience of using QR codes. Therefore, it does not hurt to learn...

How to create a PayPal account what is this platform and what is it forHow to create a PayPal account what is this platform and what is it for How to create a PayPal account what is this platform and what is it forHow to create a PayPal account what is this platform and what is it for
How-To8 hours ago

How to create a PayPal account: what is this platform and what is it for

SHARE Technology has made many aspects of life easier, especially those that have to do with payments, purchases and money...

How to clean a transparent cover How to clean a transparent cover
Useful-Info2 days ago

How to clean a transparent cover

SHARE If you have had a transparent cover on your mobile, you will know that as days go by, it...

What does XD mean in WhatsApp What does XD mean in WhatsApp
Internet2 days ago

What does XD mean in WhatsApp

SHARE WhatsApp is one of the most downloaded applications worldwide. This fast messaging service allows you to send and receive...

How to protect a pdf file How to protect a pdf file
How-To3 days ago

How to protect a pdf file

SHARE Many times we create pdf files that we don’t want anyone to be able to edit, copy, or even...

How to convert a Word document to PDF How to convert a Word document to PDF
How-To3 days ago

How to convert a Word document to PDF

SHARE Microsoft Word is a powerful word processing program that offers many possibilities features. Its only drawback is that by...

How to create a PDF document How to create a PDF document
How-To3 days ago

How to create a PDF document

SHARE A PDF file is a portable document, that is, it is illustrated in 2D and can be opened from...

How to convert an ePub to PDF How to convert an ePub to PDF
How-To3 days ago

How to convert an ePub to PDF

SHARE The different computer programs that exist to make working documents adapt to all needs. Spreadsheets, text and image editors,...

How to Access Google Drive Files Without Internet, Really Easy How to Access Google Drive Files Without Internet, Really Easy
How-To4 days ago

How to Access Google Drive Files Without Internet, Really Easy

SHARE Google has just launched a new feature that can help users when offline or not connected to the internet....

Advertisement

Categories

Trending

Copy link
Powered by Social Snap