Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

ExcelTable is a pipelined table interface to read Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods), and flat files (delimited or positional) as if they were external tables.

Scrolling through long worksheets can be sometimes exhausting. We explain how to Freeze & Split Panes in Excel in order to manage theme effeciently.

You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce other content restrictions.

To fix an Excel spreadsheet not filtering correctly, ungroup its sheets, apply the filter to its entire spreadsheet column, and unmerge cells.

If Excel is not printing your files, try changing the file type, disabling the reliability options and switching your default printer.

If you want to create multiple worksheets in multiple Excel workbooks, you can set the default number of worksheets when you open Excel.

Workplace Data analysis The Excel Files: The secret lives of spreadsheet superfans The unlikeliest hobby? People are using spreadsheets for fun, and winning world championships along the way.

Forget slam dunks, penalty shootouts or gold medals. The most nerve-racking competition you’ve never heard of involves cells, formulas and pivot tables.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.