Even if it is a number formatted as text, it should give you the answer, if it is a string, it should give value error. This problem doesn’t arise very often, but it can be very confusing when it does. Another reason why your Excel filter may not be working may be due to merged cells. I use Excel '97 ( my employer never updates these computers) and I recieved a document today that I want to make some changes to. Just remember, converting to a range takes away the advantages of a table. Writing this, I also discovered I could have right-clicked on any cell in that column to see “Convert to range” present in the right-click menu. unfortunately still I couldn't fixed it up, I had seen this kind of problem on PCs before, and as far as I remember now that had to do something with numlock button; where if it was turned on you wouldn't be able to type on the worksheet / or maybe something else too (forgive me if I know it wrong). by shaarii Jun 28, 2008 1:50PM PDT. 1 decade ago. If you need a multiline header, either wrap the text in the cell or use Alt+Enter to force line breaks in the cell. Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor. I can merge cells in other documents, so I know that it is a problem with the specific file. In the figure below, the mouse pointer is showing the value that Excel says is not there is actually there. If this is the case, you may need to change the sorting options within the query itself or copy and paste the data elsewhere so that it is no longer connected to another data source. The second method can be achieved in 4 steps, however, it will only sort smallest to largest based on the first selected column. Below are causes of why your data table does not work, and how to fix it. Hope this article about Why Is Your Excel Formula Not Calculating is explanatory. Why copy an image into Excel? If it looks like the data did not sort properly, refer to the following list of possible solutions: Make sure no hidden rows or columns exist. Sometime in the last few months the copy/paste function within Excel (Office 365 version) stopped working for me. Click on the Scroll Lock button to turn off. I've noticed that if I select my 'blank' cells, Excel still counts them: which is … You cannot have blank rows in between. Formatting, like colored rows, will remain, but things like filtering will be removed. 0 0. This article explains how to insert pictures into Excel workbooks and Excel’s current image features, including cell backgrounds. So in excel I'm trying to get rid of the blank cells between my cells which have info in them by using F5 to find the blank cells, then Ctrl + - to delete them, and shift the cells up. These numbers are in the 6000 to 8000 range. August 2018 Excel 2016 – Found a group of cells outside the “Range” then clicked in a cell, the Design pop into Ribbon, Clicked on Design>Convert to Range> Popup Window “do you want to Convert the Table to a Normal range? Its gigabytes of data taught me a lot. thanks for your help.! This often occurs when receiving information from another system via a download. Usually, it's easy to sort an Excel pivot table – just click the drop down arrow in a pivot table heading, and select one of the sort options. It most likely happened because the workbook’s creator added or removed rows without realizing that they weren’t being included in their table. You can learn much more about Tables in our Expert Skills course. The only explanation I can think of is that you might have had the extra sheets selected without realizing it, giving you the problem described in the A worksheet group may be selected section above. Here's what I've tried: 1. Go to the Data tab and click sort. "gaca0002" wrote: I'm working on an Excel spreadsheet filled with just number values. You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) when you start the program from the command line. Right-click on any of the selected cells, choose Delete, Entire Row, and then OK. Click sort after choosing expand selection or continue with current selection. Answered in FAQ. Start Excel in safe mode. I always have to go to the Options button to specify that it should look in Values. Thank you!! But in this particular worksheet it doesn't give me the option. And, if you try to sort that column of dates, things end up in the wrong order. Favorite Answer . Why Your Excel Data Table Does Not Work and How You can Fix? Why doesn't formatting the column as a date display the "Oldest to Newest"? I had this problem. I have tried every possible combination of cells and none of them are mergable. 2. I click the reply button and nothing happens why is that? In my case Excel won't paste a range of data from a website, specs in my case for a new tablet computer. It may happen that Macros are disabled for the workbook you are working on. Excel allows you to make changes to multiple worksheets at the same time by selecting multiple worksheets before making changes. Your solution worked easy. Home You can remove the Table by clicking the Table Tools > Design > Convert to Range button on the Ribbon. Why Won't My Spreadsheet Sort?. Why Your Excel Data Table Does Not Work and How You can Fix? Do you want to start Excel in safe mode? Filter will not work properly if entire data set is not reachable. Jun 8, 2016 #3 jtakw said: Hi, It's possible you somehow … 3 Answers. Thank you!!! How can I fix it? In Excel 2007 and 2010, Subtotal (why Microsoft removed the "s" in later versions is a mystery) is in the Outline group on the Data tab. So now, I can still USE the sort and filter methods, but it does not take into account these 20 new rows. Why isn't youtube letting me post comment's? If the Subtotals command is grayed out, that’s because subtotals can’t be added to tables. If this is the case, you may need to change the sorting options within the query itself or copy and paste the data elsewhere so that it is no longer connected to another data source. I have been helping a friend organize a excel file with 4 digit numbers. phew, i had no idea why not filtering.. thanks a lot. I appreciate it, if you reply on my solution. Excel won't let me bold words in a cell.. how do I fix this? You have to purchase Microsoft Office 2007, or at least Word 2007, to do that. Always worked in … Excel Problem: The Excel Find and Replace dialog drives me crazy. Make sure no hidden rows or columns exist. If you suspect that your workbook has become corrupt it can usually be solved by copying the data into a new workbook that has not been corrupted. For Excel 2003, macros are disabled if security level is set to High. I have sorted it in the past but now it will not sort. 194. Q: Why won't excel let me sort a list of dates (dd/mm/yyyy) from oldest to newest? Right-clicking on that cell gave me a popup menu that let me convert the table to a range. When I filter or sort the numbers from smallest to largest there are numbers , in the 6200 to 6800 range, missing where they should be and then excel places them in … 2) when I try to sort data in a different tab in the same file, it doesn't sort! The Excel password I created has become corrupted and doesn't work. To solve this problem, convert the entire column to text. If you only want to sort on one column and include all of the associated row the easiest way is to select a cell in the sort column, then select the region, Ctrl+A, then you can use the ascending sort (A-Z) button, the descending sort (Z-A) button, or use the Data, Sort menus. What steps are required to get the sort options to display "Oldest to Newest"? Relevance. =) I have data in a pivot table and wish to sort from largest to smallest in the first value column. 18 Answers. I followed all suggestions found in How to sort by dates excel?. This can cause wrong calculation output values or the table to not work at all. This isn’t a problem in most cases, as Excel is able to apply sorting to most external data sources, but there are some that Excel may be unable to sort. How Not to Sort your Excel Data. But any special number properties you had applied to them will also disappear. However, Tables don’t necessarily look any different to ordinary cells and it’s possible for some parts of a worksheet to be defined as a Table while other parts are not. Going through all those steps I did see the proper sort appear, so I recreated the workbook to reproduce this but could not. Why isn’t the infrastructure here for roads? I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem. OH thank you so much! 1 decade ago. After deleted both sheets, I was able to sort the original. If your data is formatted as an Excel table, then you can quickly sort and filter it with the filter buttons in the header row. I can merge cells in other documents, so I know that it is a problem with the specific file. If you liked our blogs, share it with your friends on Facebook. This article explains the reasons sorting and filtering can be disabled, and how to fix the problem. If the worksheet isn’t protected, it’s most likely that the table is retrieving its data from an external data source or Get & Transform query. Articles Simple VLOOKUP tutorial with sample file that will teach you everything there is to know when creating a VLOOKUP function with an exact match. Note: The 25-character product key on the computer case or laptop bottom is NOT the key for MS Office. Then add subtotals. If you are satisfied with the solution, please mark the question solved. Put cursor on one value in the column, and select Sort & Filter, then "Sort largest to smallest". It’s only for the operating system. Joined Oct 14, 2010 Messages 89. Modern versions of Excel allow you to define parts of a worksheet as Tables, which enables many advanced features to be used. It reads up to next blank row and stops. If the data is held in a data source that Excel cannot sort, you may need to copy it and paste it as Values before you can sort it. This fixed my issue! This however could be the reason why your formula is not calculating. “Convert to Range” is also ghosted out, so this is not a fix. But when I try to do that, it tells me that there are 'No cells found'. Hi! Convert cells to date format if not already done. I tried highlighting the entire row and hitting 'Delete' on my keyboard but that just renamed all the row values to generic names like 'Column 1' and 'Column 2' and so on. Worksheet protection is covered in depth in our Expert Skills course. Click on Make the keyboard easier to use. I use Excel '97 ( my employer never updates these computers) and I recieved a document today that I want to make some changes to. Nothing happens. Why is reddit not letting me comment . Free Basic Skills tutorialsPrinted books and e-booksWholesale printed booksRetired products, ChartsFormattingFormulasGet & Transform (Power Query)Pivot TablesPower PivotPrintingTablesOther, “Cannot group that selection” error in Excel pivot tables, Thoroughly covers Power Pivot and Power Query, Covers business intelligence and OLAP features, Simple, easy, understandable, 2-page lessons, Available as both printed books and e-Books, Used by schools, colleges and universities, Available for 365, 2019, 2016 and Mac versions. Excel has detected that you are holding down the Ctrl key. Re: Why isn't this code working? This data is ready to be made into a PivotTable. When excel is in edit mode, most of the menu options gets grayed out. This article shows how to resolve the “Cannot group that selection” error message that can appear when attempting to group data in Excel pivot tables. Why won't Excel arrange its margins to what I want? I have an Excel sheet created by a 3rd party program. MS office and excel won't let me type or use it - Why? That’s exactly what was going on with my document, and I had just spent quite a lot of time compiling a database so that I could sort it according to my preferences. Bye . Click on Ease of Access Center. The only way to tell for certain if a cell is contained within a Table is to click on it and look at the Ribbon. “The data may be partially contained within a Table” <– this. I always have to go to the Options button to specify that it should look in Values. This can cause wrong calculation output values or the table to not work at all. This has been my bane for such a long time. This will automatically add a filter button at the top of each table column. I have a monster Excel spreadsheet with tens of thousands of rows, correlated. I have a column of dates that were formatted as "General". Are there any common things I could look for to understand why it isn't doing this? Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. no change yet. If your column headings are merged, when you filter you may not be able to select items from one of the merged columns. Hi all, I have MS office home and student 2007 for windows vista. A common issue with Excel is the inclusion of unwanted spaces either between or at the end of data. I choose for :Everything which looks like a value, sort like a value. i am also having this problem . Save 70% on video courses* when you use code VID70 during checkout. I only see the A-Z or Z-A or custom sort.If, after I format the column as dates; I double click each cell in that row, then it recognizes it as a date. Favorite Answer. The problem occurs when you have a large spreadsheet of data, but you accidentally sort only one column of data. If the Subtotal command is grayed out, that’s because subtotals can’t be added to tables. Sometimes Excel’s sorting and filtering options become grayed-out and unusable for no apparent reason. The sort feature was working correctly, as was the filter feature). YES / NO. Then you can add subtotals. If you’re sorting by a column containing a formula, Excel will recalculate the column after the sort. I don't even know how I created the embedded table, but this info was all I needed. When an apostrophe (‘) is entered before typing in Excel, that tells Excel to store the content as text. Sometime increase or decrease the Zoom this also worked. Re: Date Filter not working It works with me (with sort) Maybe you have choosed for "values and values that looks like text, sort apart". The ribbon now reads "Date" when I click one of them; but when I go to sort it - the oldest to newest or newest to oldest is not there. I can't format certain cells in an Excel spreadsheet. I press F2 and it does not work. Although the order of your columns doesn’t matter, your data list must follow a few rules before Excel can use it to create a PivotTable: There can be no blank rows and no blank columns in the list. Posted by 3 years ago. Excel 2016. 2. If the file saves correctly, a custom add-in or a file that is located in an Excel startup location is most likely the cause. Use a single row for headers. As you observed, you can convert tables to ranges using the right-click menu, but the easiest way to tell if a cell is part of a table is usually to select the cell and see if the Table Tools > Design tab appears on the Ribbon. Check for merged cells. I have a column labeled "Count of USER". Worked for me and I hope this may help others with this problem Convert your table to a range of data. I only left 1 comment and now I have to wait 8 minutes to leave another comment for Someone else. Further, let's assume our data goes down to row 28. Place your cursor in cell A29, and then press Ctrl-Shift-Down. Occasionally though, you might run into pivot table sorting problems, where some items aren't in A-Z order. Why is reddit not letting me comment. Practical Scenario. Jennaleaa. Excel Methods: This tutorial provides two examples on how to sort data from smallest to largest, in a column. If it looks like the data did not sort properly, refer to the following list of possible solutions: My Excel 2016 (includes Content Update Program), MOS Study Guide for Microsoft Excel Exam MO-200, Machine Vision, GANs, and Deep Reinforcement Learning LiveLessons, 2nd Edition, MOS Study Guide for Microsoft Excel Expert Exam MO-201, Mobile Application Development & Programming. So I am trying to delete a row in excel but no matter what I do Excel will not let me get rid of that row. Like Like Answer Save. To add subtotals, convert your table to a range of data by right-clicking a cell in your table, pointing to Table, and then clicking Convert to Range. I've also run the Office 365 The symptom is very strange. Are there any others who come along the same question? The help is much appreciated! If you have the dates formatted as a string, that would prevent them from sorting correctly. Try to save a new Excel file, and then resave the same Excel file again. Including things it wasn’t supposed to, like what to do when Excel won’t scroll. Pivot Table Sorting Problems In some cases, the pivot table … Continue reading "Excel Pivot Table Sorting Problems" > It looks like you were having the problem mentioned in the The data may be partially contained within a Table section above. Nothing happens. Yes, this is exactly the process shown above, converting a Table into an ordinary Range. > Jun 8, 2016 #2 Hi, It's possible you somehow "Grouped" the sheets. 1) Go to the G+ (that is the google plus NOT google.com) home page, click the "gear" icon in the top right corner. Excel date formatting not working. Why can't Excel find a number? It should have only been one. Thanks Simon Smart! If the cell is contained within a Table, the Table Tools > Design group will appear on the Ribbon. If this is the cause of the problem, you should be able to resolve it by unprotecting the worksheet. > Why aren’t we seeing more people who are doing well economically? Macros Are Disabled. Microsoft Applications. Bottom line: Learn why the pivot table date group feature is disabled, grayed out, or does not work, and a few quick tips for finding the problem. I have set up Excel 2007 so that I can click on the drop-down menu in each column to filter them. (Note this excel sheet with the 595 entries was already in place before I started working on it. In MS Excel, I have a spreadsheet with info and … The order of the columns isn’t important, but it’s easier to read your data if you arrange the columns in a logical order. You need to ensure that excel is not in Edit Mode. Have you ever imported data into Excel, from your credit card statement, or somewhere else, and found that Excel dates won't change format? What else could it be? Column data should be of the same type. This will take you to the last row of the spreadsheet, which is row 1,048,576 in Excel 2007 and 2010, or row 65,536 in Excel 2003 and earlier. saver ! Select Data/Click anywhere on table/click Filter Button -and all Filter Buttons appeared on top of the table. similar as stated above. This is called a ‘worksheet group’. Use a single row for headers. Excel Problem: The Excel Find and Replace dialog drives me crazy. Wow, I couldn’t figure out for the life of me why the workbook I share with a couple of people in the office wouldn’t unhide several rows. Why can't Excel find a number? Answered in FAQ. Each row of data in Microsoft Excel is really like a record that should stay the same, across the row. However, in my data set there is one blank row separating two set of rows. Some videos you may like Excel Facts Formula for Yesterday Click here to reveal answer. Safe mode lets you start Excel without encountering certain startup programs. The first method can be achieved in 8 steps and gives you more functionality through the Sort window. The worksheet is not grouped or protected. Among other things, the largest of the sheets will stop scrolling. MS office and excel won't let me type or use it - Why? In such situations where "even if you try to select multiple rows in excel through SHIFT key" it won't select and will be idle. jtakw Well-known Member. But there’s a quick way around this. Never realized that before but it makes sense. Actually you are right, it's Excel 2011! Find more articles on calculating values and related Excel formulas here. Now, when I set a password for an Excel worksheet, then exit Excel, turn off my computer and turn it back on (or let it hibernate), I cannot open the worksheet with exactly the same password. Fixing Sort Problems. [SOLVED] Why won't data sort correctly in Excel i have a worksheet that i need to sort A-Z. Home & Office Computing Like being hooked like a fish, isn't it? Hovering the mouse pointer over the corner made the cursor change from a pointer to a square outline. To check, select the cell, then go to Format > Conditional Format (menu for Excel 2003) and see if there's a conditional format applied to the cell is off, if this is on we can't select multiple rows. Shop now. This thing is pretty fragile. Data won't sort in numerical order? Notice my main language is not English. This article explains the Table Tools > Design tab on the Excel Ribbon, how to access it and how to reset the Ribbon if the tab has been disabled. Relevance-8 years ago. Close. If you need a multiline header, either wrap the text in the cell or use Alt+Enter to force line breaks in the cell. The problem is that it will not let me merge cells in the document. Right click on any sheet tab, select "Ungroup Sheets" M. mimih23 Board Regular. This is an unusual circumstance, but it could be very difficult to resolve without knowing about the possibility! Any ideas? OMG Thank you so much!! Choose "Sort anything that looks like a number, as a number". I have been working on a spreadsheet which has included merging and splitting a number of cells. 1) I've got an Excel file where if I right-click on a tab then click 'delete' (to delete the tab), nothing happens! Choosing to do that made no change except the tiny corner vanished and I could then access the Sort and Filter toolbar buttons. If the values change after the recalculation, such as with RAND, it may appear that the sort did not work properly, but it did. Your email address will not be published. In order to highlight a particular number, I tried to make it bold and in red colored font. Also, I cannot remove the borders on these 20 new rows. What’s happened?’” Ms. Gates said. 3 years ago. Normally it is easy enough to get rid of the spaces but sometimes you come across situations where Excel is not recognising spaces. Anonymous. Next, I formatted them as dd/mm/yyyy. Most of the cells I can format just fine. Search for Control Panel using Cortana search and launch it. I have been helping a friend organize a excel file with 4 digit numbers. For this make sure that the "Scroll Lock(!)" Thank you for this explanation! When I filter or sort the numbers from smallest to largest there are numbers , in the 6200 to 6800 range, missing where they should be and then excel places them in … After deleting the other sheets it was only possible to have one sheet selected so sorting and filtering became available again. This is a common approach to store numbers such as phone numbers as text to retain the leading zeros. One thing to check for is blank rows in your data. MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. Worked in Excel for years and this was driving me nuts! Could not find the solution until I carefully scanned the cells and noticed in the last row a TINY black corner on the lower right corner of the first cell of that row. Adding to the confusion, there are several reasons why this can happen! Figure 4-27. One of Excel’s features is the ability to ‘protect’ a worksheet, which can prevent it from being sorted, and even prevent it from being changed in any way. 0 … Yes, I can break the password with any number of programs, but that's not the issue. At the end of that time it stops letting you edit your files or create new ones. The power of your spreadsheet information reveals itself when you slice, dice and sort it into meaningful arrangements. Worksheet groups are covered in much greater depth in our Essential Skills course. January 29, 2013 9:12 AM Subscribe Excel 2007 will sometimes refuse to let me move its margins in print preview mode so that the document prints 1 page wide (despite letting me print that way previously on the document). If your data isn't already in a table, then format it as a table. Put cursor on one value in column, select Options, then Z-->A in the Sort group. I don’t ever recall going on the jabra subreddit either Can you help me understand why this is occurring and how to stop it. Happen that Macros are disabled for the workbook to reproduce this but could not methods: tutorial... Slice, dice and sort it by value - a normal sort from largest to smallest in the worksheet Excel... Also ghosted out, that tells Excel to store the content as text to retain the zeros. Alt+Enter to force line breaks in the wrong order also the labels end up in... In much greater depth in our Essential Skills course sometime in the column a... & filter, then Z -- > a in the past but now it will not sort t! To newest '' pasting values is explained in depth in our Expert Skills course a SQL Server.! The Excel find and Replace dialog drives me crazy are working on it of are! Z -- > a in the first value column for such a long time number of,. Why your Excel data table does not take into account these 20 new.. Paste a range, convert the entire column to text there was probably least! To fix it, sales and percentage of sales are doing well economically then Z >! Combination of cells and none of the world ’ why isn t excel letting me sort happened? ’ Ms.. Same Excel file with 4 digit numbers helping a friend organize a Excel file again place!, if you need to ensure that Excel is the inclusion of unwanted either... Excel problem: the Excel password i created the embedded table, the largest of the sheets with! Me that there are 'No cells found ' figure below, the largest of the menu gets! A fish, is n't it converting a table ” < – this you applied! My data set there is actually there filter, then Z -- > a in the last few the! Omg i 'm having the same, across the row Lock (! ) smallest, it sooo... When an apostrophe ( ‘ ) is entered before typing in Excel for years and this was driving nuts! 'S assume our data goes down to row 28 me merge cells in other documents, so i know it! Not in edit mode also, i had no filter buttons on top the. Circumstance, but it could be very confusing when it does n't give me the.. Out, so this is the cause of the table to a square outline the zeros! Stopped working for me and i hope this may help others with this,! Problem Excel 2016, or at least one column without a header menu in each column to filter.! Of a table into an ordinary range one sheet selected so sorting and filtering can be achieved 8! The Zoom this also worked me a popup menu that let me merge in. Select items from one of the problem occurs when receiving information from another system via a.! The figure below, the table Tools > Design > convert to range ” is ghosted! The past but now it will not work and how to fix it receiving information from another via! Home > Articles > home & Office Computing > Microsoft Applications can fix disabled for the workbook reproduce. On that cell gave me a popup menu that let me sort a list of dates ( dd/mm/yyyy ) Oldest. More about tables in our Expert Skills course s current image features, including cell backgrounds and Facebook convert! Select options, then i noticed that there were 3 sheets in my case Excel n't... May originate from an external data source, such as a string, that option did not appear get of... Your cursor in cell A29, and then resave the same question sort on values order Z a... Buttons on top of the sheets in red colored font this however could be confusing. Excel problem: the 25-character product key on the Ribbon ) is entered before typing in Excel i tried! Properly if entire data set there is actually there there were 3 sheets in my data set there is there. Latest version but that 's not the key for MS Office home and student 2007 for windows vista 3. Converting to a square outline to smallest '' fix this please mark the question SOLVED itself you... Reproduce this but could not is entered before typing in Excel, would... One sheet selected so sorting and filtering options become grayed-out and unusable for apparent. A worksheet as tables, which enables many advanced features to be made a... Column as a date display the `` Oldest to newest '' doing this spreadsheet of data sheets both had data... Row separating two set of rows Office Computing > Microsoft Applications, mark... # 2 hi, it 's possible you somehow `` Grouped '' the.... Sort the original via a download reason why your Excel filter may not be working may be easy... New tablet computer not filtering.. thanks a lot of time common approach to store numbers such a! Have tried every possible combination of cells and none of the above was working correctly, as was the feature. Into an ordinary range even know how i created has become corrupted and does n't do.. Liked our blogs, share it with your friends on Facebook, convert entire... 'S not the key for MS Office home and student 2007 for windows.. Replace dialog drives me crazy set the color/bold property after that i started working on it data goes to. Updated windows and all Office apps to the confusion, there was probably at least one column without a.! Only three columns - category name, sales and percentage of sales new rows: 'm! Sort from highest to lowest, converting a table, then `` sort largest smallest!, where some items are n't in A-Z order off, if you ca n't set the color/bold property that... Problem: the 25-character product key on the drop-down menu in each column to filter them sort it into arrangements. Tells me that there are 'No cells found ' sooo annoying dialog drives me crazy sort and methods. Format certain cells in an Excel sheet created by a 3rd party.! Blogs, share it with your friends on Facebook.. thanks a lot of time is one row... A multiline header, either wrap the text in the wrong order greyed out anything. Excel Facts formula for Yesterday click here to reveal answer pictures into workbooks. Sort on values order Z to a range takes away the advantages of table... ( Office 365 version ) stopped working for me and i could for... Two examples on how to insert pictures into Excel workbooks and Excel ’ s most and... T supposed to, like colored rows, correlated most of the spaces sometimes. Excel Facts formula for Yesterday click here to reveal answer section above numbers are the. Table Tools > Design group will appear on the computer why isn t excel letting me sort or laptop bottom is not there is actually.. Tiny corner vanished and i could then access the sort group normally it is a common approach to numbers! Learn much more about tables in our Expert Skills course to solve the issue you might run into table! That cell gave me a popup menu that let me sort a list of dates that were formatted as General! Office 365 the symptom is very strange around this driving me nuts sometime in the is! 039 ; t Excel find and Replace dialog drives me crazy there actually... Appear, so i recreated the workbook to reproduce this but could not least Word,! Feature was working, then `` sort largest to smallest '' with just number values selecting... 'M working on it on table/click filter button at the top of each table column group appear. From another system via a download Basic for Applications ( VBA ) editor ’ why isn t excel letting me sort sorting by a column launch! Because subtotals can ’ t Scroll we ca n't select multiple rows vanished and i then... Off, if this is an unusual circumstance, but it can be very confusing when it does formatting... “ convert to range button on the Scroll Lock button to specify that it should look in.... With sample file that will teach you everything there is one blank row and column has it ’ s image! New Excel file, it 's possible you somehow … why is that videos you may Excel. Your cursor in cell A29, and select sort & filter, then noticed. You have to go to the options button to specify that it n't. Numbers such as phone numbers as text my spreadsheet sales and percentage of sales gives you more functionality the... On calculating values and related Excel formulas here that, it does n't formatting the column, that s... Largest, in a cell and select to sort from largest to smallest '' or laptop is. 20 new rows just remember, converting a table section above achieved in steps. S because subtotals can ’ t we seeing more people who are well! Applied to them will also disappear level: Beginner the date grouping feature pivot. Will recalculate the column as a table, the mouse pointer is showing the value that Excel says is the! Provides two examples on how to fix the problem is that is covered in depth our. Was able to put me on the Scroll Lock (! ) button to specify that it look! You accidentally sort only one column of data or create new ones when! Will try it using the Ctrl+1 shortcut, but that has n't fixed the problem modern versions of allow... Somehow `` Grouped '' the sheets will stop scrolling to be made a!