Excel For Mac Borders Tool Bar
In Excel, borders are lines added to the edges of a cell or group of cells. The line styles that can be used for borders include single, double, and broken lines. The thickness of the lines can vary, as well as the color.
When it comes to Excel, appearances count. Get simple, powerful tips for making spreadsheet information more readable and understandable in Excel for Mac 2016. On the Border tab, under Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. Tip: To apply your new cell style, select the cells that you want to change, and then on the Home tab, under Format, click the style. Change the Ribbon in Mac Excel 2016 - Ron de Bruin I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft.
The information in this article applies to Excel versions 2019, 2016, 2013, 2010, and Excel for Mac.
About Borders in Excel Worksheets
Borders are formatting features used to improve the appearance of your worksheet. Borders make it easier to find and read specific data. Borders also draw attention to important data, such as the results of formulas.
Add Borders Using a Keyboard Shortcut
If you prefer to work with your keyboard, use a keyboard shortcut to add a border to the outside edges of one or more selected cells. This shortcut uses the default line color and thickness. The key combination to add a border is:
To add a border to a range of cells within an Excel worksheet:
Highlight the desired range of cells in the worksheet.
Press and hold the Ctrl and the Shift keys.
Press the & key without releasing the Ctrland Shiftkeys to surround the selected cells by a black border.
Add Borders in Excel Using Ribbon Options
The Borders option is located under the Home tab and can be used to add custom borders to cells in your worksheet.
To add a custom border:
Highlight the desired range of cells in the worksheet.
Select Home.
Select the Bordersdown arrow to open a drop-down list of border options.
Choose a border style. The chosen border appears around the selected cells.
Excel Toolbar Names
Choose a Variety of Border Options
When you're ready to add and format lines and borders in an Excel worksheet, you have several options:
- Add borders to one or all sides of a cell or block of cells.
- Choose a line thickness.
- Select from a variety of line styles.
- Apply a color to a border.
- Draw borders around irregularly shaped blocks of data with Excel's Draw Border feature.
Draw Border Lines Quickly with the Draw Border Feature
The Draw Borderfeature is located at the bottom of the Borders drop-down menu. One advantage of using Draw Border is that it is not necessary to select cells first. Instead, once the Draw Border option is selected, borders can be added directly to a worksheet.
Apple Toolbar For Mac
Draw Border also contains options for changing the line color and line style. This makes it easy to vary the appearance of borders used to highlight important blocks of data. The line style options allow you to create borders with:
- Lines of varying thickness
- Dotted and dashed lines
- Double lines
To draw border lines with the Draw Border feature:
Select Home.
Select the arrow next to Borders to open the drop-down. From this list, you can choose a different line color, change the line thickness, and draw border lines around cells.
Select Line Color and choose the color you want to use for the border.
Select Line Style and choose the line thickness you want to apply to the border.
Select Draw Border. The mouse pointer changes into a pencil.
Select the side of individual cells where you want to add a single border.
Drag with the pointer to add an outside border to a cell or group of cells.
Draw with the Border Grid
Another option on in the Borders list is Draw Border Grid. With Draw Border Grid, you can add outside and inside borders to one or more cells at the same time. Select Home > Borders > Draw Border Grid and drag the mouse pointer to create borders around the desired cells.
Stop Drawing Borders
To stop drawing borders, select Borders. Excel remembers the last type of border you use, so selecting Borders again re-enables that mode.
Ms Word For Mac Borders And Frames Christian
Erase a Border
Mac Top Toolbar
The Erase Border option, as the name suggests, makes it easy to remove borders from worksheet cells. Erase Border allows you to remove border lines individually by selecting them. You can remove multiple borders by dragging across those cells.