1. Start typing the same text in multiple columns.
  2. CTRL + Click each instance of the name. You’ll only need two or three instances for Excel to recognize the pattern, so you won’t need to do this for long.
  3. Continue CTRL + Clicking the empty spaces the name will go.
  4. Once done, type the name one last time and press CTRL + Enter. You’ll see the name has now been filled in each empty column you selected.
  5. Repeat these steps for additional names or titles.

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