Iâm trying to create an attractive spreadsheet to share with my team and canât figure out how to add borders around individual cells in Microsoft Excel. Can you walk me through the process, please?
With all the fancy 3D virtual world systems grabbing headlines, itâs reassuring to find someone whoâs interested in information about one of the original applications of personal computers: spreadsheets. Indeed, itâs a program called Lotus-1-2-3 that really helped establish the value of computers for non-corporate users back in the darn of the PC era, with people marveling how they could balance their checking account on the computer. Definitely back in the day! For the vast majority of people back in that era, this was pre-Internet too, so they were using their hardwired phones stuck in acoustic gadgets to âtalkâ with another computer as a way to go online. The pinnacle of that era was the weekly AOL discs in the mail: logging in to America Online was the height of wired computing!
All these decades later and it turns out that spreadsheets are still darn useful for financial projections or even just to offer up the foundations of a visual presentation of numeric data. Want to âwhat ifâ your mortgage payments if the prime interest rate goes up or down a few percentage points? Easily done. Balance your checkbook? Yes, you can still do that.
Shortcuts: Demo Spreadsheet | Add a Fill | Cell Font Styles | DIY Cell Formatting
One significant change in all this time is that formatting and layout options have become far more sophisticated. This also means that theyâve gotten more complicated, so youâre not the first person to be stymied by what seems like a simple formatting task in Microsoft Excel. Iâll be using the Mac version of Excel for this tutorial, but the functionality should be identical to the Windows version, even if the buttons might look slightly differentâŠ
A SIMPLE DEMO EXCEL SPREADSHEET
I have a demo spreadsheet on my computer for just this sort of task [download a copy]. Itâs pretty rudimentary but do notice that the calculations are based on information spread across the sheet: âTransaction Feeâ is calculated by Gross * Transaction Fee Percentage:
Iâve already done some basic formatting by adding background color fills to the spreadsheet, but letâs focus our attention on the âTotalâ cell (D7) and the calculated value (E7). To start, click on the cells to choose them, then choose âFontâ from the ribbon bar along the top:
Here itâs showing me quite a few formatting options, including font, size, and more. To make the word âTotalâ and the calculated value both appear in bold, a click on the âBâ does the job.
ADD A FILL COLOR TO INDIVIDUAL CELLS
But letâs add a background fill too. Thatâs done by clicking on the paint bucket with the yellow swatch below it. A color grid appears:
You can choose a theme color (did you know Excel supported âthemesâ to have your spreadsheets look more consistent? Learn more here: Excel Themes), or you can choose one of the standard colors. Iâll choose the bright yellow from that second palette.
But the cool kids actually choose something different from that Ribbon barâŠ
MICROSOFT EXCEL CELL FONT STYLES
In addition to the specific âFontâ button, there are a couple of really useful shortcut links: Conditional formatting, Format as Table, and Cell Styles. Choose âCell Stylesâ and lots of formats are shown:
I always like the âGood, Bad and Neutralâ cell formats, but there are a lot of options here that include borders, double borders, underlines, and much more. You can also choose a background fill by intensity. For example, Iâm going to choose â20% â Accent 4â light yellow.
This is certainly the fastest way to get the results you want. But what if the combinations arenât quite right or you want to apply more complex formatting, including specifying the type of data in the cell to ensure itâs shown correctly (like currency)?
DO IT YOURSELF CELL FORMATING IN EXCEL
The answer if you want to have maximal control over the formatting of a cell or group of cells youâve selected is yet another button on the toolbar: âCellsâ. Click on it and there are three options shown:
From here, choose âFormatâ and a submenu appears with quite a few choices and options:
From a Mac user interface perspective, itâs interesting to have shortcut images appear on the menu; a very atypical user interface element. I like it, personally!
If what you want is on this menu, thatâs great. If not, choose âFormat CellsâŠâ and youâll be whisked into a completely different and quite complicated formatting window:
Notice along the top the categories: Number, Alignment, Font, Border, Fill, and Protection. Above you can see the âBorderâ option, and it really does give you oodles of options to set up the border exactly as youâd prefer.
Iâm going to choose âOutlineâ and pick a heavier line from the style list on the left. The preview changes:
A click on âOKâ and itâs appliedâŠ
A lot of different ways to format those two cells, but as you can see, thereâs also a remarkable amount of power and flexibility hidden in Microsoft Excel. Ya just gotta explore and experiment. In fact, you can download my test spreadsheet if you want to experiment with it too. A good thing to do while stuck in a boring Zoom meeting. đ
Pro Tip: Iâve been using and writing about Microsoftâs Office Suite for many years. Please check out my Outlook help library for plenty of useful tutorials, as well as my additional Microsoft Office 365 help pages! Thanks.
Actually, Lotus 1-2-3 was a set of (charting and database) additions to an earlier spreadsheet only program called VisiCalc. It ran on early IBM PCs and pre IBM machines like the TRS-80 (2+ million sold) and the Apple IIs.
The direct spreadsheet to graph feature instantly made Lotus 1-2-3 the industry standard.
When Redmond figured out how to get their spreadsheets to automatically update without hitting a âRecalcâ button, Excel became supreme.