How-To Geek on MSN

The hidden costs of whole-column references in Excel: Learn 3 alternatives to optimize your workbook's performance

Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...
AOL

How to split cells into columns in Microsoft Excel using the 'Text to Columns' feature

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...
JournalofAccountancy

Using 3 Excel View tools to manage large spreadsheets

Q. I work with large spreadsheets. These spreadsheets have hundreds or even thousands of rows and often 10 or more columns. It’s so much to process that I become confused and make mistakes. Does Excel ...
How-To Geek on MSN

The real reasons Excel has 1,048,576 rows and 16,384 columns

Excel's grid feels like an endless canvas until you hit the boundaries of row 1,048,576 or column XFD. These limits aren't ...