Free Kindle via John Walkenback? →
This tale is making the rounds and the prediction is almost here.
Zoom That Spreadsheet [Windows]
This post reminded me that you can zoom in and out with your mouse on an Excel spreadsheet: just hold the Control key down while you roll the center scroll wheel. Doesn’t work for Excel on a Mac because the everything zooms, not just Excel.
Problems with Left to Right Sort in Excel →
A reader pointed out column widths are a problem when sorting from left to right in Excel. I checked it out and found even more stuff to worry about that I’ll share tomorrow. Beware the Left to Right Sort in Excel.
Capture Screen Shot of Drop-Down List in Excel
Sometimes I need to capture a screen shot of Excel when viewing a drop-down list, which is hard because once you touch another key the drop-down list disappears. So I capture a picture of the entire screen when the drop-down is visible, then use that image to capture my rectangular picture. In Windows I use the PrtScn key to capture the entire screen to the Clipboard, then open Paint and use...
TIME Limitation 32767
The TIME function has three arguments - Hour, Minute, Second. Each argument takes values from 0 to 32767. The Hours argument takes any number greater than 23 and divides by 24, then the remainder is treated as the hour value. The Minute argument takes any number greater than 59 and converts to hours and minutes. The Seconds argument takes any number greater than 59 and converts to hour, minutes,...
If a spreadsheet was created with Excel on a Windows machine, every time I open that spreadsheet with Excel on a Mac, the first thing I do is change the zoom to 125% so it looks normal.
Toggle Absolute and Relative in Excel for Mac
In Excel for Mac, toggling between Absolute, Relative, and Mixed cell references is not done with the F4 key like you would in Windows. Toggle a cell reference by using the keyboard shortcut COMMAND+T. Remember you have to be editing a cell for this to work. Either click inside the formula bar or use the keyboard shortcut CONTROL+U to edit a cell. Then you can use COMMAND+T to start toggling.
Unassigned Keyboard Shortcuts in Excel 2010
The CTRL combinations CTRL+E, CTRL+J, CTRL+M, AND CTRL+ Q are currently unassigned shortcuts in Excel 2010.
Paste Special Shortcut in Excel
Live and learn. Using the CTRL+ALT+V keyboard shortcut brings up the Paste Special Dialog box in Excel. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Won’t work if you’ve setup hotkeys in Evernote to paste clipboard with that exact keyboard combination (like me). In Excel for Mac CONTROL+SHIFT+V will paste as...
Crashing the Mac with Excel 2011
Here’s what I think happened: I opened Excel 2011, used the Help feature for something then minimized the Help window to the Dock so I could do something in the spreadsheet. After doodling around with a couple other programs I closed Excel and the Mac started to freeze up. I used Cmd+Option+Esc to Force Quit Excel, which seemed to work, but then I noticed the Help window was still in the...
Excel Time and Date Articles →
I consolidated my posts for Time and Date on a single page on my website for easy access. It seems a popular topic for Excel users.
My Top 5 Quick Access Toolbar Commands
I was recently looking at Commands Not in the Ribbon (Excel 2010 and 2007) and found a couple of new commands that are handy when added to the Quick Access Toolbar. Here’s my top five favorite commands on the Quick Access Toolbar. Paste Values Repeat Freeze Sheet Panes Switch Windows Wrap Text