Shortcut for fill color in google sheets
Lesson 10: Formatting Cells Show /en/googlespreadsheets/modifying-columns-rows-and-cells/content/ IntroductionAfter you've added a lot of content to a spreadsheet, it can sometimes be difficult to view and read all of your information easily. Formatting allows you to customize the look and feel of your spreadsheet, making it easier to view and understand. In this lesson, you'll learn how to modify the size, style, and color of text in your cells. You will also learn how to set text alignment and add borders and background colors to your cells. Formatting cellsEvery cell in a new spreadsheet uses the same default formatting. As you begin to build a spreadsheet, you can customize the formatting to make your information easier to view and understand. In our example, we will be using a spreadsheet to plan and organize a garden plot. Watch the video below to learn the basics of formatting cells. To change the font size:Modifying the font size can help call attention to important cells and make them easier to read. In our example, we will be increasing the size of our header cells to help distinguish them from the rest of the spreadsheet.
To change the font:Choosing a different font can help to further separate certain parts of your spreadsheet—like the header cells—from the rest of your information.
To change the text color:
To make text bold:
Press Ctrl+I (Windows) or Command+I (Mac) on your keyboard to add italics. Press Ctrl+U (Windows) or Command+U (Mac) to add underlining. Text alignmentBy default, any text entered into your spreadsheet will be aligned to the bottom-left of a cell. Any numbers will be aligned to the bottom-right of a cell. Changing the alignment of your cell content allows you to choose where the content will appear. To modify the horizontal text alignment:
To modify the vertical text alignment:
You can apply both vertical and horizontal alignment settings to any cell. Cell borders and background colorsCell borders and background colors make it easy to create clear and defined boundaries for different sections of your spreadsheet. To add cell borders:
To change the fill color:It's easy to change the background color of any cell, which is known as the fill color.
Formatting text and numbersThe ability to apply specific formatting for text and numbers is one of the most powerful tools in Google Sheets. Instead of displaying all cell content in exactly the same way, you can use formatting to change the appearance of dates, times, decimals, percentages (%), currency ($), and much more. Learn more about formatting numbers in our
Understanding Number Formats lesson. Challenge!
/en/googlespreadsheets/working-with-multiple-sheets/content/ What is the shortcut key to fill color?Keyboard Shortcut to Fill Color in Cells
To use this keyboard shortcut, you first need to select the cell or the range of cells in which you want to fill the color and then hit these keys in succession (ALT then H, and then H).
What is Ctrl D in Google Sheets?Ctrl+D in Excel and Google Sheets
In Microsoft Excel and Google Sheets, pressing Ctrl + D fills and overwrites a cell(s) with the contents of the cell above it in a column. To fill the entire column with the contents of the upper cell, press Ctrl + Shift + Down to select all cells below, and then press Ctrl + D .
What is Ctrl E in Google Sheets?Google Sheets Keyboard Shortcuts for Windows and Mac. |