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+;