Excel Tip of the Day
Add and remove cell borders easier in Excel 2002
Cell borders do a lot to improve a worksheet's readability, but prior to Excel 2002 they were often a pain to set up and maintain. Although the Borders palette supplies you with several pre-defined border formats, customizing a border in Excel 2000 and earlier often requires a trip to the cumbersome Borders sheet found in the Format Cells dialog box. Because you frequently need to perform minor fixes to your borders when you move or paste cells, such trips to the Format Cells dialog box aren't uncommon.
Excel 2002 improves upon the process with the addition of the Draw Borders feature. To use this feature, open the Borders palette and choose the Draw Borders button. Doing so displays the Borders toolbar and automatically turns your mouse pointer into a pencil icon. As the feature's name suggests, you can add borders by simply clicking and drawing along the edges of cells you want enclosed by a border. The Line Style and Line Color buttons on the Borders toolbar let you quickly set the border's attributes. If you want to create a grid, instead of just a border that surrounds the outside edges of a range, click the dropdown arrow next to the Draw Border button (which resembles a pencil) and choose Draw Border Grid. To remove border lines, click the Erase Border button and draw over the border edges you want cleared. When you've finished, simply close the Borders toolbar to restore Excel's usual cell selection mouse pointer.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.