410-208-3933 11004 Manklin Meadows Lane, Unit 1, Ocean Pines, MD 21811

410-208-3933
        | Client Support | Blog

Cards Blog

Cards Blog

Excel: How to Make the Same Change Fast Across Worksheets

Cards Technology

If you work with multiple tabs in Excel routinely, you know the pain of searching through each tab to make the same change repeatedly. You also probably know these changes can be made with the Search/Replace function but – step away from the search key! – here’s a quicker way to make the same change across worksheets.

  • Hold the Control key on your keyboard (or Command for Mac users)
  • Select the tabs of your workbook
  • Revise the cell that needs a change

Bada bing bada boom – all cells changed! Let’s take a look…


OK, OK. That was a really short (although very cool) tip so here’s a bonus Excel tip

When you want to put today’s date into a worksheet cell, just type Ctrl+; in the cell. Add the time by pressing Ctrl+Shift+;

Get more Excel tips and tricks here