Channel: MrExcel.com

Category: Howto & Style

Tags: excelexcel tutorialmrexcelvideo 2349 followupexcel tables and merged cellsismael romero tipsexcel table unmerges cellsusing center across selection in excelmicrosoft excelbill jelenexcel tables use custom lists when adding new columnsexcelforo tips

Description: Uncle S is trying to have a formula copy to new rows. So a table seems like a great way. But he also has merged cells and the table unmerges those. In this video, two surprising Table tricks: First, a table can contain Center Across Selection, which is better than Merging Cells in Excel. Second, a surprising discovery from the Excelforo channel about new headings in a table. Table of Contents (0:00) Auto-copying formulas to new rows in Excel (2:31) Can a table have a merged cell (4:00) New table columns using custom lists in Excel