How to Sort on Excel: Complete Guide to Sorting Data, Multiple Columns, and Custom Lists
๐ Learn how to sort on Excel with step-by-step instructions for single columns, multiple levels, custom lists, and advanced sorting techniques.

Learning how to sort on Excel is one of the most foundational skills for anyone working with spreadsheets, whether you are organizing a household budget, analyzing thousands of sales records, or preparing a quarterly report for stakeholders. Sorting transforms a chaotic block of data into something meaningful, allowing patterns to emerge and outliers to surface within seconds. Excel offers multiple sorting methods including single-column sorts, multi-level hierarchies, custom lists, and formula-based dynamic sorting through functions like SORT and SORTBY. Practice with the free Excel practice test on PracticeTestGeeks (16 questions with answer explanations).
At its core, sorting in Excel means rearranging rows of data based on the values in one or more columns. You can sort alphabetically from A to Z or Z to A, numerically from smallest to largest or largest to smallest, chronologically by dates and times, or by cell color, font color, or conditional formatting icons. Each method serves a distinct analytical purpose and choosing the right one depends on the structure of your dataset and the question you are trying to answer.
The most common mistake beginners make when sorting in Excel is selecting only one column before clicking the sort button, which scrambles the relationship between that column and the rest of the data. Excel will warn you with an expand-selection dialog, but understanding why this matters prevents data corruption disasters. Always ensure your data has consistent headers, no merged cells within the sort range, and no completely blank rows separating sections that should be sorted together.
Beyond basic ascending and descending sorts, Excel power users rely on multi-level sorting to handle complex datasets. For example, you might sort a sales spreadsheet first by region, then by salesperson within each region, and finally by deal size within each salesperson group. This three-tier hierarchy reveals performance patterns that single-column sorting could never expose. The Sort dialog box accessible from the Data tab is where this multi-level magic happens, and it accepts up to 64 sort levels.
Excel also handles specialized sorting scenarios that most users never discover. Custom lists let you sort by non-alphabetical sequences like Monday through Sunday, January through December, or even custom priority labels like High, Medium, Low. Sorting by color is invaluable for teams using conditional formatting to flag data, and sorting left to right rearranges columns rather than rows for unusual datasets oriented horizontally. Each of these techniques adds another tool to your analytical toolkit.
Microsoft 365 and Excel 2021 introduced dynamic array functions including SORT and SORTBY, which return sorted results to a spill range without modifying the original data. This non-destructive approach is revolutionary for dashboards and reports because the sorted output updates automatically whenever the source changes. Combined with FILTER, UNIQUE, and other dynamic arrays, these formulas allow you to build interactive views without macros or pivot tables, making Excel feel almost like a database.
Throughout this guide we will walk through every sorting method Excel offers, from the simplest A-Z button click to advanced SORTBY formulas that handle multiple criteria with custom sequences. You will learn keyboard shortcuts that save hours per week, common pitfalls that destroy data integrity, and best practices used by professional analysts. By the end, sorting in Excel will feel as natural as breathing, and you will know exactly which technique to deploy for any situation.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Excel Sorting by the Numbers

