The button joins the selected cells and centres the contents in the new cell. Decreases the indent by 1 or removes the indent completely. Wrap Text - Wraps the text so it is displayed on multiple lines.Īlign Left - Aligns data to the left edge of the cell.Ĭenter - Aligns data to the middle of the cell.Īlign Right - Aligns data to the right edge of the cell.ĭecrease Indent - (Ctrl + Alt + Shift + Tab). The drop-down contains the commands: Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up, Rotate Text Down and Format Cell Alignment. Rotates the current selection to a diagonal angle or a vertical angle. Middle Align - Align text to the center of the cell.īottom Align - Align text to the bottom of the cell. Top Align - Align text to the top of the cell. You can display the "Format Cells" dialog box, Alignment tab, by clicking on the dialog box launcher in the bottom right corner of this group. The drop-down contains the commands: Automatic, Theme Colors, Standard Colors and More Colors. The button changes the colour of the font of the current selection. The drop-down contains the commands: Theme Colors, Standard Colors, No Fill and More Colors.įont Color - Button with Drop-Down. The button applies a colour to the background of the current selection. The drop-down contains the commands: Bottom, Top, Left, Right, No, All, Outside, Thick Box, Bottom Double, Thick Bottom, Top and Bottom, Top and Thick Bottom, Top and Double Bottom, Draw Border, Draw Border Grid, Erase Border, Line Color, Line Style and More Borders.įill Color - Button with Drop-Down. The button applies a border to the current selection. The drop-down contains the commands: Underline and Double Underline.īorders - Button with Drop-Down. The button toggles bold on the current selection. Toggles italics on the current selection. Increase Font Size - Increases the font size of the current selection to the next larger size in the Font Size box.ĭecrease Font Size - Decreases the font size of the current selection to the next smaller size in the Font Size box.īold - (Ctrl + B).
Lets you adjust the character size (based on your current printer selection). Provides a list of all the available fonts (based on your current printer selection).įont Size - Drop-Down. You can display the "Format Cells" dialog box, Font tab, by clicking on the dialog box launcher in the bottom right corner of this group.įont - Drop-Down. The drop-down contains the command Copy as Picture.įormat Painter - Copies the format from a cell (or range) allowing it to be pasted elsewhere. Copies the current selection to the clipboard. Cuts the current selection to the clipboard.Ĭopy - Button with Drop-Down. Exactly which commands are enabled will depend on the type of object that has been copied.Ĭut - (Ctrl + X). The As Picture extension includes: Copy as Picture, Paste as Picture and Paste Picture Link. The drop-down contains the commands: Paste, Formulas (removed in 2010), Paste Values, No Borders, Transpose, Paste Link, Refreshable Web Query, Use Text Import Wizard, Paste Special and Paste as Hyperlink. The button will paste the current contents from the clipboard. You can display the Clipboard Task Pane by clicking on the dialog launcher in the bottom right corner of this group. Increase or decrease line and paragraph spacing.Īdd, change, or remove borders around text, text boxes, and tables. Justify text on the page to be left, center, or right aligned. The Microsoft Word Home tab provides many features to users, including the following.Īdd or remove highlighting color around text. Home tab is the default tab in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and other Microsoft Office products. We suggest removing conditional formatting from your spreadsheet as soon as you are done with it.In this article, we will learn What is Home Tab in Microsoft Excel & It's Uses. But the truth is that it can quickly make your Excel file heavy. Here are seven tips to reduce your Excel file size right now: Tip #1: Remove conditional formattingĬonditional formatting comes in handy when you need to highlight specific data. As seen above, you can start by focusing on the heaviest worksheets. Pick any large Excel file you want to lighten. Here is the detailed guide for finding a sheet’s name. One way to know for certain you have the right sheet is to get the exact name. If you have a lot of hidden sheets, it can become tricky to find the right one. Usually, it corresponds to the n+1 sheet in your Excel file in the above example, we could start by trimming the twenty-seventh sheet.īe careful! The n+1 rule takes into account hidden sheets. For instance, “sheet26.xml” accounts for almost one-third of the global volume. Spotting the heaviest sheets can help you choose which to start with.
0 kommentar(er)
