To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

Excel will then delete the blank cells from the selected data range. The blank cells in rows 7 and 10 are gone. (Screenshot: TechRepublic) SEE: Learn how to parse time values in Microsoft Excel ...

SEE: Explore these 87 Excel tips every user should master. Let’s add a conditional format that always highlights the current date: Select the cells or rows you want to highlight.

You’ll see the Edit Formatting Rule dialog box, where you can edit the formatting specifics of the currently selected rule. You can also change the cells the rule applies to by clicking the up ...