Quick Sort Methods in Excel
Click Any Cell in Column
Open the Data Tab
Choose Sort Direction
Review the Result
Save or Undo
Single column sorting is the foundation of every Excel data task, and mastering it prevents 90% of the errors beginners make when learning how to sort on Excel. The simplest method is clicking any cell within your target column and pressing the A-Z or Z-A button on the Data tab. Excel intelligently expands the selection to include all contiguous rows and columns, preserving the row relationships so that customer names stay with their order numbers, dates stay with their transactions, and so on.
The critical word in that previous sentence is contiguous. Excel determines the sort range by walking outward from your selected cell until it hits a completely blank row or column. If your data has empty rows separating sections, Excel will only sort the section containing your active cell. This is why analysts always recommend keeping data in a single unbroken block, with no blank rows for visual separation. If you need visual breaks, use cell borders or background colors instead of empty rows.
Headers deserve special attention when sorting. Excel uses heuristics to detect whether your first row contains labels rather than data, examining things like font formatting, data type differences between row one and the rest, and the presence of text in a numeric column. When Excel guesses correctly, the header row stays anchored at the top while everything below shuffles. When Excel guesses wrong, you can override the decision in the Sort dialog by checking or unchecking the My data has headers checkbox.
Right-clicking offers another path to sorting that many users overlook. Right-click any cell, hover over Sort, and you will see options including Sort A to Z, Sort Z to A, Put Selected Cell Color on Top, Put Selected Font Color on Top, and Put Selected Cell Icon on Top. These context-aware options are perfect for color-coded datasets where you have used conditional formatting to highlight specific values, and they save trips to the ribbon.
Keyboard shortcuts accelerate sorting dramatically once you commit them to memory. Alt+A+S+A triggers ascending sort, Alt+A+S+D triggers descending sort, and Alt+A+S+S opens the full Sort dialog for custom configurations. Power users who sort dozens of datasets per day shave hours off their week with these shortcuts. Combined with Ctrl+Shift+L to toggle filters, you can analyze data without ever lifting your hands from the keyboard.
One subtle behavior trips up many users: Excel sorts numbers stored as text differently than actual numbers. If a column contains values like 10, 2, 1, 20 but they are formatted as text, the sort will produce 1, 10, 2, 20 because text sorts character by character. To fix this, select the column, click the warning triangle that appears, and choose Convert to Number. Alternatively, use the VALUE function in a helper column to coerce text into numeric values before sorting.
Sorting dates requires similar vigilance. Dates that look correct visually may actually be stored as text strings, especially when imported from CSV files or pasted from web pages. A quick test is to apply a different date format from the Format Cells dialog. If the display changes, you have real dates. If it does not change, you have text masquerading as dates and need to convert them using DATEVALUE or Power Query before sorting will produce chronological order.

Microsoft Excel Practice Test Questions
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Multi-Level Sorts and Custom List Sorting in Excel
Multi-level sorting handles complex datasets by applying sort criteria in a hierarchy. Open the Sort dialog from the Data tab, click Add Level, and specify each sort field in priority order. Excel applies the first level globally, then sorts within those groups by the second level, and continues down through up to 64 levels. This is essential for analyzing data with natural groupings like region, department, then individual.
For example, sorting a sales database first by Region ascending, then by Salesperson ascending, then by Deal Size descending produces a report where each region is grouped alphabetically, salespeople within each region are also alphabetical, and each salesperson's largest deals appear first. This hierarchical view reveals patterns that single-column sorts cannot expose, making it invaluable for management reporting and territory analysis.
Should You Sort Data In-Place or Use SORT Formula?
- +SORT formula preserves original data integrity by spilling results to a new range
- +Dynamic formulas update automatically when source data changes
- +No risk of accidentally breaking row relationships during sort operations
- +Works seamlessly with FILTER, UNIQUE, and other dynamic array functions
- +Allows building interactive dashboards without macros or pivot tables
- +Can be combined with SORTBY for multi-criteria sorts using helper columns
- +Output range can be referenced by other formulas for further analysis
- โSORT function requires Microsoft 365 or Excel 2021 or later versions
- โSpill range can collide with existing data causing #SPILL errors
- โCannot modify spilled output directly without breaking the formula
- โIn-place sorting is faster for one-time analysis of static datasets
- โSORT does not preserve cell formatting from the original range
- โLearning curve for users accustomed to traditional sort buttons
- โLarge datasets with SORT formulas can slow workbook recalculation noticeably
Pros and Cons at a Glance
| Pros | Cons |
|---|---|
| SORT formula preserves original data integrity by spilling results to a new range | Spill range can collide with existing data causing #SPILL errors |
| Dynamic formulas update automatically when source data changes | Cannot modify spilled output directly without breaking the formula |
| No risk of accidentally breaking row relationships during sort operations | In-place sorting is faster for one-time analysis of static datasets |
| Works seamlessly with FILTER, UNIQUE, and other dynamic array functions | SORT does not preserve cell formatting from the original range |
| Allows building interactive dashboards without macros or pivot tables | Learning curve for users accustomed to traditional sort buttons |
| Can be combined with SORTBY for multi-criteria sorts using helper columns | Large datasets with SORT formulas can slow workbook recalculation noticeably |

