Articles | Photoshop blog | Photography blog | about me | e-mail

Helen Bradley - MS Office Tips, Tricks and Tutorials

I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.

Thursday, April 12, 2007

Fixing formulas in Excel

Sometimes you need to convert formulas into fixed figures - not often I admit, but often enough that there is an Excel tool for doing this.

To convert any formula into a fixed value, select the cell or cells to fix and choose Edit > Copy and then immediately choose Edit > Paste Special > Values. Instantly your formulas are converted to fixed figures.

Labels: Excel 2003, paste special, values