On a Mac, there are a number of dedicated shortcuts for borders.
This removes all borders but it doesn't affect any content or other formatting.Īlso, Paste special has an option to copy cells without borders, which can be useful when you're coping data with borders.įinally, you can use clear formats to remove borders, but keep in mind that you'll also loose other formatting as well.
So, first off, you can remove all borders with Control + Shift + _ in Windows, Command + Option + _ on a Mac. On a mac, tick the setting on the Layout tab of the ribbon. In Windows, you can turn gridlines on and off with Alt W + VG When you working with borders in Excel, you may want to turn off gridlines so you can more easily see what you're doing.
In this video, we'll look at shortcuts to apply and remove borders.
0 kommentar(er)
