5 ms·
Many things that Numbers seems to me to be better than Excel from a formatting perspective: * Freeze header rows & columns. * Naming header rows & columns. *
by eigen 5y ago
Many things that Numbers seems to me to be better than Excel from a formatting perspective:
* Freeze header rows & columns.
* Naming header rows & columns.
* Graphs that don't overlap the sheet.
Things that I find Excel does better than Numbers from a data perspective:
* Data validation
* Large tables
* Formula Error checking
- sp332 5y agoYou can freeze header rows in Excel. This happens automatically if you use Insert -> Table. That also gets you the ability to name columns.
- eigen 5y agogood to learn. I've only ever seen people do panes in a very poor imitation.
- matheusmoreira 5y agoExcel tables are so amazing. They solve so many problems.
- einpoklum 5y ago"Excel" is just one specific spreadsheet application out of several. But anyway... * You can freeze header rows and columns in Excel. * You can place charts outside the sheet with data. * I'm not even 100% sure you can't name columns, but let's say you can't. So, Excel has 2 out of its 3 "missing features". Just saying.
- 1980phipsi 5y agoExcel has been able to name columns for years.
- kevin_thibedeau 5y agoThey've always done a horrible job of hiding the dialog for managing named ranges. Easy to create them but knowing where they are is a PITA.
- woleium 5y agoyou mean the enormous drop-down on the left at the top? Where it shows the current cell, and you can type to replace the value with a name?
- kevin_thibedeau 5y agoThere's another dialog to modify, rename, and delete ranges.
- deleted 5y ago[deleted]
- aidos 5y agoExporting all sheets as individual csvs in one go… Recently I’ve just been using numbers because it’s there on the odd occasions I need to access an xslx file and, while everything is a little different, it’s just better.