Category Excel Shortcuts

Excel Shortcuts Drag and Cut Moves the selected data to a new location without using the clipboard. Click and hold the border of the selected cells, then drag to another spot to “cut” and reposition. Shortcut Windows Mac Drag and…

Excel Shortcuts Paste Values and Number Formats Choose this option to paste values and number formats (like currency or date formatting), without preserving other types of formatting such as font color or borders. Shortcut Windows Mac Paste values and number…

Excel Shortcuts Paste Formulas and Number Formats Select this option to copy both formulas and the number formatting (e.g., currency, dates, percentages) from the source cells, while ignoring other types of formatting such as cell color or font style. Shortcut…

Excel Shortcuts Paste Column Widths This paste option duplicates only the column width settings from the source range. It’s especially helpful when you want your destination cells to match the exact column widths without copying data or formatting. Shortcut Windows…

Excel Shortcuts Paste All Except Borders This special paste transfers all data, formats, and properties except the cell borders. It helps maintain content and styling while allowing you to implement new border styles later. Shortcut Windows Mac Paste All except…

Excel Shortcuts Paste All Using Source Theme This option pastes all data (values, formulas, etc.) using the source’s theme—including colors, fonts, and styles from the original workbook. It’s useful if you want your pasted content to maintain the exact look…

Excel Shortcuts Paste Validation This option applies the data validation rules (e.g., dropdown lists, restrictions on input) from the source cells to the target cells without affecting existing data, formulas, or formatting. Shortcut Windows Mac Paste Validation Ctrl Alt V…

Excel Shortcuts Paste Comments and Notes This option places only the comments and notes from your source cells into the destination cells, leaving the existing data and formatting intact. It’s handy when you need to transfer feedback or annotations without…

Excel Shortcuts Paste Formats With this option, you transfer only the formatting—font style, cell color, borders, number formats, etc.—from the copied range to the destination, leaving the existing data unchanged. Shortcut Windows Mac Paste Formats Ctrl Alt V , T…

Excel Shortcuts Paste Values This option inserts only the resulting values of any formulas, discarding the original formulas, formatting, and other properties. It’s perfect for providing “clean” data without preserving calculations. Shortcut Windows Mac Paste Values Ctrl Alt V ,…