![]() ![]() If you made multiple formatting changes to a cell like fill color, font color, and borders, and wanted to apply those changes to other cells, then the Format Painter is a good alternative. It's important to note that F4 only repeats the last single action you took. The cell immediately was changed to yellow because it repeated the last thing I did. In the image below, I highlighted cell A6 in yellow, then selected cell A8 and hit F4. That includes formatting, inserting or deleting rows, and making changes to shapes. When you select a cell and hit F4, your last action will be repeated. ![]() Here's a post on the best keyboards for Excel shortcuts that explains what to look for in both a laptop and regular keyboard. So make sure to share them with your friends & co-workers as well.īefore we dive into the five shortcuts that use the F4 key, I want to mention that if you are using a laptop, you might have to hold down the Function key, often abbreviated Fn, in conjunction with the F4 key since those F keys can double for other purposes on your keyboard. All of these shortcuts can save you time with common daily tasks. The F4 key has a lot of different uses in Excel. On the Border tab, under Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to.F4-Shortcuts.xlsx Download Using F4 for a Variety of Shortcuts On the Border tab, under Style, click the line style that you want to apply, and then under Border, click the specific pieces of the cell border to apply the line style to. On the Home tab, under Format, point to a style and then click. On the Home tab, under Font, click Border, and then click No Border. Under Border, click the borders that you want to add or remove. Tip: To add or remove parts of a border, on the Home tab, under Font, click Border, and then click Border Options. On the Border tab, under Line Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. On the Border tab, under Line Style, click the line style that you want to apply, and then under Border, click the specific pieces of the cell border to apply the line style to. In the Style name box, type a name for your new cell style. On the Home tab, in the Styles group, click Cell Styles, and then click New Cell Style. Use cell styles to create a custom border that you can easily apply over and over again. On the Home tab, in the Font group, click the arrow next to Border, and then click No Border. Select the cell or range of cells where you want to remove the borders. Tip: To add or remove parts of a border, click More Borders at the bottom of the menu. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |