How-To Geek on MSN

6 formatting tips I wish I knew when I started using Excel

When I started using Microsoft Excel, my spreadsheets were a mess, and I wasted hours trying to make them look professional. If you're struggling with manual formatting, these six simple tips are the ...
How-To Geek on MSN

Stop using format painter in Excel: Find and replace formatting instead

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...
How-To Geek on MSN

The 4 Excel find and replace tricks I use to save hours

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
How-To Geek on MSN

The secret Excel pop-up: How I create cell tips without using notes or comments

Visual chaos: The alternative to the slow, stop-start process is clicking "Show All Notes" or "Show Comments" in the Review tab to keep them on-screen at all times. The moment you do this, you're ...
How-To Geek on MSN

I use Excel all day—the simple Ctrl+1 shortcut does 80% of the work

Ctrl+1 streamlines the Excel workflow, efficiently handling most of my day-to-day and advanced formatting needs. Universal ...