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 11 in Database by Edureka
• 9,700 points
34 views

1 answer to this question.

0 votes

To quickly sort, select the Sort A to Z / Z to A icons in the Sort & Filter group of the Data ribbon by clicking the arrow below the Sort & Filtering symbol in the Editing group of the Home ribbon. Sort Smallest to Largest and vice versa are the labels in Excel 2013.

image

To perform a more complex sort, go to the Home ribbon and select Custom Sort from the Editing group's arrow below the Sort & Filter button. This opens the Sort dialogue box that appears when you click the Sort symbol in the Sort & Filter group of the Data ribbon.

image

answered Apr 11 by Edureka
• 8,820 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 in Database by Edureka
• 8,820 points
20 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 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer

Change default 'delimiters' in excel

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

answered Feb 21 in Database by Edureka
• 8,820 points
30 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 in Database by Edureka
• 8,820 points
37 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 in Database by Edureka
• 8,820 points
47 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 in Database by Edureka
• 8,820 points
36 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 in Database by Edureka
• 8,820 points
45 views
0 votes
1 answer

Disable Sorting in excel

You may discover that adding a filter, ...READ MORE

answered Apr 5 in Database by Edureka
• 8,820 points
52 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP