Beginner level information
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 really a Delete key. I mean, since my background is with …
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 the client’s computers were set for the UK region. When I mention regional settings on my computer, I’m talking about 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 97-2003 (Windows) have a file extension of XLS and the worksheet size is 65,536 rows and 256 columns. In …
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 discover this fact. When you open an Excel 97-2003 Workbook (*.xls) file in Excel 2007 or …
This is a Guest Post by Excel Everest. ExcelEverest.com | For whatever reason, most people remain unaware of these 5 ultra-simple and ultra-useful aspects of Excel. Many people use Excel on a daily, or at least a weekly basis. But many of these people also haven’t had or taken the time to dig into even …
Excel Tables are given default names (Table1, Table2, etc.) when they are created. Table names are similar to defined names, which makes them easy use in formulas or to select data. There are a couple of ways to select all the data in a Table by using the Table name. 1) select the Table name …
I’m want to start using Excel Tables when building my spreadsheets. But first it’s instructive for me to explain how I think about “unofficial” tables or data tables as I like to call them. How I Think About Tables A data table is just a range of data, or a region of data that Excel …
My first epiphany with Excel was realizing how powerful it could be if you put all your data into data tables. Over the years Excel began to incorporate data tables. First in Excel 2003 as “Lists” then as official “Tables” in Excel 2007. (I’m not sure about the evolution in Excel for Mac versions.) The …
I opened Excel 2007 today and realized there were 3 worksheets in a new workbook. That’s better than the 16 or so Excel had in times past, but more than one worksheet in a workbook is overkill, if you ask me. To change this travesty in Excel 2007, I’ll choose the Office Button > Excel …