Alt X C C B on Mac: Delete Blank Columns in Excel

To run Delete Blank Columns with Alt X C C B in Excel on a Mac, install LightningXL, tap Option, then type X, C, C, B. The same keys as Windows, with the same result.

Step by step

1. Install LightningXL

   Download LightningXL, then follow the instructions. Setup takes about two minutes.

2. Select what to act on

   Click a cell, or select the range the command should apply to.

3. Tap Option, then type X C C B

   Tap ⌥ on its own to show the key tips, then X for LightningXL, C for Cells, C for Columns, B for Delete Blank Columns.

What Alt X C C B does

Delete Blank Columns sits under LightningXL › Cells › Columns on the Excel ribbon. On Windows, Alt X C C B runs it from the keyboard. Excel for Mac has the same ribbon but no Alt key, so without LightningXL you click through LightningXL › Cells › Columns › Delete Blank Columns instead.

Related shortcuts

The rest of the Columns menu in Excel:

• ⌥XCCH Column Width Cycle
• ⌥XCCF AutoFit Columns
• ⌥XCCI Insert Columns
• ⌥XCCD Delete Columns
• ⌥XCCX Hide Columns
• ⌥XCCS Unhide Columns
• ⌥XCCG Group Columns
• ⌥XCCU Ungroup Columns