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.
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 Ctrl+V to paste the picture into the Paint program. I then use the Snipping Tool to grab a rectangular image from the screen shot in Paint.
On a Mac I use CMD+Shift+3 to copy a screen shot to the desktop, select the Screen Shot image, press the space bar to view, the click the double arrows to show full screen. I then use CMD+Shift+4 to capture a rectangular image of my choice to the desktop. (show above)
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, and seconds.
So the max for each argument for the TIME function looks like this.
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.
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 values.
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 dock and the Mac was non-responsive.
Moral of the story, close any Help windows before closing Excel.
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.