Tips

Redo and Repeat Commands in Excel [Updated]

I always thought the F4 key was used to Repeat the last command, and the keyboard shortcut Ctrl+Y was used to activate the Redo command. I don’t use Redo very much, but the keyboard shortcut Ctrl+Z for the Undo command is one of my favorites. Toolbar icons for Undo and Redo command are common, yet …

Read more

Fixing the F4 Button in Excel for Mac

The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it. Default Excel F4 Keyboard Assignment in Excel for Mac There are four …

Read more

What Version of Excel am I Using?

If you’re curious about the version of Excel you’re using and don’t know how to go about it, you’ve come to the right place. It could be as simple as selecting the Help Menu and clicking About Microsoft Office Excel, but then again, maybe not. The five options below will help you sort things out. …

Read more

Use Function Keys Normally in Excel 2011

Since I’m relatively new to the world of Mac but an old hand with Windows, making an effort to discover Excel 2011 for Mac comes with some adjustments. Using the Function keys is one such irritation adjustment. You see, using Excel on a Windows machine allows you to use the function keys, like F1, F2, …

Read more

Worksheet Navigation in Excel

The other day I found myself switching frequently between three worksheets in an Excel workbook. Having to grab the mouse, select another worksheet tab, then switch my hand back to the keyboard became annoying, so I looked up the keyboard shortcuts. Excel for Windows: Ctrl+PgDn — takes you to the next worksheet Ctrl+PgUp — takes …

Read more

Calculate the Xth Weekday of Any Month in Excel

I’ve a simple formula for calculating the Xth Weekday of ANY month. It takes four inputs: Year, Month, Week, and Day. And requires a couple of lookup tables for data validation, one with special formatting. The History It all started when my wife mentioned there were a couple of meetings she had to schedule at …

Read more

Indent Left and Right to Align Cell Contents

Formatting is second nature with Excel because ergonomically you want people to notice the information in your data and not spend time finding it, either because it doesn’t stand out, or it blurs together. Recently I came across a new wrinkle with the indentation of cell contents and thought to share it with you here. …

Read more

Switch Between Relative and Absolute References in Excel for Mac

I’m a longtime user of Excel for Windows, but recently a newbie with Excel 2008 for Mac where I found that out the Windows shortcut F4 doesn’t work to switch between relative and absolute references when editing a formula. Thankfully Excel 2011 has a Switch Reference toolbar icon on the Formulas Ribbon, as shown below. …

Read more