Home Tab

Clipboard

You can open the Clipboard Task Pane by clicking the dialog launcher in the bottom right corner of the group.

Paste- The Paste button with a drop-down menu allows users to paste current clipboard contents. The available commands include Paste, Paste Values, No Borders, Transpose, Paste Link, Refreshable Web Query, Use Text Import Wizard, Paste Special, and Paste as Hyperlink. The extension for As Picture provides commands such as Copy as Picture, Paste as Picture, and Paste Picture Link. The specific commands enabled depend on the type of object copied.

Cut (Ctrl + X) is a command used to remove the selected content from its current location and place it onto the clipboard for potential reuse or pasting elsewhere.

Copy- Copying the current selection to the clipboard is accomplished via the Copy button (Ctrl + C), which features a drop-down including the option "Copy as Picture."

Format- Format Painter allows users to copy the formatting of a cell or range and apply it to other cells.

Font

You can access the "Format Cells" dialog box, Font tab, by clicking the dialog box launcher in the bottom right corner of the group.

Font - Drop-Down feature presents users with a comprehensive list of all available fonts that correspond to the selected printer, allowing for easy selection and customization of text appearance in documents.

Font Size - Drop-Down allows you to modify the size of characters according to your current printer selection.

Increase Font Size-  Increasing the font size adjusts the current selection to the subsequent larger size available in the Font Size box.

Decrease Font Size -Decreasing the font size adjusts the current selection to the next smaller size available in the Font Size box.

Bold -Bold formatting can be activated or deactivated in the current selection using the keyboard shortcut Ctrl + B.

Italic - Italic (Ctrl + I) is a function that toggles italics on the current selection of text.

Underline - Underlining is performed using the keyboard shortcut Ctrl + U. There is a button that allows toggling the bold formatting on the selected text. Additionally, this button features a drop-down menu that includes options for applying Underline and Double Underline to the selected text.

Borders - Button with Drop-Down allows users to apply various border styles to selections, including options such as Bottom, Top, Left, Right, No, All, Outside, Thick Box, and various double and thick borders. It also provides commands for drawing, erasing borders, and selecting line color and style.

Fill Color - Fill Color includes a button that applies a background color to the selected item, featuring a drop-down with options for Theme Colors, Standard Colors, No Fill, and More Colors.

Font color - The button alters the font color of the selected text and features a drop-down menu with options for Automatic, Theme Colors, Standard Colors, and More Colors.

Alignment

You can open the "Format Cells" dialog box, Alignment tab, by clicking the dialog box launcher in the bottom right corner of this group.

Top Align: Aligns text to the top of the cell.

Middle Align: Centers text within the cell.

Bottom Align: Aligns text to the bottom of the cell.

Orientation: A drop-down menu to rotate text selection; options include Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up, Rotate Text Down, and Format Cell Alignment.

Left to Right Text Direction: A drop-down (introduced in 365) for setting text direction; includes Left-to-Right, Right-to-Left, and Context commands.

Wrap Text: Allows text to be displayed on multiple lines.

Align Left: Aligns data to the left edge of the cell.

Center: Aligns data to the middle of the cell.

Align Right: Aligns data to the right edge of the cell.

Decrease Indent: (Ctrl + Alt + Shift + Tab) decreases the indent by 1 or removes it completely.

Increase Indent: (Ctrl + Alt + Tab) increases the indent by 1.

Merge & Center: A button with a drop-down that merges selected cells and centers the content; options include Merge & Center, Merge Across, Merge Cells, and Unmerge Cells. Merge Across only merges cells in the same row.

Number

The "Format Cells" dialog box can be accessed by clicking the dialog box launcher located in the bottom right corner of the group within the Number tab.

Number Format - Provides a list of available number formats: General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, and Text.

Accounting Number Format -Accounting Number Format features a button that applies the default format to selected items, with a drop-down offering commands for English (UK), English (US), Euro, and additional accounting formats.

Percent Style - Percent Style (Ctrl + Shift + %) applies the percent number format to the selected cells.

Comma Style - Comma Style applies a comma style number format to the selected text.

Increase Decimal - Adds one decimal place to the current selection.

Decrease Decimal - Removes one decimal place from the current selection.

Styles

Conditional Formatting - Drop-Down allows users to automatically apply cell formatting with various commands, including Highlight Cells Rules, Top/Bottom Rules, Data Bars, Color Scales, Icon Sets, New Rule, Clear Rules, and Manage Rules.

Format as Table - Drop-Down applies a Table Style to the current selection and defines it as a table, offering commands for Light, Medium, Dark, New Table Style, and New PivotTable Style. The latter two open their respective dialog boxes for customization.

Cell Styles - Drop-Down enables the application of various cell styles to selected cells. The available commands in the drop-down menu include Custom, Good Bad and Neutral, Data and Model, Titles and Headings, Themed Cell Styles, Number Format, New Cell Style, and Merge Styles. Selecting New Cell Style opens the "Style" dialog box.

Cells

Insert - The Insert button with a drop-down allows users to insert cells into the current selection, causing existing cells to shift down. The drop-down features commands for inserting cells, sheet rows, sheet columns, and new sheets.

Delete - The Delete button facilitates the deletion of the current selection by shifting cells upward. Its drop-down menu includes options for deleting Cells, Sheet Rows, Sheet Columns, and the entire Sheet.

Format - Drop-Down format offers a range of commands for managing rows, columns, and sheets, including Row Height, AutoFit Row Height, Column Width, AutoFit Column Width, Default Width, Hide & Unhide, Rename Sheet, Move or Copy Sheet, Tab Color, Protect Sheet, Lock Cell, and Format Cells. The Hide & Unhide feature specifically includes options to Hide Rows, Hide Columns, Hide Sheet, Unhide Rows, Unhide Columns, and Unhide Sheet.

Editing

AutoSum - AutoSum is a button with a drop-down menu that provides the same command available on the Formulas Tab.

Fill - Drop-Down allows users to fill selections in various directions and across adjacent cells, offering commands such as Down, Right, Up, Left, Across Worksheets, Series, Justify, and Flash Fill (introduced in 2013).

Clear - Drop-Down allows users to remove current selections or specific items by expanding the options. Available commands include Clear All, Clear Formats, Clear Contents, Clear Comments, and Clear Hyperlinks (added in 2010), along with Remove Hyperlinks (added in 2010).

Short & Filter - Sort & Filter features a drop-down that allows sorting selected data in ascending or descending order, along with options to filter visible rows. The commands available include Sort A to Z, Sort Z to A, Custom Sort, Filter, Clear, and Reapply.

Find & select - The drop-down menu includes commands for Find, Replace, GoTo, GoTo Special, Formulas, Comments, Conditional Formatting, Constants, Data Validation, Select Objects, and Selection Pane.