And best of all, it takes just a few seconds.

  1. Open a new workbook in Excel. A workbook you’re already using works too, but for the sake of simplicity, we’re going to use a new one. 
  2. Navigate to the File tab at the top of the screen, and click it to bring up new options. 
  3. Choose Options from the bottom of the left sidebar. 
  4. Next, select Quick Access Toolbar near the bottom of the left sidebar.
  5. In the opening, we talked about adding Copy and Cut, but let’s add a Paste button too. Select each (one at a time), and click Add to move them to the Quick Access Toolbar. 
  6. Click OK at the bottom once you have the options you’d like added to the Quick Access Toolbar. 

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special