Borders

You can modify the style of individual cell borders, without affecting other cell formatting, using convenient border style cycles. Repeat the keystrokes below to cycle a particular border through several line styles selected in the Excel > Format > Other section of the Settings dialog. Although you can add as many line styles to the border style cycle as you like, we recommend including no more than four such styles, with "None" as the last style in the cycle. The same styles apply to the Border Top, Border Bottom, Border Left, Border Right, and Border Outline cycles.

The border color applied when using the following border style cycles is the default border color, which is black by default, and can be customized in the Excel > Format > Colors section of the Settings dialog.

Top Border Cycle

Apply a top border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses and remove the border. When multiple cells are selected, only the top border of the entire selection is modified.

Ctrl
Alt
Shift

Bottom Border Cycle

Apply a bottom border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses and remove the border. When multiple cells are selected, only the top border of the entire selection is modified.

Ctrl
Alt
Shift

Left Border Cycle

Apply a left border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses and remove the border. When multiple cells are selected, only the top border of the entire selection is modified.

Ctrl
Alt
Shift

Right Border Cycle

Apply a right border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses and remove the border. When multiple cells are selected, only the top border of the entire selection is modified.

Ctrl
Alt
Shift

Outside Border Cycle

Apply an outline border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses or to remove the border. When multiple cells are selected, only the outside border of the entire selection is modified. Our default Ctrl+Shift+& shortcut keystroke overrides Excel's native outline border shortcut to improve upon native functionality and avoid duplicative shortcuts.

Ctrl
Shift
7

Inside Border Cycle

Apply an inside border with the default border color to selected cells. Repeat to cycle through customizable line styles and thicknesses or to remove the border.

Ctrl
Alt
Shift
7

No Border

Remove all borders from selected cells. This is a native Excel shortcut and is only mentioned here for completeness.

Ctrl
Shift
_

This documentation refers to the latest Macabacus version. Some features and descriptions of these features may not apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.