Copy and paste using the Office Clipboard - Microsoft Support
The Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document.
Clear the clipboard - Microsoft Support
To delete an individual clip, hover next to the clip, click the arrow to the right of the clip, and click Delete.
Accessibility best practices with Excel spreadsheets
What to fix. How to find it. Why fix it. How to fix it. Avoid common accessibility issues such as missing alternative text (alt text) and low contrast colors.
How to correct a ##### error - Microsoft Support
Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####. There are multiple ways to troubleshoot this such as, double-clicking the right edge of the column header, or draging it to the width you want. Note, Excel might also show ##### due to the cell …
Apply shading to alternate rows or columns in a worksheet
Another way to quickly add shading or banding to alternate rows is by applying a predefined Excel table style. This is useful when you want to format a specific range of cells, and you want the additional benefits that you get with a table, such the ability to quickly display total rows or header rows in which filter drop-down lists automatically appear.
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
Manage workbook links - Microsoft Support
Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.
LEFT, LEFTB functions - Microsoft Support
This article describes the formula syntax and usage of the LEFT and LEFTB function in Microsoft Excel.. Description. LEFT returns the first character or characters in a text string, based on the number of characters you specify.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.
Assign a macro to a Form or a Control button - Microsoft Support
You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.