I recently read a good blog post over at Contextures about selecting the actual used range on an Excel sheet, both manually and with VBA. However, using Excel on a Mac makes you keenly aware that …
Settings and Shortcuts for Excel 2003
I recently found myself with a new, loaner laptop and a brand new copy of Excel 2003 as my default spreadsheet program. This was fine until I realized there were a number of things "missing." Like …
Continue Reading about Settings and Shortcuts for Excel 2003 →
That Damn Delete Key in Excel for Mac
I have no earthy idea why it took me so long to figure out how to delete the contents of a cell or range in Excel for Mac. Ever since I bought my MacBook Pro I've known the Delete key on a Mac isn't …
Continue Reading about That Damn Delete Key in Excel for Mac →
Regional Date Formats in Excel
I recently returned from two weeks in Ireland where I installed a couple of Excel reporting systems and came across the dreaded regional date settings. My computer is set for the US region, whereas …
Spreadsheet Size in Excel for Windows
I've been thinking about converting my older XLS files to the newer XLSX format, but ran into a quirk that stopped me. Maybe I'm just too impatient. Here's my story. A Few Facts First Excel versions …
Continue Reading about Spreadsheet Size in Excel for Windows →
Spreadsheet Size in Excel for Mac
Most people think an Excel workbook with an XLS file extension has only 65,636 rows and 256 columns in the worksheet. They would be wrong. Of course, if you don't use a Mac there's no way for you to …