Pre-Sort Data Preparation Checklist
- โRemove all completely blank rows within your data range
- โVerify that headers are in a single row at the top with bold formatting
- โCheck that no cells in the sort range are merged horizontally or vertically
- โConfirm numbers are stored as numbers, not text, using the ISNUMBER function
- โEnsure dates display in a consistent format and are recognized as dates
- โSave a backup copy of the workbook before performing any destructive sort
- โConvert any formula results to values if you need a static sorted snapshot
- โVerify that filters from previous operations are cleared or intentionally applied
- โCheck for hidden rows or columns that may behave unexpectedly during sorts
- โConfirm that linked workbooks or external data sources are refreshed and current
Avoid the Right-Click Trap on Selected Ranges
The single biggest cause of data corruption from sorting is highlighting only one column and clicking Sort A to Z. Excel will pop up an Expand Selection dialog asking whether to expand to adjacent data, but tired users click Continue with Current Selection without reading. This scrambles the sorted column relative to all other columns. Always click a single cell in your target column and let Excel auto-detect the full range.
The SORT and SORTBY functions revolutionized how analysts approach sorting in Microsoft 365 and Excel 2021. Unlike traditional sort buttons that modify your data in place, these dynamic array functions return sorted results to a spill range while leaving the original data untouched. This non-destructive approach is significant for dashboards, reports, and any workbook where multiple views of the same underlying data are needed simultaneously without duplicating the source.
The basic syntax of SORT is straightforward: SORT(array, sort_index, sort_order, by_col). The array argument is your source range, sort_index specifies which column to sort by (defaulting to 1), sort_order accepts 1 for ascending or -1 for descending, and by_col toggles between sorting rows (FALSE, the default) or columns (TRUE). A simple example like SORT(A2:C100, 2, -1) sorts the range by column 2 in descending order without touching the original data.
SORTBY offers more flexibility by allowing you to sort one range based on values in entirely different ranges. The syntax SORTBY(array, by_array1, sort_order1, by_array2, sort_order2, ...) accepts up to 126 sort criteria pairs. This is invaluable when you want to sort a list of names by a hidden score column without displaying the scores, or when sorting requires calculations that you do not want cluttering the output. SORTBY enables sophisticated reports that previously required pivot tables or VBA.
Combining SORT with FILTER creates dynamic top-N reports that update automatically. The formula SORT(FILTER(A2:C100, B2:B100>1000), 3, -1) first filters rows where column B exceeds 1000, then sorts the result by column 3 descending. Wrap this in INDEX or use the spill range reference with a hash like E2# to extract the top 10 results elsewhere in your workbook. This pattern powers modern Excel dashboards without any manual refresh steps.
One powerful use case combines SORTBY with custom MATCH-based ordering. Suppose you have a priority list in column E like High, Medium, Low and a status column you want to sort by that priority. The formula SORTBY(A2:B100, MATCH(B2:B100, {"High";"Medium";"Low"}, 0)) returns the data sorted by priority rank rather than alphabetically. This technique replicates custom list sorting inside a formula, making it portable across workbooks without modifying Excel options.
Performance considerations matter when using dynamic sort formulas at scale. Each SORT or SORTBY formula triggers recalculation whenever any cell in its source range changes, which can slow workbooks with hundreds of such formulas referencing large ranges. For static reports where source data rarely changes, consider using Paste Special Values to convert sorted output to fixed values, freeing up calculation cycles for the formulas that genuinely need to recalculate frequently.
Compatibility is the main reason traditional sort buttons still dominate. SORT and SORTBY require Excel 2021, Microsoft 365, or Excel for the web. Workbooks containing these formulas display _xlfn.SORT errors when opened in older versions. For workbooks shared with users on legacy Excel, stick with the Data tab sort buttons or use Power Query, which produces compatible output. Always confirm your audience's Excel version before deploying dynamic array solutions.
Sorting is one of the few Excel operations that cannot be undone after closing the workbook. If you sort an unsorted dataset, save, close, and reopen, the original order is permanently lost unless you have a separate backup. Always create a copy or add an index column with sequential numbers before sorting so you can restore the original order with a reverse sort.
Troubleshooting sort errors is a critical skill because sorting bugs often appear silent until they have already corrupted data. The most common symptom is rows that appear out of order even after sorting, which usually indicates mixed data types in the sort column. Numbers stored as text sort lexicographically while real numbers sort numerically, producing sequences like 1, 10, 100, 2, 20 instead of the expected 1, 2, 10, 20, 100. Always run ISNUMBER on a sample of cells to verify data types.
Merged cells are the second most common source of sort failures. Excel cannot sort ranges containing merged cells of different sizes because the operation would create overlapping cells. The error message To do this, all the merged cells need to be the same size appears, blocking the sort entirely. The fix is to unmerge all cells in the range using Format Cells, Alignment, Merge cells checkbox, or by clicking the Merge and Center button on the Home tab while the merged cells are selected.
Hidden rows behave unexpectedly during sorts because Excel still includes them in the sort operation, but their hidden status is reassigned to whichever rows now occupy those positions. This means hidden rows you carefully prepared can suddenly become visible while other rows disappear from view. If you need to preserve which specific rows are hidden, use filtering instead of hiding, since filtered rows maintain their hidden status correctly through sort operations.
Frozen panes do not affect sort behavior but can create visual confusion. After sorting, the frozen header row stays in place while the data rows below shuffle. This is the expected behavior, but users sometimes assume the sort failed because they expected to see different data near the frozen pane boundary. Always scroll through the entire sorted range to verify the sort succeeded rather than judging from the visible portion alone.
Formulas referencing sorted ranges can produce unexpected results because relative references update when cells move during a sort. If cell D5 contains the formula equals B5 plus C5 and the sort moves row 5 to row 12, the formula moves with it and now reads equals B12 plus C12, which is usually what you want. However, formulas referencing fixed positions or other sheets may break. Use Trace Dependents from the Formulas tab to identify formulas that might be affected before sorting.
Pivot tables refresh independently of underlying data sorts, so sorting the source range has no effect on existing pivot tables until they are refreshed. To force a refresh, right-click the pivot table and choose Refresh, or use Alt+F5. If you want pivot tables to maintain their own sort order independent of source data, use the Sort options in the pivot table field settings rather than sorting the source data itself.
External data connections add another layer of complexity to sorting. When data is imported from databases, web queries, or other workbooks, sorting the local copy does not affect the source. However, the next refresh from the source will return data in its original order, undoing your sort. To make sorts persistent with refreshable data, use Power Query to apply the sort within the query itself, ensuring every refresh returns data in your preferred order automatically.
Practical tips for sorting efficiently in Excel come from years of hands-on experience analyzing real datasets. The first rule is to always add a sequential index column before performing any sort operation. A simple column with numbers 1 through N in the first column of your data acts as a permanent record of the original order. If anything goes wrong during sorting, you can restore the original sequence instantly by sorting this index column ascending, recovering hours of potential lost work.
Develop a habit of using Excel Tables, created with Ctrl+T, for any dataset you plan to sort regularly. Tables automatically expand to include new rows, maintain sort and filter controls in the header row, and provide structured references that make formulas more readable. When you sort a Table, Excel handles header row protection automatically and applies banded row formatting that updates correctly even as data shuffles. Tables also play nicely with PivotTables and dynamic array formulas.
For datasets that arrive in unpredictable formats, invest time in building a Power Query transformation that cleans and sorts the data on import. Power Query lets you specify multiple sort criteria, custom list orders, and conditional sorts that apply every time you refresh the query. This eliminates manual sorting steps and ensures consistency across team members working with the same data source. The initial setup pays dividends across hundreds of future refreshes.
Keyboard shortcut mastery dramatically increases sort efficiency for daily Excel users. Memorize Alt+A+S+A for ascending sort, Alt+A+S+D for descending sort, and Alt+A+S+S for the full Sort dialog. Combine these with Ctrl+Shift+L to toggle filters, Ctrl+T to create tables, and F4 to repeat the last action. Within a week of dedicated practice, these shortcuts become muscle memory and transform sorting from a series of mouse clicks into instant operations.
When sharing sorted reports with stakeholders, consider whether they need to interact with the data or just consume the analysis. For static reports, paste the sorted output as values to prevent accidental re-sorting that might change the conclusions presented. For interactive workbooks, use Tables with filter buttons and protected formulas so users can re-sort by different columns without breaking calculations. The right choice depends on your audience's Excel skill level and the report's purpose.
Custom list management deserves a recurring review in your Excel setup. Visit File, Options, Advanced, Edit Custom Lists periodically to add new sequences relevant to your work, such as fiscal quarters, project phases, or industry-specific priority labels. Once defined, these lists are available across all workbooks on your computer and dramatically speed up sorting of recurring data types. Export your custom lists when changing computers to maintain consistency across environments.
Finally, build a personal reference document or cheat sheet covering the sort techniques most relevant to your work. Include screenshots of dialog boxes, keyboard shortcut sequences, common formulas like SORT and SORTBY, and notes about pitfalls you have encountered. This document becomes invaluable for onboarding colleagues, refreshing your memory after vacation, and demonstrating your Excel expertise during job interviews or performance reviews. Sorting mastery is a competitive advantage in any data-driven role.
Sample Excel Practice Questions
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
You are tasked with cleaning and transforming data from multiple CSV files before loading it into a final report. The data requires filtering, removing columns, changing data types, and merging queries. Which of the following Excel features is best suited for these ETL (Extract, Transform, Load) tasks?
- A. Flash Fill
- B. Advanced Filter
- C. Power Query
- D. Data Validation
Answer: C. Power Query
Power Query (also known as Get & Transform Data) is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is specifically designed for data transformation and preparation tasks, making it ideal for the described ETL process.
A project manager has a table listing tasks, assigned team members, and departments. They need to sort the table first by 'Department' in alphabetical order (A to Z), and then within each department, sort by 'Task Priority' from 'High' to 'Low'. Which of the following is the correct method to apply this multi-level sort?
- A. Use the filter drop-down on the 'Task Priority' column to sort, then the drop-down on the 'Department' column to sort.
- B. On the 'Data' tab, open the 'Sort' dialog box, add a level, and set the primary and secondary sort criteria.
- C. Create two separate slicers, one for 'Department' and one for 'Task Priority'.
- D. Sort the 'Department' column A to Z, then separately sort the 'Task Priority' column Z to A.
Answer: B. On the 'Data' tab, open the 'Sort' dialog box, add a level, and set the primary and secondary sort criteria.
The 'Sort' dialog box, found on the 'Data' tab, is specifically designed for multi-level sorting. It allows the user to define a primary sort key ('Department') and then add subsequent levels ('Task Priority') to sort the data within the primary groups.
Which Power Query transformation converts multiple columns such as Jan, Feb, and Mar into two columns named Attribute and Value?
- A. Pivot Column
- B. Group By
- C. Unpivot Columns
- D. Split Column
Answer: C. Unpivot Columns
Unpivot turns wide crosstab data into a tall, normalized list.
Which Excel feature allows you to split a single column of data into multiple columns based on a delimiter?
- A. Flash Fill
- B. Text to Columns
- C. Power Query Split
- D. Data Separation
Answer: B. Text to Columns
Text to Columns (under the Data tab) splits cell content into separate columns using a delimiter like a comma or space.
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com โ Fees, retake fee ยท verified Nov 2026
- certiport.pearsonvue.com โ Renewal, score validity, score release, exam format ยท verified Nov 2026
- learn.microsoft.com โ Test delivery, time limit, eligibility ยท verified Nov 2026




