Disable Sorting in excel

0 votes
I have an excel document with many columns and many rows filled with data. I want to be prevent user for sorting the data completely, but user should be able to insert and delete row as they wish. They can also edit any cells that they want.

May I know if there is anyway to achieve that?

Thanks.
Apr 5, 2022 in Database by Edureka
• 13,690 points
5,991 views

1 answer to this question.

0 votes

You may discover that adding a filter, in addition to sorting, assists you to better evaluate your data. When data is filtered, only the rows that fit the filter criteria are visible, while the rest are hidden. You can copy, format, print, and so on with filtered data without having to sort or relocate it beforehand. If you want to utilise a filter, follow these steps.

Select Filter from the Home ribbon's arrow underneath the Sort & Filtering symbol in the Editing group.

image

OR


Select Filter from the Sort & Filter group on the Data ribbon.

You'll notice that an arrow now appears next to the heading name in all of your column headers. You'll see a list of all the unique values in that column if you click the arrow next to the heading with which you want to filter. Click OK after checking the box next to the criteria you want to match. To further filter the data, click the arrow next to another heading.

Choose one of the following options to remove the filter:

Select Clear Filter from "Name of Heading" from the Filter icon next to the heading.
In the Sort & Filter group of the Data ribbon, click the Clear icon.
Select Clear from the Home ribbon's arrow underneath the Sort & Filter symbol in the Editing group.

answered Apr 5, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
1 answer
0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
595 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
1,091 views
0 votes
1 answer

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
1,892 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
854 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,147 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
5,246 views
0 votes
1 answer

Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
3,017 views
0 votes
1 answer

Disable Sorting in excel

To quickly sort, select the Sort A ...READ MORE

answered Apr 11, 2022 in Database by gaurav
• 23,260 points
756 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP