Applying Borders to Cells

September 08, 2013

1 comment

adding outline   Borders   Excel on Mac   Excel Resources   How Excel Skin Works   Mac Excel Shortcuts   mac shortcuts for excel   Mastering Excel   outline   side specific border  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Applying borders to specific sides of a cell can be a very easy way to spruce up an area of an Excel spreadsheet.  Borders help separate cells from each other, making it easier to differentiate one from another.  

Perhaps the greatest function of borders is that they show up when you print your Excel spreadsheet, something the grid lines don’t do by default. 

To get started select a cell, or a range of cells, which you want to apply a border to.  

The shortcuts below are side specific, meaning you can only apply a border to 1 side at a time.  

Bottom Border:

Top Border:

Left Border:

Right Border:

For this example I am applying a border to the bottom of the selected cells.

Next I am going to apply another border to the right of the cells to effectively block them off.

  

Let’s get even fancier - let’s extend both borders one cell and sum them all up:

If you ever want to remove a border you can execute the shortcut to apply a border to that specific side and it will be removed, or you can execute the Remove Borders shortcut to remove any border touching the cell.  

The Remove Borders shortcut is:

And there you have it, the simplicity, and complexity, of borders in Microsoft Excel for Mac.  

XXXXX

1 Response

Caoline
Caoline

March 19, 2014

nice blog, your description please me well. I always wanted to know how to apply borders to excel cells or cell ranges, thx. Here is a workshop with a video http://www.excel-aid.com/excel-borders-drawing-borders-around-cells-and-cell-ranges.html

Leave a comment

Comments will be approved before showing up.