Undoing inserting a new row with a copied range with merged cells is now faster because we optimized handing of merged cells during an undo operation.It now combines them more efficiently into one undo record with changed priorities for all in it. Undoing pasted cells with conditional formatting was slow because a paste operation was inefficient in generating an undo record for every cell with conditional formatting and with its own changed priority.Copying the entire column in a sheet and selecting the clipboard is faster now because we optimized our large memory allocations with a more efficient data structure.We create an index on-demand when you first search of a range of cells and then reuse it in subsequent lookups from the same range, until data changes in the lookup range. For details refer to our updated Excel Performance and limit improvements whitepaper.Īlso, we have improved the speed of many use cases involving operations like copy/paste, undo, conditional formatting, cell editing, cell selection, scrolling, filtering, file open, and programmability, such as: We made them faster by more efficiently finding the item you are looking up. If you use them with exact match to find items in a table or range in Excel, and see it noticeably take time in seconds or minutes or more, chances are you'll now see very noticeable improvement in the speed at which you see results. Lookup functions VLOOKUP, HLOOKUP, and MATCH are one of the most used functions in Excel.