Saturday 28 March 2015

Removing Borders in Excel

Adding borders to cells is a very common thing in Excel. You may add them to help draw attention to number, or to divide numbers from column headings in a table.

Here is a quick way you can remove any borders applied to a cell or group of cells: simply press Ctrl+_ Ie, Ctrl + Shift + _ . (That is the underscore, which means you must hold down the Shift key as well.) Excel leaves the other formatting of the cell set, but removes any borders.