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

1 Pasting Ctrl/Cmd + V will paste only table with two or more columns 2 Hotkey Crtl/Cmd + Alt + V will paste table with one column as well reassign the Hotkey from settings if needed Download the ...

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

ExStruct reads Excel workbooks and outputs structured data (cells, table candidates, shapes, charts, smartart, merged cell ranges, print areas/views, auto page-break areas, hyperlinks) as JSON by ...