Apply or remove cell borders

Exist several ways to apply or remove cell borders, you can choose anyone:

To apply cell borders:

1. On the Formatting toolbar ( View -> Toolbars -> Formatting ), click the arrow next to Borders , and then choose a border style from the palette:

List in Excel 2003

If you want to use another style of borders, choose the Draw Borders... button to open the Borders toolbar (another way to open this dialog box, choose View -> Toolbars -> Borders ):

Borders in Excel 2003

Click the arrow next to Line Style Line Style and then click the style that you want to use. Click Line Color Line Color and then click the color that you want to use.

Click the Draw Borders Draw Borders in Excel 2003 or Draw Border Grid Draw Border Grid in Excel 2003 on the palette.

2. Choose Format -> Cells... and click the Border tab in the Format Cells dialog box (or press Ctrl+1 ):

Format Cells in Excel 2003

Click the line style and color that you want, and then click one or more buttons to indicate the border placement.

Note : You also can use next shortcut keys:

Alt+P Apply or remove the top border.

Alt+B Apply or remove the bottom border.

Alt+L Apply or remove the left border.

Alt+R Apply or remove the right border.

Alt+H If cells in multiple rows are selected, apply or remove the horizontal divider.

Alt+V If cells in multiple columns are selected, apply or remove the vertical divider.

Alt+D Apply or remove the downward diagonal border.

Alt+U Apply or remove the upward diagonal border.

3. Choose Format Cells... from popup menu to open the Format Cells dialog box:

Cell popup in Excel 2003

Click the line style and color that you want, and then click one or more buttons to indicate the border placement.

To remove cell borders:

1. On the Formatting toolbar ( View -> Toolbars -> Formatting ), click the arrow next to Borders , and then choose the Draw Borders... button to open the Borders toolbar (another way to open this dialog box, choose View -> Toolbars -> Borders ):

Borders toolbar in Excel 2003

Click Erase Border Erase Border in Excel 2003 and then do one of the following:

  • To remove a single border, click that border with the eraser tool.
  • To remove more than one border, drag the eraser tool across the borders that you want to remove.

To stop erasing borders, click Erase Border on the Borders toolbar again, so that the eraser tool is no longer displayed.

2. Choose Format -> Cells... and click the Border tab in the Format Cells dialog box:

Format Cells in Excel 2003

Click one or more buttons to unselect the border placement.

Note : You also can use next shortcut keys:

Ctrl+Shift+_ Border lines off

Ctrl+Shift+& Border lines on

Transactions Tracking

  • Income
  • Expense
  • Transfer
  • Buy,Sell and Dividend
Track your finances at https://moneybench.net Try Now

Quick Overview

  • Income and Expenses
  • Assets and Liabilities
  • Investments
  • Net worth
Track your finances at https://moneybench.net Try Now

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.