![excel keyboard shortcut fill color excel keyboard shortcut fill color](https://i.stack.imgur.com/jDJek.png)
Now select the custom style from the Home tab > Styles group > Format as Table.Set the border colors and border styles of preference.the Format button to open the Format Cells dialog box.the Set as default table style for this document checkbox.Whole Table from the Table Element list.In the New Table Style dialog box, select:.From the Home tab, in the Styles group, click on the Format as Table.Select the dataset to be made into a table.Follow these steps to set up a custom table format: Setting a custom table style can have your borders come out the same way every time you select them from Table Styles. When you add a border, by default it will be a darker shade than the color of the gridlines: The color of the gridlines will be changed now: Scroll down to the Display options for this worksheet: section and select the color for the gridlines (a shade lighter than the intended default border color).Select Advanced from the left panel of the Excel Options.Hence, the color you choose for the gridlines should be lighter than the default color you want to set for the borders. When you change the color of the gridlines, the default color of the borders (which is black) changes to the same color as the gridlines but a darker tone. One method is to hack the color of the gridlines forcing border colors to follow suit. Let’s say you’re not floating well with having to change the border color to the same color every time! With a bit of background tweaking, you can have your go-to border color set to default.
EXCEL KEYBOARD SHORTCUT FILL COLOR HOW TO
Recommended Reading: How to Rotate Text in Excel Change the Default Border Color Select the style of the border from the border menu, if need be.Once the color is selected, the cursor will change to a pencil icon which will be your border pen until you press the Esc key.Select the color of choice from the Line Color.Press the keys Alt, H, B, I one after the other.This is how to apply this keyboard shortcut to change border color: The shortcut keys for changing the cell border color are:Įnter the keys one after the other, not together.Īlt displays the shortcut keys for the ribbon tabs. Change Border Color Using Keyboard Shortcut However, for dealing with a repetitive border or a large number of cells, Format Cells would fare well with all the options open in display in one window. For each change in color and/or style, you will need to choose from the respective menus and add them using the Border buttons.Īs you can see, ease of access for our case is a bit hindered by this option, having to make separate selections for separate border styles every time.Use the Border buttons surrounding the sample field to enter the borders.In the Border tab, pick the color of choice from the Color menu and the style (if need be) from the Style section.Press Ctrl + 1 to launch the Format Cells dialog box or click the arrow with the border icon in the Home tab’s Font Select More Borders… from the menu.Select the cells with the borders requiring color change.
![excel keyboard shortcut fill color excel keyboard shortcut fill color](https://www.lifewire.com/thmb/4vjoSYUp0e7KBy6fRdr6xXsqrzk=/1032x671/filters:no_upscale():max_bytes(150000):strip_icc()/excel-spreadsheet-shortcuts-3123494-16-5c7c044246e0fb00018bd815.png)
Here’s how to arrive at the border settings using the Format Cells dialog: Change Border Color Using Format Cells Dialogīorders come under the band of cell formatting and so we can use the Format Cells options to change border colors. The keyboard-savvy way is in the segment below.
![excel keyboard shortcut fill color excel keyboard shortcut fill color](https://georgejmount.com/wp-content/uploads/2018/01/keyboard-chortcuts-to-fill-cell.png)
This was the mouse-savvy way of changing border colors from the ribbon. Handling borders from the ribbon is a very open option as you quickly get to switch between colors, border styles and add or erase borders in a matter of a few clicks, not to mention the ease of access. Clicking and dragging across a cell can add a square border and with a bit of corner-to-corner angling, you can add a diagonal border across a cell.Clicking and dragging will add a square border.To add new borders, click on the gridlines where you want to add borders.The border pen can be used as a pen and not just as a color-changing tool. Press the Esc key to return to the original cursor.Click on the borders to change their color.Once chosen, you will notice the cursor has changed to a pencil icon.From the drop-down menu, hover on to Line Color and click on your choice of border color.The Font section in the Home tab has a small border icon with a little arrow for a drop-down menu click it.The little border icon will instantly tell you where to look. The easiest approach on the Excel horizon is the ribbon with its all-encompassing menu. Change Border Color Using Keyboard Shortcut.
![excel keyboard shortcut fill color excel keyboard shortcut fill color](https://image.slidesharecdn.com/keyboardshortcutsinexcel-151006124700-lva1-app6891/95/keyboard-shortcuts-in-excel-3-638.jpg)