Maximize Productivity with Excel Tools and Shortcuts
One of Excel's most useful tools for modifying the look and function of the spreadsheet data is the format cells dialog box.
It is readily accessible in a number of ways:
Keyboard shortcut: Ctrl + 1 is a keyboard shortcut (use the number key from the top row, not the numpad).
Use the right-click menu to: Select Format Cells with a right-click on a cell.
Ribbon: Select the Home tab and then click the tiny arrow located in the lower-right corner of the Font, Alignment, or Number groups.
It contents following tools
1. Font face/ Font style
You can alter a font face, also known as a font style, by utilizing font face.
Also Use Ctrl+Shift+F for change the font face.
2. Font Size
You can change a font size, by utilizing font size.
Also Use Ctrl+Shift+P for change the font size.
3. Grow font
You can also increase a font size, by utilizing grow font.
Also use Ctrl+> for increase a font size.
4. Shrink font
You can also decrease a font size, by utilizing shrink font.
Also use Ctrl+< for decrease a font size.
5. Bold, Italic & Underline
In Excel, select the cell and select the desired format on the Home tab to make text or numbers in the cell bold, italic, or have a single or double underline. Click the ribbon's bold button to make the headings bold. The style is activated by the first click and deactivated by the second click. The underlining and italic styles function similarly.
Additionally, use the shortcuts Ctrl+B to bold a font, Ctrl+I to italicize a font, and Ctrl+U to underline a word.
6. Border
Excel borders are an excellent way to visually arrange your data, draw attention to important areas, and make it easier to understand.
How to Use the Borders Tool in Excel
a. Adding Borders
Choose which cells to format.
Go to the Home tab → Font group → click the Borders icon.
Select from choices such as:
- All Borders
- Outside Borders
- Thick Box Border
- Top/Bottom/Left/Right Borders
b. Using the Format Cells Dialog
- Select your cell range.
- Press Ctrl + 1 to open Format Cells.
- Go to the Border
- Choose line style, color, and which sides to apply the border to.
c. Using Keyboard Shortcuts
- Ctrl + Shift + _: Remove all borders.
- Alt + H + B + A: Add all borders.
d. Drawing Borders Manually
- Click the Borders dropdown → choose Draw Border or Draw Border Grid.
- Use your mouse to sketch borders around cells.
7. Fill color and Font color
Changing the fill and font colors in Microsoft Excel is a simple way to improve the look and layout of your spreadsheets.
a. Changing to the color of the cell fill
Choose the cells: Choose the cells or group of cells whose fill color you wish to change.
Select the "Home" tab: On the ribbon, select the "Home" tab
Select a fill color:
Next to the Fill Color button (the paints icon), click the arrow.
Choose a shade from the "Standard Colors" or "Theme Colors" palettes.
Simply click the Fill Color button without bringing up the drop-down menu to apply a recently used custom color.
Select "More Colors" and then pick the color you want from the "Colors" dialog box to create a custom color.
Shortcut: For fill color Alt+H, H.
b. Changing the color of the font
Choose the cells: To modify the text, pick the cell or group of cells that contain it. Additionally, you can pick just a section of the text in a cell.
Select the "Home" tab: On the ribbon, select the "Home" tab.
Select the color of the font:
On the Font Color button (shown by a capital 'A' with a colored underline), click the arrow next to it.
Choose a shade from the "Standard Colors" or "Theme Colors" palettes.
Just click the Font Color button without bringing up the drop-down menu to apply the most recent color selection.
To pick a custom color, select "More Colors" and use the "Colors" dialog box to pick or make the color you want.
Shortcut: For fill color Alt+H, F,C.
This blog contains some quickie information about Excel tools, about new features explained in the link below.
https://olivaa.odoo.com/blog/excel-5/excel-alignment-techniques-77